| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|---|
sp_reset_dtc_log (Transact-SQL) |
sp_reset_dtc_log (Transact-SQL) |
VanMSFT |
vanto |
randolphwest |
03/07/2025 |
sql |
system-objects |
reference |
>=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.
EXEC sp_reset_dtc_log;