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


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q247365
BUG #: 57099 (SQLBUG_70)

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 7.0.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB247365
©2002 Microsoft Corporation. All rights reserved.