You are building a stored procedure for a SQL Azure database. The procedure will add multiple rows to a table. You need to design the stored procedure to meet the followi

ng requirements:

If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded.

If any errors occur, a row must be added to an audit table, and the original er

ror must be returned to the caller of the stored procedure.

What should you include in the design?

A. An implicit transaction that has XACT_ABORT enabled

B. An explicit transaction that has XACT_ABORT disabled

C. An implicit transaction that has error ha

ndling enabled

D. An explicit transaction that has error handling enabled

References:

http://technet.microsoft.com/en-us/library/ms175127(v=SQL.105).aspx