Forum Discussion
MarcusMM
Jan 02, 2026Copper Contributor
SYSUTCTRANSBEGINTIME
what about SYSUTCTRANSBEGINTIME with datetime2(7) in SQL Server 2025?
carlwalk
Jan 08, 2026Copper Contributor
I don’t think SYSUTCTRANSBEGINTIME column exists , checked SQL Server 2025 docs, nothing there.
You can try this
SELECT
transaction_id,
CAST(transaction_begin_time AS datetime2(7)) AS precise_time
FROM sys.dm_tran_active_transactions;