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.

Example

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


© Copyright SS64.com 1999-2014
Some rights reserved