top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is exact_abort in SQL Server?

+6 votes
599 views
What is exact_abort in SQL Server?
posted Jan 4, 2014 by Atul Mishra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
EXACT_ABORT or XACT_ABORT please clarify?

1 Answer

+1 vote

I think you meant by XACT_ABORT.

When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back.

When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing. Depending upon the severity of the error, the entire transaction may be rolled back even when SET XACT_ABORT is OFF. OFF is the default setting.

answer Jan 15, 2014 by Neeraj Pandey
...