Is there any way to find the time of changes or transactions in CT (Change Tracking) in SQL Server?
Join sys.dm_tran_commit_table
for the time.
select tc.commit_time, ....
from
changetable(changes <table>, 0) c
join sys.dm_tran_commit_table tc on c.sys_change_version = tc.commit_ts
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With