PC Review


Reply
Thread Tools Rate Thread

Distributed Transaction VS Local Transactions?

 
 
ALI-R
Guest
Posts: n/a
 
      5th Feb 2005
I was reading an article about the way that ADO.NET 2.0 supports
Transactions ,which I was surrounded with some confusing terms I can't
distinguish from :

Terms are as follows :
* Distributed Transactions VS Local Transactions
* Explicit Transactions VS Implicit Transactions
* Automatic Transactions VS Manual Transactions

What I think about this is as follow ,Correct me if I'm wrong,please:

Explicit Transactions are those which you have to explicitly begin and
commit (or rollback) -so they could be considered as **Manual**
Transactions.
Implicit Transactions are those which are done **automatically**.

Distributed Transactions span two or more SQL Servers (2 or more Databases
within a single SQL Server ) while Local Transactions span only one
Database.
now is there any relation between **Distributed Transactions** and **Local
Transactions** and other terms like automatic and explicit and....?

Thanks for your time in advance.

ALi-R


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
transaction connection pooling and distributed transaction cristo Microsoft Dot NET 0 11th Sep 2006 02:07 PM
Detect if Distributed Transaction is used or just SQL 2005 internal transaction? John Lee Microsoft C# .NET 2 10th May 2005 04:25 AM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft C# .NET 3 11th Mar 2005 05:23 PM
"Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." Ollie Riches Microsoft ADO .NET 3 11th Mar 2005 05:23 PM
distributed transactions francois Microsoft ADO .NET 2 17th May 2004 07:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:34 AM.