What should you do to ensure that the transaction uses a two-phase commit?

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?

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 the linked server to use distributed transactions.

B.
Configure a Service Broker to enable the appropriate transaction control.

C.
Ensure that the linked server is appropriately configured for delegation.

D.
Ensure that the linked server is appropriately configured for impersonation.

Show Hint