How to check if Change Data Capture is enabled or disabled on a SQL Server Database?

You can check whether Change Data Capture is enabled or disable on a particular database in SQL Server using below T-SQL Statement.

   use master
   SELECT [name], is_cdc_enabled
   FROM sys.databases where name = 'Your_db_name'

Results :

is_cdc_enabled= 0 ---CDC is disabled or not enabled on this database

is_cdc_enabled= 1 ---CDC is enabled on this database