sp_reset_dtc_log (Transact-SQL)

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

Clears the Microsoft Distributed Transaction Coordinator (MSDTC) log.

Transact-SQL syntax conventions

Syntax

sp_reset_dtc_log
[ ; ]

Arguments

There are no arguments for this stored procedure.

Return code values

0 (success) or 1 (failure).

Result set

None.

Permissions

Requires sysadmin or have CONTROL SERVER permissions.

Examples

EXEC sp_reset_dtc_log;

Related content

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