does ms sql support two phase commit protocol

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

Quote:

Originally Posted by

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/...US,SQL.90).aspx
--|||Microsoft SQL Server supports distributed transactions.

See this topic and the ones below it in the table of contents in the SQL
Server 2005 Books Online:
http://msdn2.microsoft.com/en-us/library/ms191440.aspx
BEGIN DISTRIBUTED TRANSACTION statement reference:
http://msdn2.microsoft.com/en-us/library/ms188386.aspx
--
Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/pr...oads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.