Tracking Change Data Capture in SQL Server 2008

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

Introduction

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
Comments
There is no comments for this articles.
Leave a Reply
Title:
Display Name:
Email:
(not display in page for the security purphase)
Website:
Message:
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