Posted by David Portas on 12/29/06 23:23

amoon.ljlj@gmail.com wrote:
> Hello ,
> My question is:
> does ms sql support two phase commit protocol?
> and Why if no.
> How if yes.
> Thank you

Yes. See Distributed Transaction Coordinator (aka MS DTC).

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]