Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.sp_manage_distributed_transaction (Transact-SQL)
Applies to: 👁 Image
SQL Server 2022 (16.x) 👁 Image
Azure SQL Managed Instance
sp_manage_distributed_transaction commits, aborts, or forgets a specified transaction.
👁 Image
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
EXECUTE sys.sp_manage_distributed_transaction
@transaction_uow = '1101AD68-43A7-4DC5-B06C-2B4BEF230643',
@operation = N'commit';
Related content
Feedback
Was this page helpful?