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

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

–Change Tracking

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.