Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 747
Home > Interviews > Sql Server >

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: 4042 | Points: 40
Post | Interview FAQs | Exclusive Questions | Interview Home  
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 

Bookmark It

Comments or Responses

Login to post response

More Interview Questions by Rajkatie


Latest Interview Questions