Tracking Change Data Capture in SQL Server 2008

Posted By  Dhananjay Kumar On 17 Jan 2011 08:01:34
emailbookmarkadd commentsprint
No of Views:1737
Bookmarked:0 times
Votes:0 times


A very important feature of SQL Server 2008 is that we can enable CDC [Change Data capture] on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column


Image Loading

In above query School is name of the database.If we want to track tables in database whether CDC enabled or not then

Image Loading

Above query will list name of all tables in School database CDC enabled.

Sign Up to vote for this article
Other popular Tips/Tricks
There is no comments for this articles.
Leave a Reply
Display Name:
(not display in page for the security purphase)
Please refresh your screen using Ctrl+F5
If you can't read this number refresh your screen
Please input the anti-spam code that you can read in the image.
^ Scroll to Top