The tag has no wiki summary.

learn more… | top users | synonyms

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 ...