472,958 Members | 2,143 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

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 5542
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: William Chan | last post by:
Dear all, When two systems are talking to each other by messaging mode (e.g. MQ), is there any way, system level and/or application level, to maintain transaction control (unit of work) across...
4
by: Lennart Jonsson | last post by:
I need to do a two phase commit (a transaction over a table and a nickname). Trying to do so gives me the error SQL30090N reason = 18 The suggested action is: If multiple data sources need to...
4
by: MelApiso | last post by:
Hi, I have two databases in the same instance, sourcedb and targetdb. In sourcedb I created one table (t1). In targetdb I created another table (t2). In sourcedb I created one nickname (N2) for...
1
by: _link98 | last post by:
On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides the Transaction-manager? i.e. in the same transaction, can an SQL/PL...
2
by: Mark | last post by:
I created an extremely simple windows service that only writes to the EventLogs on Stop and Pause. I installed it using the InstallUtil.exe program, the output of which is below. It appears to be...
4
by: zing | last post by:
Our company is in the startup phase of a large project involving lots of network traffic. At this point, I'm trying to find out whether TCP will be fast enough for the task. I've read a few...
5
by: Ravi Chirawala | last post by:
Is Two phase commit allowed in DB2? We need to update a local tables and few federated tables in a single Unit of Work. Is it possible to do ? Regards, Ravi
3
by: Ralf Assmann | last post by:
Hi there, we have the following problem using a DB2 version 7 on z/OS, referring also <a...
1
by: TheAndroid | last post by:
All, I'm having a difficult time trying to implement two-phase commits across federated database members in UDB 8.3. I've tried using MQ (v 6.0) as the transaction manager and UDB tells me that...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.