Find if Change Data Capture is failing

[indian143]

Hi All, I am using Change Data Capture in my SQL Server database to track the changes happened. But I want to know or be informed when Change Data Capture fails writing changes. can any body please let me know where to find or how to find when CDC fails tracking on specific tables or all Tables.

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

[seemaniyo]

new features in OWB11gR2. If you followed my postings a few weeks ago on heterogeneous connectivity in OWB11gR2, and the code template and hybrid mappings that accompany it, you might have seen references to changed data capture support that’s based on the same technology. Changed Data Capture in OWB11gR2 uses the journalize knowledge modules (or change data capture code templates as they are called on OWB) originally supplied by Oracle Data Integrator, and this latest release of OWB ships with modules to support changed data capture against Oracle, SQL Server and IBM DB/2 databases. ;) for more better info and many more you can visit this link PL/SQL Datatypes - Oracle PL/SQL Tutorial | Intellipaat.com[^] and learn many new thing"s and lot of new stuff..... you can learn more pl sql data types and fundamental"s

[John C Rayan]

The answer is here Administer and Monitor Change Data Capture (SQL Server)[^]