BEGIN DISTRIBUTED TRANSACTION

Start a T-SQL distributed transaction.

Syntax
      BEGIN DISTRIBUTED TRAN[SACTION] [transaction] [;]

      BEGIN DISTRIBUTED TRAN[SACTION] [@transaction_var ] [;]

 Key:
   transaction     A name for the transaction <= 32 characters.
   transaction_var A user-defined variable containing a transaction name.

Requires the Microsoft Distributed Transaction Coordinator (MS DTC) to be installed.

Examples

BEGIN DISTRIBUTED TRANSACTION;
--
--
COMMIT TRANSACTION;
GO

"The two offices of memory are collection and distribution" - Dr. Johnson

Related commands

BEGIN TRANSACTION
COMMIT TRANSACTION
Equivalent Oracle command: SAVEPOINT