dbo.MSchange_tracking_history (Transact-SQL)

Applies to: SQL Server

This system table contains the history of Change Tracking cleanup jobs.

Column description

Column name	Data type	Description
internal_table_name	sysname	Name of the side table used to track changes for a change tracking enabled table or the syscommittab table.
table_name	sysname	Name of the change tracking enabled table or the syscommittab table.
start_time	datetime	Start time of the last auto cleanup process.
end_time	datetime	End time of the last auto cleanup process.
rows_cleaned_up	bigint	How many rows were processed by the auto cleanup process.
cleanup_version	bigint	Current valid change tracking version.
comments	ntext	Clean up job comments.

Was this page helpful?