BUG: Dynamic Cursor With NOLOCK Hint, DELETE Activity, Causes Assertions in Error Log

• Microsoft SQL Server version 7.0

SYMPTOMS

Under high stress conditions assertions occur when performing DELETE activity using a dynamic cursor defined on a table with a TEXT column and using the NOLOCK hint.

WORKAROUND

Here are three ways to work around this problem:

• Use DELETE .. WHERE CURRENT OF to delete from a cursor.
  
  -or-



• Remove the NOLOCK hint from the cursor.
  
  -or-



• Rewrite T-SQL to perform deletes without using a cursor.

STATUS

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

Additional query words: cursor assertion

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