Today’s quick tip is brought to you by the following error message:
I received that when trying to import a 31,000 line SQL file via SQL Server Management Studio. If you’re just trying to run a single script, you can drop into a command line and use sqlcmd:
sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\EmpAdds.txt
Via Microsoft Technet: Run Transact-SQL Script Files Using sqlcmd.