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
