Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator
Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that makes it possible for client applications to work with multiple sources of data in one transaction.
When a distributed transaction spans two or more servers, the servers coordinate the management of the transaction using MS DTC. When a distributed transaction spans multiple databases on a single server, SQL Server manages the transaction internally.
SQL Server applications can call MS DTC directly to start an explicit distributed transaction. Distributed transactions can also be started implicitly by using one of the following methods:
Calling stored procedures on remote servers ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
