PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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