You need to recommend a solution that addresses the concurrency requirement.
What should you recommend?
A. Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2.
B. Make calls to Sales.Proc1 and Sales.Proc2 synchronously.
C. Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.
D. Modify the stored procedures to update tables in the same order for all of the stored procedures.
