SET_XACT_ABORT ON in a transaction with rollback present in catch block

Asked Aug 28 '13 at 00:32

Active Jan 09 '14 at 20:28

Viewed 183 times

Just going through some tutorials at the moment and I see a lot of code in stored procedures as follows.

SET_XACT_ABORT ON BEGIN TRY .... COMMIT TRANSACTION

END TRY BEGIN CATCH ROLLBACK TRANSACTION END CATCH

Just wondering why would the SET_XACT_ABORT ON here would be necessary as wouldn't any throw or raise error be caught in the Catch block anyway and the transaction will be rolled back?

Thanks

edited Aug 28 '13 at 02:46

asked Aug 28 '13 at 00:32

TheWommies

4,922
11
61
79

a quick search for SET_XACT_ABORT ON would answer your question – Mitch Wheat Aug 28 '13 at 00:39
http://stackoverflow.com/questions/1150032/what-is-the-benefit-of-using-set-xact-abort-on-in-a-stored-procedure – Mitch Wheat Aug 28 '13 at 00:39
To be honest it still does not really answer why it would be necessary seeing there is a catch block there with a rollback statement – TheWommies Aug 28 '13 at 02:40
1

Sorry it explains it...my bad – TheWommies Aug 28 '13 at 04:16
Could you please answer your question here? 'Cause I still cannot find an answer in the question mentioned above by Mitch Wheat in comments to your question. – Anatoly U Feb 17 '14 at 17:06

SET_XACT_ABORT ON in a transaction with rollback present in catch block

0 Answers0