November 1, 2006 at 4:14 pm
We are trying to run a huge sql query around 90 meg to get a database back up and running. I've tried running the sql file from the command line and query analyzer I keep getting this error. The server I'm using has 4 gigs in the box.
Server: Msg 701, Level 17, State 1, Line 4031
There is insufficient system memory to run this query.
November 1, 2006 at 10:24 pm
Ahh, the Devil's in the detail isn't it.....
Can you show us the query and the ddl please ?
And maybe some details of the machine you running the query from (Available RAM would be good)
And do you mean the server has 8 gigs of memory ? (Which is probably not the issue, one hopes)
(I probably won't be back until the end of next week so can someone else take this up please.)
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
November 2, 2006 at 5:20 am
Actually the problem was thew query it was formatted wrong so the query just kept running. We finally noticed several syntax errors such as missing commas after we corrected them the script ran fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply