Select from following answers:- SET XACT_ABORT ON

- SET XACT_ABORT OFF
- SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
- All Above
SET XACT_ABORT ON statement to ensure that when a T-SQL statement run-time error occurs, the entire transaction is terminated and rolled back.
Show Correct Answer
Source: measureup.com | |
Alert Moderator