You administer a SQL Server 2008 infrastructure. You administer two SQL Server 2008
instances named Instance1 and Instance2. Instance1 contains the Sales database, and
Instance2 contains the Accounts database. A procedure in the Sales database starts a
transaction. The procedure then updates the Sales.dbo.Order table and the
Accounts.dbo.OrderHistory table through a linked server. You need to ensure that the
transaction uses a two-phase commit. What should you do?
A.
Configure a Service Broker to enable the appropriate transaction control.
B.
Ensure that the linked server is appropriately configured for delegation.
C.
Configure the linked server to use distributed transactions.
D.
Ensure that the linked server is appropriately configured for impersonation.