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.