7

When the index was rebuilt, which is in the target table of a batch job, the cursor was disappeared getting the following error message.


Error message:

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.


I understand the index rebuild must be performed to maintain high availability when fragmentation occurs within the table, which is the target of a batch job. However, I would rather say it is incomplete to maintain high availability if the cursor is lost and the error is displayed when rebuilding indexes on table that is the target of batch job. Therefore, I would like to request to improve the system so that no cursor is lost, and no error occurs when rebuilding indexes in tables which is the target of batch job.

Category: Data Management
STATUS DETAILS
New