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

A.
Enable Implict transaction.

B.
Set the NOCOUNT option to on.

C.
Set the XACT_ABORT option to on.

D.
Enable distributed transaction Cordinatoor (DTC).