Post reply

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

  • March 9, 2007 at 11:34 am

    #90964

    I am receiving this error  in sql2000 sp4. It just started I suspect triggers but would like some input.

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

  • March 9, 2007 at 1:33 pm

    #694184

    This is a pretty straight forward error message and it means exactly what it says.  Something has changed your table schema while the cursor was open.  If you can reproduce this, I would suggest running a Profiler trace and looking closer at what else is happening. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 9, 2007 at 5:17 pm

    #694205

    Auto-shrink can cause this error, if the auto-shrink kicks in and re-arranges data pages while the cursor is open. Same with maintenance plans that do re-indexing.

    Check neither of these are scheduled while your cursor process is running.

     

  • March 29, 2007 at 10:54 pm

    #697801

    Thanks PW, exactly that was problem in my case for this same problem. A job was scheduled

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply