Could not complete cursor operation because the table schema changed

Microsoft SQL Server 2000 - 8.00.2039

Got this error:

Could not complete cursor operation because the table schema changed after the cursor was declared. SQLCode: 16943 SQLState: HY000

Is this a known issue? I suspect the application logic may cause this error. Please advise.

Thanks a lot!

Hi,

are you doing schema modifications within your cursor ? If so the fetch of a new row will break as SQL Server cant validate the underlying existing schema at the beginning of the cursor declaration / opening. If you don't have any clue about the cursor run profiler to see what is executed (procedure or any code) on the server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de