100% Pass Guarantee of Your 70-461 Exam, Pass Your Microsoft 70-461

Question NO : 21

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

Answer: A

Reference: http://msdn.microsoft.com/en-us/library/ms190306.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms188792.aspx

Latest 70-461 Questions - 70-461 Certification - Microsoft 70-461 Dumps