Microsoft KB Archive/247365

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.