SQL Server – Running large script files

use the sqlcmd tool to execute the file..

sqlcmd -S myServer\instanceName -i C:\myScript.sql

In case your have an unexplained “script error” for large sql files (> 100MB) which includes several INSERT, just replace “INSERT INTO” by “GO INSERT INTO” in your file, which will reduce size of transaction.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)