BUG: Error 7102 with Keyset-Driven Cursors on Table with Text Column

• Microsoft SQL Server version 7.0

SYMPTOMS

A keyset-driven cursor on a SELECT statement that uses the NOLOCK option on a table with a text column returns error 7102, if during fetching the data one of the records of the cursor's result set is deleted from another connection.

Error message 7102 is:

Server: Msg 7102, Level 20, State 99, Procedure sp_cursorfetch, Line 24
SQL Server Internal Error. Text manager cannot continue with current statement.

WORKAROUND

To work around this problem, use either of the following:

• Remove the NOLOCK option from the SELECT statement.
  
  -or-



• Change the cursor to any other type (for example, static, dynamic, or fast_forward).

STATUS

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

Additional query words:

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