Microsoft 70-461 Exam Dumps Question

70-461 Question 6


You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?


A.  SET XACT_ABORT ON
B.  SET ARITHABORT ON
C.  TRY
D.  BEGIN
E.  SET ARITHABORT OFF
F.  SET XACT_ABORT OFF


Correct Answer: A
Explanation/Reference:
Reference: http://msdn.microsoft.com/en-us/library/ms190306.aspx Reference: http://msdn.microsoft.com/en-us/library/ms188792.aspx