Solved

XACT_ABORT ON and CATCH

Posted on 2011-09-27
3
250 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 300 total points
ID: 36710026
0
 
LVL 25

Assisted Solution

by:TempDBA
TempDBA earned 200 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now