BUG: Update on View Based Cursor to Multiple Rows in Fetch Buffer Fails with 1203 Msg.

ID: Q238637

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 56218 (SQLBUG_70)

SYMPTOMS

An update to all rows in the current fetch buffer (through sp_cursor), with a cursor based on a view, may fail with the following error:

Process 7 unlocking unowned resource: TAB: 5:982827855 []
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource TAB: 5:982827855 []..

This problem is specific to the use of extended cursor procedures since ANSI T-SQL only supports an update of a single row WHERE CURRENT OF <cursor>. An ODBC application might encounter this error when updating all rows in the fetch buffer through a SQLSetPos() API call.

WORKAROUND

Here are two ways to work around this behavior:

Use only one row in the fetch buffer.

-or-

Update the cursor against the base table.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug