You are writing a set of queries against a FILESTREAM-enabled database. 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?

Question

Accepted Answer

E. SET XACT_ABORT ON

Answer

A. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

Answer

B. SET XACT_ABORT OFF

Answer

C. SET TRANSACTION ISOLATION LEVEL SNAPSHOT

Answer

D. SET IMPLICIT_TRANSACTIONS ON

Answer

F. SET IMPLICIT TRANSACTIONS OFF

You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored…

Question

Options

How the community answered

Community Discussion