Having trouble executing a large SQL script using the SQL server management studio?
Use the command line tool sqlcmd
sqlcmd -S server\instance -i script_file.sql
This should work, unless you have errors in your script of course 😉
Don’t forget to start your script with a correct use statement.