| title | sp_reset_dtc_log (Transact-SQL) |
|---|---|
| description | sp_reset_dtc_log (Transact-SQL) |
| 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 |
[!INCLUDE SQL Server 2022 Azure SQL Managed Instance]
Clears the Microsoft Distributed Transaction Coordinator (MSDTC) log.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_reset_dtc_log
[ ; ]
None.
0 (success) or 1 (failure).
None.
Requires sysadmin or have CONTROL SERVER permissions.
EXECUTE sp_reset_dtc_log;