Q: Reliability of distributed transcations Can someone please explain to me how this works? what would happen if upon commiting, one of the participants of the distributed transaction loses it's connection? How would the other participants know that they would need to rollback? I can't see how a distributed transaction would be ACID, somebody care to explain?
here's a sample
SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION

INSERT INTO [linkedserver1].[Play].[dbo].[tb_Test] VALUES ('Test');
INSERT INTO [linkedserver2].[Play].[dbo].[tb_Test] VALUES ('Test');
INSERT INTO [linkedserver3].[Play].[dbo].[tb_Test] VALUES ('Test');

COMMIT
SET XACT_ABORT OFF

