Complete a Server Assessment – CDC and Change Tracking Information

Below you will find the code to find information about Change Data Capture and Change Tracking.  Simply select the text and copy to the Clipboard.

–Change Data Capture

SELECT name
, database_id
, is_cdc_enabled
FROM sys.databases
WHERE is_cdc_enabled = 1

–Change Tracking

SELECT d.name
,c.*
FROM sys.change_tracking_databases c
INNER JOIN sys.databases d
ON c.database_id = d.database_id

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.