begin transaction (Transact-SQL only)

Marks the starting point of a user-defined transaction.

Syntax

begin [transaction][transaction_name]

Parameters

Usage

  • The access service library accepts the transaction name parameter, then strips it before passing it to the target.

  • The begin transaction command is not recognized by ODBC, so the DirectConnect server traps this statement and monitors the transaction state internally. When a commit is issued after a begin transaction, SQL Transact() is called.

  • Only one transaction can be open for each connection.

Parent topic: Transact-SQL Commands