Export (0) Print
Expand All

Using Transactions with Distributed Queries

SQL Server supports transaction-based access to external data using the ITransactionLocal (local transaction) and ITransactionJoin (distributed transactions) OLE DB interfaces.

Using distributed transactions, SQL Server ensures that a transaction involving multiple nodes is either committed or rolled back in all the nodes. If the provider does not support participating in a distributed transaction (does not support ITransactionJoin), only read-only operations are allowed against that provider when inside a transaction.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft