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
No comments:
Post a Comment