Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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 ?
on 6/30/2013 | Category:
Sql Server Interview questions
| Views: 2952 |
Select from following answers:
SET XACT_ABORT ON
SET XACT_ABORT OFF
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
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
measureup.com | |
< Previous :
You are working on some errors raised by a some se ...
Next > :
Which of the following statements will list the nu ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
Which of the following statements will list the number of BEGIN TRANSA ...
You want to revert changes made during a transaction to the start of t ...
Which of the following statements can you use to specify the end of a ...
You want to revert changes made during a transaction to a specific sav ...
You want to create several markers within a transaction that a user ca ...
You are developing some T-SQL code. You want to ensure that you correc ...
Which of the following statements would you use to mark the save point ...
You are reviewing a database created by a developer. You have noticed ...
Latest Interview Questions
In.Net which is the parent class to create all windows service?
What is infonomics?
how to change the database owner?
What is the maximum size of columns in a particular table?
How to convert server name to host name?
How can you detect the servername ?
How can you detect the host name and Ip address?
How can you detect the version properties?