SQL Server: Run A Very Large Script By Splitting It Into Pieces Using PowerShell

Everyday is an interesting day in the life of a DBA. Today, I received a request to run in a HUGE script. This script had 125k INSERT statements each in a separate line. Just opening the script was an issue, leave alone running it into a database. You get this error in SSMS just trying … Continue reading SQL Server: Run A Very Large Script By Splitting It Into Pieces Using PowerShell

Advertisements

SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)

In mature IT shops, all deployment scripts in a release are run into the database using command-line batches as opposed to doing it by hand. Error running SQLCMD scripts in SSMS Occasionally, when one is testing a single script within a release to make sure it works, he/she needs to jump to the command line to … Continue reading SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)