Multi-Database Transactions

From: David Wimbush (david_wimbush_at_hotmail.com)
Date: 03/08/05 

Date: 8 Mar 2005 07:13:51 -0800

I've been looking into adding transaction capabilities into my object
model framework. I always understood that, with SQL Server, a
transaction could only cover one database, regardless of whether the
transaction was done in a stored procedure or ADO ('classic ADO' or
ADO.Net). But when I started reading in detail it got vague. For
example, people were talking about data _sources_ instead of databases.
So I did some testing and I can do a transaction in either SQL or ADO
that successfully commits or rolls back updates to two databases. I'm
using a single SQL Server 2000 Standard Edition with multiple databases
on it and .Net 1.1.

Before I get carried away, can anybody tell me the facts or point me to
some definitive information about this, please? Thanks.

Relevant Pages

  • Re: Multi-Database Transactions
    ... SQL Server has supported the concept of cross-database (or even cross ... "2-phase commit". ... > I've been looking into adding transaction capabilities into my object ... people were talking about data _sources_ instead of databases. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: system databases
    ... > Do not remove Guest user from Master and Tempdb databases; ... >>I have installed sql server 2000,sp3a on a w2003 server. ... >>separate disk array for os,data, transaction files and backups. ...
    (microsoft.public.sqlserver.setup)
  • Re: INSERT Delay
    ... ADO sees them as a transaction (my bad for using the word ... Create a program that uses an ADO connection to SQL Server. ... Concatenate the three strings together with a CRLF between them. ... If they are not handled as a transaction, the first two should be committed ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction with SET XACT_ABORT ON
    ... I use ADO 2.7 ActiveX Component to> connect SQL SErver 2000. ... Some place on my applications use ADO to start> Transaction on client-side following sample Code; ... > Dim Cnn as ADODB.Connection ...
    (microsoft.public.data.ado)
  • Re: Transaction with multiple Databases
    ... Via COM+ (Component Services) ... you can set a transaction that spans multiple databases. ... With SQL Server, you will have to link servers to run the transaction. ...
    (microsoft.public.dotnet.framework.adonet)
Loading