Bewerken

Share via


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.

See Also

About Change Tracking (Transact-SQL)
Change Tracking Cleanup and Troubleshooting (Transact-SQL)
Change Tracking Functions (Transact-SQL)
Change Tracking Stored Procedures (Transact-SQL)