What should you add next to the beginning of each stored procedure?

You need to implement a solution that meets the data recovery requirements.
You update each stored procedure to accept a parameter named @transactionID.
What should you add next to the beginning of each stored procedure?

You need to implement a solution that meets the data recovery requirements.
You update each stored procedure to accept a parameter named @transactionID.
What should you add next to the beginning of each stored procedure?

A.
SAVE TRANSACTION WITH MARK @transactionID

B.
ROLLBACK DISTRIBUTED TRANSACTION @transactionID

C.
BEGIN TRANSACTION WITH MARK @transactionID

D.
COMMIT TRANSACTION @transactionID



Leave a Reply 0

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