The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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

APPLIES TO

Microsoft SQL Server 7.0 Standard Edition

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.

Additional query words: cursor assertion

Keywords: kbbug kbpending KB247365

Microsoft KB Archive/247365

Contents