Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL server 2005 query analyzer Insufficient memory

Author  Topic 

bashkutty
Starting Member

2 Posts

Posted - 2012-03-06 : 23:57:41
I am running a .sql file containing a large number of delete and insert statements, using SQL server 2005 query analyzer to run this script i got the error message "Insufficient memory to continue the execution of the program. (mscorlib)". I am using Windows xp as operating system with 4 GB of RAM. How we can solve this issue

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-07 : 00:15:16
Can you break up the script into multiple files and run them consecutively? Does the script have output? Add SET NOCOUNT ON? Try running the sql file through sqlcmd?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

bashkutty
Starting Member

2 Posts

Posted - 2012-03-07 : 00:44:34
Thanks for your reply. How we can run the sql file through sqlcmd?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-07 : 15:11:32
Here's an example: sqlcmd.exe -Sserver1\instance1 -E -ic:\somescript.sql

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-07 : 15:21:17
what's "large"

Are you doing commits every so often?


How big is your log dear Liza

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -