change-tracking-catalog-views-sys-change-tracking-databases.md

title	sys.change_tracking_databases (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/08/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	change_tracking_databases sys.change_tracking_databases_TSQL sys.change_tracking_databases change_tracking_databases_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.change_tracking_databases change tracking [SQL Server], sys.change_tracking_databases
ms.assetid	bb233baa-2991-4904-a0eb-3772b81121a4
caps.latest.revision	17
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Change Tracking Catalog Views - sys.change_tracking_databases

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

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 [!INCLUDEssNoVersion].
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

Permissions

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.

See Also

Change Tracking Catalog Views (Transact-SQL)
Track Data Changes (SQL Server)