Edit

Share via

sys.sp_manage_distributed_transaction (Transact-SQL)

  • Article

Applies to: SQL Server 2022 (16.x) Azure SQL Managed Instance

sp_manage_distributed_transaction commits, aborts, or forgets a specified transaction.

Transact-SQL syntax conventions

Syntax

sp_manage_distributed_transaction
    @transaction_uow = 'transaction_ID'
    , @operation = 'value'
[ ; ]

Arguments

Important

Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.

@transaction_uow = 'transaction_id'

Specifies the MSDTC transaction ID (transaction unit of work). @transaction_uow is uniqueidentifier.

@operation = 'value'

Specifies operation to perform. Valid values are commit, abort, or forget.

Return code values

0 (success) or 1 (failure).

Result set

None.

Permissions

Requires sysadmin fixed server role, or have CONTROL SERVER permissions.

Examples

EXEC sys.sp_manage_distributed_transaction
    @transaction_uow = '1101AD68-43A7-4DC5-B06C-2B4BEF230643',
    @operation = N'commit'

Related content