Your company requires a standard code snippet to be inserted at the beginning of all stored procedures meeting the following requirements:

Your company requires a standard code snippet to be inserted at the beginning of all stored procedures meeting the following requirements:
+ Stored procedures should be able to call other stored procedures
+ All stored procedures must incorporate transactions
Here is the core part of the snippet

char(36) @TransName = newID()
If <insert answer here>
Save Transaction @TranName
Begin Transaction

A.
@@DBTS = 0

B.
@@FETCH_STATUS <= -1

C.
@@NESTLEVEL = 0

D.
@@TRANCOUNT > 1