The information in this article applies to:
SYMPTOMSIf a ROLLBACK TRAN statement executes within a trigger, the rest of the batch is not aborted. WORKAROUNDTo work around this problem, you can use the SET option XACT_ABORT to force the rest of the batch to abort when there is a rollback. Note, however, that this will abort the batch even for a rollback not happening within a trigger. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider. MORE INFORMATION
The problem happens only with the ROLLBACK TRAN statement. A rollback that
happens automatically because an error with severity level 19 or greater
arises will terminate the batch as expected.
Additional query words: sp1
Keywords : kbnetwork kbbug6.50 kbfix6.50.sp1 |
Last Reviewed: April 1, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |