Could not complete cursor operation, because the table schema changed after cursor was declared 
Author Message
 Could not complete cursor operation, because the table schema changed after cursor was declared

I had this same problem today and it turned out that the internal
application running on the pc was executing a deletion against the
MSSQLServer 2000 database that took a very long time. A short time after
the deletion started the MSSQLServer database maintenance plan was
started running, the part that reindexes the tables. When it got to the
table that the deletion query was against the deletion query spid became
blocked then after some time reported the error 'Could not complete
cursor operation because the table schema changed after the cursor was
declared'. The maintenance plan was reindexing(dropping and recreating
the index) which is a table schema change while the application had a
cursor open to deletion the data from the table. The deletion against
the table of course did not get committed so the table was not cleaned
out properly. You may try using the profiler on your database to see
what queries are executing at the time you receive the error, this was
how I was able to find the problem.

Jessica Cabinian

--
Posted via dBforums
http://www.***.com/



Wed, 01 Dec 2004 14:12:23 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Could not complete cursor operation, because the table schema changed after cursor was declared

2. Err Msg Help: Could not complete cursor operation because the table schema changed after the cursor was declared

3. COULD NOT COMPLETE CURSOR OPERATION

4. Error: Could not complete cursor operation because table schema changed....

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

6. SQL7: Not enough storage is available to complete this operation

7. Not enough storage is available to complete this operation

8. Not enough storage is available to complete this operation

9. not enough storage is available to complete this operation

10. not enough storage is available to complete this operation

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

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


 
Powered by phpBB® Forum Software