You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction.
You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail.
Which option should you enable?
A. REMOTE_PROC_TRANSACTIONS
B. ARITHABORT
C. XACT_ABORT
D. IMPLICIT_TRANSACTIONS
