| title | dbo.MSchange_tracking_history (Transact-SQL) | ||
|---|---|---|---|
| description | dbo.MSchange_tracking_history (Transact-SQL) | ||
| author | JetterMcTedder | ||
| ms.author | bspendolini | ||
| ms.date | 10/20/2022 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
This system table contains the history of Change Tracking cleanup jobs.
| 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. |
About Change Tracking (Transact-SQL)
Change Tracking Cleanup and Troubleshooting (Transact-SQL)
Change Tracking Functions (Transact-SQL)
Change Tracking Stored Procedures (Transact-SQL)