Microsoft KB Archive/165857

= FIX: Delete/Rollback May Cause AV on Table w/Text Col & Triggers =

Article ID: 165857

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q165857



BUG #: 16719



SYMPTOMS
Issuing a delete statement on a table from within a transaction, followed by a rollback may cause access violations (AVs) and a variety of errors including error 840, 826, and bufwait timeouts. The server may stop responding. Sometimes SQL Server will not shut down after this problem occurs, and you need to cycle Windows NT Server to recover SQL Server. This problem will only occur if both of the following conditions are true:


 * You have a table that has at least one text column.
 * You have a delete trigger that deletes further rows in the same table.

These symptoms may vary on different hardware platforms, but when exposed to this error, an AV is always generated.



WORKAROUND
To work around this problem, do any one of the following:


 * Remove the delete trigger from the table in question.
 * Remove the delete statement from within the user-defined transaction.
 * Change table schema so that it does not require any text columns.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Keywords: kbbug kbfix KB165857

-

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

© Microsoft Corporation. All rights reserved.