Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniPelayar ini tidak lagi disokong.
Naik taraf kepada Microsoft Edge untuk memanfaatkan ciri, kemas kini keselamatan dan sokongan teknikal yang terkini.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns one row for each database that has change tracking enabled.
Column name | Data type | Description |
---|---|---|
database_id | int | ID of the database. This is unique within the instance of SQL Server. |
is_auto_cleanup_on | bit | Indicates whether change tracking data is automatically cleaned up after the configured retention period: 0 = Off 1 = On |
retention_period | int | If autocleanup is being used, the retention period specifies how long the change tracking data is kept in the database. |
retention_period_units_desc | nvarchar(60) | Specifies the description of the retention period: Minutes Hours Days |
retention_period_units | tinyint | Unit of time for the retention period: 1 = Minutes 2 = Hours 3 = Days |
The same permission checks are made for sys.change_tracking_databases as are made for sys.databases. If the caller of sys.change_tracking_databases is not the owner of the database, the minimum permissions that are required to see the corresponding row are ALTER ANY DATABASE or VIEW ANY DATABASE server-level permission, or CREATE DATABASE permission in the master database or current database.
Change Tracking Catalog Views (Transact-SQL)
Track Data Changes (SQL Server)
Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari ini