SQL Server 2005 Error 701 - out of memory

Posted by Tufo on Stack Overflow See other posts from Stack Overflow or by Tufo
Published on 2010-02-19T12:57:22Z Indexed on 2010/03/17 2:41 UTC
Read the original article Hit count: 392

Filed under:
|
|

I'm currently having following error message when executing a .sql file with about 26MB on SQL Server 2005:

Msg 701, Level 17, State 123
There is insufficient system memory to run this query.

I'm working with 4GB RAM, 64Bit Windows 7 Ultimate, Core2Duo T6400(2GHz)...

Is there a way to execute it without receiving this message (maybe force SQL Server to use swap file?) or a way to execute it in parts (like 100 queries a time)...

The file is basically a CREATE TABLE followed by thousads of INSERT queries and I have a lot of those (converted .DBF files to SQL queries using ABC DBF Converter)

Any idea will be very appreciated!

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about memory