some times you have to run a large SQL script in SQL server and “Sql Server Management Studio” dies when you load the large file.
To import / run the large script you need to use SQL Server command line tool sqlcmd
there are many parameters for this command line toll use this for full list
open command prompt and issue following command.
Use following example command to execute a Large SQL Script.
sqlcmd -U MY_USER_NAME -P MY_PASSWORD -d DATABASE_NAME -i PATH_TO_SQL_FILE.sql -o PATH_TO_OUTPUT_FILE.txt
the above command will look like this for
user : sa
password : ok
script to import : script.sql
sqlcmd -U sa -P ok -d mydatabase -i d:\script.sql -o d:\MyOutput.txt
I hope this will help.