Skip to main content

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

Hi,
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      
GO
 
USE DataBaseName
GO
SELECT [name]is_tracked_by_cdc 
FROM sys.tables
GO
 

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



Comments

  1. Hi,

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete

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

    ReplyDelete
  5. Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!

    Web Designing Training Institute in Chennai | web design training center in chennai | web designing course in chennai with placement
    Mobile Application Development Courses in chennai
    Data Science Training in Chennai | Data Science courses in Chennai

    ReplyDelete
  6. The article was up to the point and described the information very effectively. Thanks to blog author for wonderful and informative post.
    website designing company pakistan

    ReplyDelete
  7. Thanks for sharing such a great blog Keep posting.. 
    Loadrunner Training in Delhi

    ReplyDelete

  8. Very Good Information...

    SAS Training in Pune

    Thank You Very Much For Sharing These Nice Tips..

    ReplyDelete
  9. Informative post. I like your blog, Thanks for sharing....Realizing the needs of candidates, we aim to provide all the information at this single place. Sarkari Job, candidates will not have to search for various websites and so by bookmarking the page, the regular updates can be checked.

    ReplyDelete
  10. Thanks for sharing this information. FreeJobAlert is one of the best website to get Latest Govt Jobs Information.
    I liked Your Article.

    ReplyDelete

Post a Comment