| title | Database Properties (ChangeTracking Page) | |
|---|---|---|
| description | Learn how to use the ChangeTracking tab in the Database Properties dialog box to view or modify change-tracking settings for a database. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.date | 01/07/2016 | |
| ms.service | sql | |
| ms.subservice | configuration | |
| ms.topic | conceptual | |
| ms.custom |
|
|
| f1_keywords |
|
|
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] Use this page to view or modify change tracking settings for the selected database. For more information about the options available on this page, see Enable and Disable Change Tracking (SQL Server).
Change Tracking
Use to enable or disable change tracking for the database.
To enable change tracking, you must have permission to modify the database.
Setting the value to True sets a database option that allows change tracking to be enabled on individual tables.
You can also configure change tracking by using ALTER DATABASE.
Retention Period
Specifies the minimum period for keeping change track information in the database. Data is removed only if the Auto Clean-Up value is True.
The default value is 2.
Retention Period Units
Specifies the units for the Retention Period value. You can select Days, Hours, or Minutes. The default value is Days.
The minimum retention period is 1 minute. There is no maximum retention period.
Auto Clean-Up
Indicates whether change tracking information is automatically removed after the specified retention period.
Enabling Auto Clean-Up resets any previous custom retention period to the default retention period of 2 days.
ALTER DATABASE (Transact-SQL)
CREATE DATABASE (SQL Server Transact-SQL)