Skip to main content

How to check whether CDC is enabled or disable in Table or Databases

CDC (Change Data Capture) is used to record the changes that takes place in Tables or in Databases. By default CDC will be in disabled mode. We know we can use triggers to notify the changes in the tables, but triggers always degrade the performance of your databases. So in SQL Server 2008 Microsoft had introduced CDC Concept to capture the DML commands in table and databases. Below code checks whether CDC is enabled or not

Check whether CDC enabled for  Databases
Check whether CDC enabled for Tables

SELECT [name], is_cdc_enabled FROM sys.databases      
USE DataBaseName
SELECT [name]is_tracked_by_cdc 
FROM sys.tables

note:  if  ‘is_tracked_by_cdc’ column is 1 than cdc is enabled else disabled.
note:  if  ‘is_tracked_by_cdc’ column is 1 than cdc is enabled else disabled


  1. Hi,

    How can check whether CDC is enabled on Postgresql.
    And how should i generate it.

  2. I am really interested to continue reading your blog. You have shared valid info. Waiting for more updates from you.

    IELTS Coaching in Chennai
    IELTS Coaching Centre in Chennai
    IELTS Training in Chennai
    IELTS Chennai
    Best IELTS Coaching in Chennai

  3. Thanks a lot for sharing this post with us. it gives a lot of information to improve knowledge.
    web design training programs
    php training center in chennai
    magento developer training


  4. These are really amazing and valuable websites you have shared with us. Thanks for the informative post.
    WordPress development company in Chennai


Post a Comment