About distributed transaction 
Author Message
 About distributed transaction

Hi, all,

I have two questions about distributed transaction in SQL Server 7.0.

1) when I start a distributed transaction, are those statements that involve
remote servers executed in a asynchronous or synchronous way? List an
example :

*****************************************************
Begin distributed transaction

update pubs..table1 set col1=12
exec linkedserver.pubs.dbo.sp_proc1   // in a asynchronous or synchronous
way???
update pubs..table2 set col2 = 13

Commit tran
*****************************************************

2) In SQL Server 7.0, how to deal with deadlock in distributed transaction
when deadlock occurs in the server level, not the database or table level?
How can SQL Server detect this is a deadlock in the server level, not
because that involved server happens to be broken from the network?

Any suggestions are appreciated! Thanks in advance!

Regards,
--Corida



Tue, 23 Apr 2002 03:00:00 GMT
 About distributed transaction

1) Synchronous

2) There is no distributed deadlock detection mechanism, you must rely on
timeouts.  Take a look at the "remote query timeout" option in sp_configure.

--
All opinions expressed here are mine and mine alone

-----------
Show support for SQL Server and support the American Red Cross, order your
books from barnesandnoble.com at
http://bn.bfast.com/bfast/click/mid1349732?siteid=6710312&bfpage=h


Quote:
> Hi, all,

> I have two questions about distributed transaction in SQL Server 7.0.

> 1) when I start a distributed transaction, are those statements that
involve
> remote servers executed in a asynchronous or synchronous way? List an
> example :

> *****************************************************
> Begin distributed transaction

> update pubs..table1 set col1=12
> exec linkedserver.pubs.dbo.sp_proc1   // in a asynchronous or synchronous
> way???
> update pubs..table2 set col2 = 13

> Commit tran
> *****************************************************

> 2) In SQL Server 7.0, how to deal with deadlock in distributed transaction
> when deadlock occurs in the server level, not the database or table level?
> How can SQL Server detect this is a deadlock in the server level, not
> because that involved server happens to be broken from the network?

> Any suggestions are appreciated! Thanks in advance!

> Regards,
> --Corida



Tue, 23 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. distributed query,distributed transaction,sp_getapplock

2. How to use Save Transaction in Distributed Transaction

3. ORA-00164: Autonomous Transaction Disallowed Within Distributed Transaction

4. Error 627 - Cannot Use Save Transaction Within Distributed Transaction

5. simple transaction & distributed transaction**

6. Cannot use save transaction within a distributed transaction

7. distributed transaction,nested transactions,sp_getapplock

8. Distributed transaction from Clustered Server

9. very urgent distributed transaction

10. Distributed Transaction Coordinator fails on clustered sevrer

11. Distributed transactions errors: a possible solution (re-posted)

12. Distributed transactions between Sql Server and Oracle


 
Powered by phpBB® Forum Software