distributed transaction

Hi folks,

I have a simple request, I have 3 SQL Servers which are linked server. Data
is spread out over those 3 servers.

Some transactions must be spread on more than SQL server and then I do not
know how to do this as i think that one transaction (SqlTransaction) can be
tight to only one SqlConnection...

I have seen some information on the internet about that but it was for the
framework 2.0 and we are using .Net 1.1

Thanks a lot in advance,

Francois


.

Relevant Pages

  • Re: distributed transaction
    ... > Hi folks, ... > I have a simple request, I have 3 SQL Servers which are linked server. ... > is spread out over those 3 servers. ... > Some transactions must be spread on more than SQL server and then I do not ...
    (microsoft.public.dotnet.framework.adonet)
  • Linked server and delegation
    ... - run under a domain user account, ... User Admin1 can connect successfully to both SQL Servers. ... Now I setup a linked server from SQL1 to SQL2. ... Seems Kerberos delegation does not work and fall back to NTLM which does not ...
    (microsoft.public.sqlserver.security)
  • Re: transactions per seconds - how many?
    ... For a sproc that does updates, 220 transactions per second is about the best ... > on your sql servers? ... > The sql server runs double xeon machine and 2 scsi drives. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Linked Server Lockes, mass testing
    ... "Ali Salem" wrote: ... > I am connecting two sql servers together as linked servers, the servers are running on windows 2003. ... > I call a stored procedure defined on the linked server as part of a transaction and it works properly. ...
    (microsoft.public.sqlserver.programming)
  • Distributed Transaction VS Local Transactions?
    ... Distributed Transactions VS Local Transactions ... Explicit Transactions VS Implicit Transactions ... Distributed Transactions span two or more SQL Servers (2 or more Databases ...
    (microsoft.public.dotnet.framework.adonet)