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
WHERE is_cdc_enabled = 1
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.