Which of the following statements you can use to ensure that the SQL Server db engine automatically rolls back the entire current transaction if a T-SQL statement raises a run-time error ?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 2986 | Points: 40
Select from following answers:
  1. SET XACT_ABORT ON
  2. SET XACT_ABORT OFF
  3. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response