You are working on some errors raised by a some set of transactions. You want to ensure that transactions are not rolled back when low-severity errors are raised by the database engine.

Which of the following T-SQL statements can you use to accomplish this task?

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

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response