Error Msg 701(on sql2000)no insufficient system memory to run q

Hi.
When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
line number varies).
To solve this problem, I setupped sq4(the exe file name is
SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
And then I tried to run this procedure again: Statistic_R401, but the server
still told me this error.
The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
is Win2003 Enterprise.
If I wont upgrade the hardware, how will I solve it? Thank you!
yangHi,
You have very less amount of memory in you server. Probaly some other
program would have taken all the memory. Just verify the memory usage.
I suggest you to make the SQL Server memory to 350 MB and restart the SQL
Server and see.
My recommendation is try increasing the RAM to 1 GB..
Thanks
Hari
"faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
> Hi.
> When I ran a procedure in sql2000, I hit this problem: Error Msg
> 701,Level
> 17,State 106,the procedure Statistic_R401(the procedure's name),line
> 37(the
> line number varies).
> To solve this problem, I setupped sq4(the exe file name is
> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039
> now.
> And then I tried to run this procedure again: Statistic_R401, but the
> server
> still told me this error.
> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
> is Win2003 Enterprise.
> If I wont upgrade the hardware, how will I solve it? Thank you!
> yang|||Also, it might be worth to check if someone has fiddled with the sp_configure settings.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23hA9ro1FHHA.4804@.TK2MSFTNGP03.phx.gbl...
> Hi,
> You have very less amount of memory in you server. Probaly some other program would have taken all
> the memory. Just verify the memory usage.
> I suggest you to make the SQL Server memory to 350 MB and restart the SQL Server and see.
> My recommendation is try increasing the RAM to 1 GB..
> Thanks
> Hari
> "faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
> news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
>> Hi.
>> When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
>> 17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
>> line number varies).
>> To solve this problem, I setupped sq4(the exe file name is
>> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
>> And then I tried to run this procedure again: Statistic_R401, but the server
>> still told me this error.
>> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
>> is Win2003 Enterprise.
>> If I wont upgrade the hardware, how will I solve it? Thank you!
>> yang
>