Distributed Transaction VS Local Transactions?

  • Thread starter Thread starter ALI-R
  • Start date Start date
A

ALI-R

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
 
Back
Top