?
Solved

XACT_ABORT ON and CATCH

Posted on 2011-09-27
3
Medium Priority
?
290 Views
Last Modified: 2012-05-12
In a TRY/CATCH block which includes XACT_ABORT ON does everything get ROLLEDBACK if the code enters the CATCH?


0
Comment
Question by:Mr_Shaw
3 Comments
 
LVL 4

Accepted Solution

by:
anandarajpandian earned 1200 total points
ID: 36710026
0
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 800 total points
ID: 36710329
No, it won't.
But for what context you want to use it?
0
 

Author Closing Comment

by:Mr_Shaw
ID: 36916123
thanks
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question