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.