sys-sp-manage-distributed-transaction.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	monikerRange
sys.sp_manage_distributed_transaction (Transact-SQL)	sp_manage_distributed_transaction commits, aborts, or forgets a specified transaction.	VanMSFT	vanto	randolphwest	03/07/2025	sql	system-objects	reference	>=sql-server-ver16 || >=sql-server-linux-ver16 || =azuresqldb-mi-current

sys.sp_manage_distributed_transaction (Transact-SQL)

[!INCLUDE SQL Server 2022 Azure SQL Managed Instance]

sp_manage_distributed_transaction commits, aborts, or forgets a specified transaction.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

[!INCLUDE extended-stored-procedures]

@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

• sys.dm_tran_distributed_transaction_stats (Transact-SQL)
• sp_reset_dtc_log (Transact-SQL)