|
Home > Archive > MS SQL Server > December 2006 > Error Msg 701(on sql2000)---no insufficient system memory to run q
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error Msg 701(on sql2000)---no insufficient system memory to run q
|
|
| faithdiffla 2006-12-04, 12:12 am |
| 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
| |
| Hari Prasad 2006-12-04, 12:12 am |
| 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@discussi
ons.microsoft.com> wrote in message
news:111E8747-887C-472C-A446- 85EFDDEF7D6B@microso
ft.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
| |
| Tibor Karaszi 2006-12-04, 7:12 pm |
| 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@hotmai
l.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@discussi
ons.microsoft.com> wrote in message
> news:111E8747-887C-472C-A446- 85EFDDEF7D6B@microso
ft.com...
>
>
|
|
|
|
|