Distributed Transaction VS Local Transactions?

From: ALI-R (newbie_at_microsoft.com)
Date: 02/05/05 

Date: Fri, 4 Feb 2005 16:31:15 -0800

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

Relevant Pages

  • Re: Error Handling
    ... If you're using explicit transactions in your stored procedures (BEGIN ... >I have problem of using transaction on store procedure ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to code transactions
    ... If you need transactions, explicit transactions ... instance, consider you are adding a new employee, updating employee ... how do you perform the insert query to create the ...
    (microsoft.public.access.queries)
  • Re: performance on SET TRANSACTION ISOLATION LEVEL
    ... > I rarely use transactions in this instance. ... > page might run a report from a view ... > explicit transactions. ... implicitly increase the isolation level during the time that it runs. ...
    (microsoft.public.sqlserver.programming)
  • 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: 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)