A distributed transaction is a unit of work in which two or more network hosts are involved. Usually hosts provide transactional resources while the transaction manager is responsible for creating and managing a global transaction that encompasses all the operations. Distributed transactions must have all four ACID (atomicity, consistency, isolation, durability) properties, where atomicity guarantees all-or-nothing outcomes for the unit of work.
3 years ago
Recent Hot AnswersHow to insert in table from remote stored procedure without creating a distributed transaction?
Distributed transaction and Read Committed Snapshot
Problem creating a transaction in an SSIS package
Msg 7391, Distributed Transactions (DTC) on SQL Server
On which server does a query execute?
sql-server × 21
linked-server × 7
oracle × 5
msdtc × 5
sql-server-2012 × 4
transaction × 4
postgresql × 2
sql-server-2014 × 2
oracle-11g-r2 × 2
sql-server-2005 × 2more related tags