Distributed transactions
Your application can enlist a connection for distributed
transactions by setting the Enlist connection string attribute to true, yes,
or 1.
You should set the Pooling connection string attribute
to true, yes, or 1 while
working with distributed transactions.
Distributed transactions includes an example of how to use distributed transactions with your application.
Distributed transactions are supported through the Microsoft™ Distributed Transaction Coordinator (MS DTC). The MS DTC components are required to call some unmanaged code, which can affect the level of security available and potentially degrade performance.