When I launch a big script (~30mb) with the isql or osql command-line utility, I get this error. There are go statements every 100 statements and I have plany of available memory on my machine. Does anyone know what could be causing this or have a solution

Thanks in advance
Pau

I agree with Hari in that you should use oSql instead. My guess is that you
are returning a lot of rows and they must be stored somewhere. That usually
eats up a lot of client side memory, even if you had a lot to start with.
Do you have SET NOCOUNT ON at the beginning of the script?

--

Andrew J. Kelly
SQL Server MVP


[quoted text, click to view]
utility, I get this error. There are go statements every 100 statements and
I have plany of available memory on my machine. Does anyone know what could
be causing this or have a solution?
[quoted text, click to view]

Hi,

Rather than using ISQL , try using OSQL from command prompt.

In addition please check the virtual memory allocated to your machine.

Thanks
Hari
MCDBA

[quoted text, click to view]
utility, I get this error. There are go statements every 100 statements and
I have plany of available memory on my machine. Does anyone know what could
be causing this or have a solution?
[quoted text, click to view]