Microsoft KB Archive/247365

From BetaArchive Wiki
Knowledge Base

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

Article ID: 247365

Article Last Modified on 10/16/2002


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q247365

BUG #: 57099 (SQLBUG_70)


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.


Here are three ways to work around this problem:

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


  • Remove the NOLOCK hint from the cursor.


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


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

Additional query words: cursor assertion

Keywords: kbbug kbpending KB247365