SQL7: Not enough storage is available to complete this operation 
Author Message
 SQL7: Not enough storage is available to complete this operation

We have occasionally been getting this error message from our SQL7 server:

Not enough storage is available to complete this operation

It will show up in a web page when we are trying to write data to the
database.  We have plenty of space available on the drive SQL resides on.
The table we're writing to is only about 13Mb and is set to auto-grow by
10Mb increments.  It is also set to unlimited growth.

Can anyone tell me where this comes from and how I can fix it?  I've also
been told that the problem can be reproduced by having 2 simultaneous writes
to this same table.  I think there's an error of some kind, but I'm not
convinced yet that it's actually a 'lack of storage' problem.  I can stop
the SQL Server and restart that service and the problem goes away.

Please respond via email.  Thanks in advance.

Rad...



Mon, 03 Sep 2001 03:00:00 GMT
 SQL7: Not enough storage is available to complete this operation

Rad,

 What is the exact error message - is it definitely coming from SQL Server, or
could it be an NT message?  (in which case, reapply the NT service pack).  I
know that SP1 for SQL 7 will be addressing one of these issues..

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Tue, 04 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Memory issue (Not enough storage is available to complete this operation )

2. Not enough storage is available to complete this operation

3. Not enough storage is available to complete this operation

4. not enough storage is available to complete this operation

5. not enough storage is available to complete this operation

6. Error 0x8007000E - Not enough storage is available to complete this operation

7. Not enough storage is available to complete this operation

8. Not enough storage to complete this operation

9. Error: [SQL-DMO]not enough storage is available to complete this opperation

10. ADO: Connection Error: Not enough storage to complete

11. sorry there is not enough memory to complete this operation

12. error - There is not enough memory to complete operation


 
Powered by phpBB® Forum Software