Shortcuts

Using SQLCMD to execute large SQL batches

By: Joseph Styons

Posted on: February 8, 2013

Have you ever had a very large SQL script in a .SQL file, and you wanted to run it against your favorite database? You may have naively thought (as I did) that you could just crack that baby open in SQL Server Management Studio, and hit F5. If you did that, you may have found that SSMS doesn’t take well to those.  It will sometimes give you an “out of memory” error. That can be overcome by running the script from inside SQLCMD.   This is an example script for doing that 1: set sqlcmdexe=C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqlcmd.exe 2: set domain=BLACKBAUDHOST 3: set user... Read More

Developing on a machine that has 2 SDKs.

By: Chris Whisenhunt

Posted on: May 16, 2012

Some of you may have both VS2008 and VS2010 installed on your machine and are developing against a 2.9 and 2.91 versions. Well if you haven’t already had to constantly run the SetCurrentSDK.bat files then you will soon enough. I just created some batch files to make my life a little easier. The first part of this is to alter the SetCurrentSDK.bat files by removing the “pause” at the end of the files.   rem Blackbaud AppFx SDK version switch utility rem Copyright 2012, Blackbaud, Inc.  All rights reserved. @echo off SetCurrentSDK.exe /s=localhost /db=OSU /VERBOSE /WAITONERROR @echo Blackba... Read More
Categories:

Privacy Policy | Sitemap | © 2011 Blackbaud, Inc. All Rights Reserved

Digital Ocean