===========================<br>ODBC Error Code = 37000 (Syntax error or access violation)<br><br>[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query.<br>============================<br><br>Im using CF code to access the SQL database. There are couple of SQL queries to generate an output.<br><br>But...I constantly seem to be getting this error after a few days .... the memory gets totally eaten ! Has anyone gone thru this problem before ?????<br><br>F/S <p> <br><a href=mailto: > </a><br><a href=
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
insufficient system memory to run this query. (could someone explain)
- Thread starter firesign
- Start date
nasirnaqvi
MIS
Dear I'm asuming that you've Win-NT/4 with 64MB RAM on "NTFS". Please just go to control panel's "system/Performance/change" to change your virtual memory size, since this is that problem not a SQL-Server problem.
- Status
Similar threads
- Locked
- Question
- Locked
- Question