Getting error while running 50 MB script on SQL Server 2008 R2
If credentials are required
sqlcmd -S <ComputerName>\<InstanceName> -U <username> -P <password> -d <DatabaseName> -i <MyScript.sql>
Adding to @user1293068's answer, I needed to specify the instance name. Here is my full syntax:
sqlcmd -S <ComputerName>\<InstanceName> -d <DatabaseName> -i <MyScript.sql>
This is documented on Technet's Use the sqlcmd Utility article.
(Note that you must enter a switch value of "-S", not "-s". The switch is case-sensitive.)
use the command-line tool SQLCMD which is much leaner on memory. It is as simple as:
SQLCMD -d <database-name> -i filename.sql
You need valid credentials to access your SQL Server instance or even to access a database
You can also try increasing the Maximum Server Memory value in server properties.
To edit this setting, right click on server name and select Properties > Memory tab.
I encountered this error trying to execute a 30MB
SQL script in SSMS 2012.
After increasing the value from 1024MB
to 2048MB
I was able to run the script.