You need to design a solution to guarantee that a stored procedure is part of every transaction

You need to design a solution to guarantee that a stored procedure is part of every
transaction. What should you do?

You need to design a solution to guarantee that a stored procedure is part of every
transaction. What should you do?

A.
Enable implicit transactions.

B.
Enable Distributed Transaction Coordinator (DTC).

C.
Set the NOCOUNT option to ON.

D.
Set the XACT_ABORT option to ON.



Leave a Reply 0

Your email address will not be published. Required fields are marked *