For my own future reference, when I get a large SQL file, large enough that SSMS freaks out about lack of memory, I need to use Sqlcmd tool. And here how it is done:
sqlcmd -S localhost\sqlexpress -d MyDatabaseName -i .\InputFileName.sql
Note that localhost
is important to put there, if you try to connect to .\sqlexpress
, you will only get a connection error