Loading script in Query analyzer gives error not enough storage...

[sonname]

I have a rather large sql script(277,553 KB) that I am trying to open in query analyzer and I get the error "The operation could not be completed. Not enough storage available to complete this operation". I'm pretty sure it is because the script is too large because when I seperate the file into smaller chunks it opens up fine. Is there a limit to the amount of script that sql can load? Is there anything that can be done to increase the amount that it can open? Thanks

 

[vbkris]

>> Is there a limit to the amount of script that sql can load?

hmm, on first thoughts this looks like a memory issue. how much RAM is available in the system in which you are opening query analyser???

Known is handfull, Unknown is worldfull

 

[sonname]

I have 2 GB of Ram.

 

[vbkris]

whoa!
no idea immediately on this ...

Known is handfull, Unknown is worldfull

 

[monksnake]

sonname, do you receive any other error messages along with what you originally posted?

<.

 

[sonname]

I get a Microsoft SQL Server Management Studio dialog box that says "The operation could not be completed. Not enough storage is available to complete this operation".