Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error 16943 Expand / Collapse
Author
Message
Posted Wednesday, March 9, 2005 10:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 18, 2006 12:29 PM
Points: 1, Visits: 1
Hi,

The message 16943 (Could not complete cursor operation because the table schema changed after the cursor was declared) is ocurring many times at the user application.

How to trace it??

Thanks

Claudine
Post #166638
Posted Monday, March 14, 2005 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #167468
Posted Monday, March 14, 2005 2:02 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2008 4:19 PM
Points: 110, Visits: 17

Have you tried SQL Profiler or Trace Flags?

Marty

Post #167596
Posted Thursday, March 31, 2005 8:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 1:19 PM
Points: 471, Visits: 841
A client of ours received this error as well.  It was during an optimization.  Everything I can find would pin it on teh off chance that the index was dropped for the optimization job after the cursor was prepared but before it executed.  We have not seen it again to my knowledge.  I beleive it was an off chance rarity.  Have you encountered this error often?
Post #171221
Posted Tuesday, April 12, 2005 4:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 27, 2005 7:58 AM
Points: 4, Visits: 1

Im seeing the same thing, over and over again. Some where on microsoft site I seen that it was an issue with SQL Server 7.0 and the possibility that Service Pack 1 had fixed it.

H.

Post #173989
Posted Friday, April 29, 2005 11:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 3, 2005 10:09 AM
Points: 1, Visits: 1

In my environment the error is reproducable on SQL 2000 SP3 + WS2003 SP1.

During an update of a huge table (100M records) in a loop within a stored procedure the statement

update item_word set realWordID = @realWordID where current of cur_item_word

results in 16943. Also the counter of last updated record is > total number of records in the table being updated.

 

 

Post #178883
Posted Friday, April 24, 2009 12:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 20, 2010 10:46 AM
Points: 1, Visits: 6
Hi!

I've got the same error, but in a specific situation as follows:

I had a cursor to a table which I was planning to change a column during the cursor execution. My ALTER TABLE statement was placed some lines after the OPEN CURSOR statement, between the FETCHs and the OPEN CURSOR. Moving the alter table statement to be executed before the OPEN CURSOR solved this problem, but I didn't find a way to change the table during its cursor execution...
Post #704237
Posted Saturday, October 16, 2010 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 16, 2010 7:43 AM
Points: 1, Visits: 2
Try to use static Keyword. "Declare Cursor Static For"
in my case it worked.
Post #1005730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse