The distributed-transactions tag has no wiki summary.
2
votes
1answer
564 views
Msg 7391, Distributed Transactions (DTC) on SQL Server
This may be DBA related or developer related, I honestly don't know.
I have two Database servers:
A: SQL Server 2005 (Trigger that uses DBMail on Server B)
B: SQL Server 2008 R2 (DBMail configured)
...
2
votes
1answer
87 views
Two-phase commit for distributed transactions: what if a commit failed?
I have 2 servers participating in 2PC scenario:
* Srv1: votes OK
* Srv2: votes OK
* Coordinator runs "commit"
* Srv1: commits
* Srv2: does not accept "commit" command because of network failure
...