469,133 Members | 1,307 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

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 you

Dec 29 '06 #1
2 5291
am********@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/m...S,SQL.90).aspx
--

Dec 29 '06 #2
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/pro...ads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.
Jan 2 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by William Chan | last post: by
4 posts views Thread by Lennart Jonsson | last post: by
4 posts views Thread by MelApiso | last post: by
2 posts views Thread by Mark | last post: by
5 posts views Thread by Ravi Chirawala | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.