Skip to content

sys-sp-manage-distributed-transaction.md

Latest commit

 

History

History
65 lines (44 loc) · 1.87 KB

sys-sp-manage-distributed-transaction.md

File metadata and controls

65 lines (44 loc) · 1.87 KB
title sys.sp_manage_distributed_transaction (Transact-SQL)
description sp_manage_distributed_transaction commits, aborts, or forgets a specified transaction.
author VanMSFT
ms.author vanto
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
monikerRange >=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

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

Related content