Sunday, February 26, 2012

Error : insufficient system memory

Hi,
We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
issues. As soon as we installed the Database on Windows 2003 we are getting
the error saying that there is insufficient system memory. We get this at
least twice every week. Once this error happens most of SQL statements give
similar error message when run from query analyzer.
Kindly provide some help on this.
Here is the error message
SQLState: 42000, ErrorCode:701
[Microsoft][ODBC SQL Server Driver][SQL Server]There is insuffic
ient system
memory to run this query.You might want to give MS PSS a call:
http://support.microsoft.com/defaul...id=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
Andrew J. Kelly SQL MVP
"LSolve" <LSolve@.discussions.microsoft.com> wrote in message
news:42FBA2DD-8B32-48E2-9CFD-805E88A6DCDA@.microsoft.com...
> Hi,
> We ran our application on Windows 2000 with SQL 2000 SP3a, and had no
> issues. As soon as we installed the Database on Windows 2003 we are
> getting
> the error saying that there is insufficient system memory. We get this at
> least twice every week. Once this error happens most of SQL statements
> give
> similar error message when run from query analyzer.
> Kindly provide some help on this.
> Here is the error message
> SQLState: 42000, ErrorCode:701
> [Microsoft][ODBC SQL Server Driver][SQL Server]There is insuff
icient
> system
> memory to run this query.
>

No comments:

Post a Comment