Wednesday, September 11, 2013

insufficient memory to continue the execution of the program (mscorlib)

When Sql script is too large then it gives message "insufficient memory to continue the execution of the program (mscorlib)"

To overcome this we can use commands in the command prompt to run the scripts instead. Below Is an exmaple of such a script:
osql -S <SQL Server IP/Name> -d <DB Name> -E -i <sql script file path>
-S ServerName Such as localhost
-d database if you are creating database by script then no need to use this
-U userid you can define when database is defined in above script
-P password
-E trusted connection

No comments:

Post a Comment