Monday, December 27, 2010

Run Large SQL Script Files sql server 2005

Sql server 2005 management studio do not support execution of sql files larger than 50 MB .
but if we have script files larger than 50MB we can execute them by using SQLCMD tool like
that

SQLCMD -S MyServer -d MyDatabase -E -i C:\Scripts\MyScriptFile.sql