SQL Server Errors or Failures from Error: 16942 to Error: 16962

SQLServerF1

 

Error: 16942, Severity: 16, Could not generate asynchronous keyset. The cursor has been deallocated.
Error: 16943, Severity: 16, Could not complete cursor operation because the table schema changed after the cursor was declared.
Error: 16945, Severity: 16, The cursor was not declared.
Error: 16946, Severity: 16, Could not open the cursor because one or more of its tables have gone out of scope.

Error: 16947, Severity: 16, No rows were updated or deleted.
Error: 16948, Severity: 16, The variable ‘%.*ls’ is not a cursor variable, but it is used in a place where a cursor variable is expected.
Error: 16949, Severity: 16, The variable ‘%.*ls’ is a cursor variable, but it is used in a place where a cursor variable is not valid.
Error: 16950, Severity: 10, The variable ‘%.*ls’ does not currently have a cursor allocated to it.
Error: 16951, Severity: 16, The variable ‘%.*ls’ cannot be used as a parameter because a CURSOR OUTPUT parameter must not have a cursor allocated to it before execution of the procedure.

Error: 16952, Severity: 16, A cursor variable cannot be used as a parameter to a remote procedure call.
Error: 16953, Severity: 10, Remote tables are not updatable. Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor.
Error: 16954, Severity: 16, Executing SQL directly; no cursor.
Error: 16955, Severity: 16, Could not create an acceptable cursor.
Error: 16956, Severity: 10, The created cursor is not of the requested type.
Error: 16957, Severity: 16, FOR UPDATE cannot be specified on a READ ONLY cursor.
Error: 16958, Severity: 16, Could not complete cursor operation because the set options have changed since the cursor was declared.
Error: 16959, Severity: 16, Unique table computation failed.
Error: 16960, Severity: 16, You have reached the maximum number of cursors allowed.
Error: 16961, Severity: 10, One or more FOR UPDATE columns have been adjusted to the first instance of their table in the query.
Error: 16962, Severity: 16, The target object type is not updatable through a cursor.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *