Re: distributed transaction



Your answer is right here -
http://www.codebetter.com/blogs/sahil.malik/archive/2005/04/11/61755.aspx

Let me know if there are any further follow up / design questions.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/


"Francois Malgreve" <francois.malgreveADgmail.com> wrote in message
news:OYkzBFvRFHA.2528@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • distributed transaction
    ... I have 3 SQL Servers which are linked server. ... Some transactions must be spread on more than SQL server and then I do not ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • 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)

Loading