Change Data Capture to handle parent and child tables
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi All, I am using SQL Server Change Data Capture to track my changes in my Web Application. But the problem I am having is, if I have one page which is updating multiple Tables, parent and child tables in one transaction, how can I track all those tables transactions at one time, because sometimes page can update some tables and may not update other tables. As CDC is working on individual tables it is very difficult for me whether the transaction has updated particular tables. Can anybody please help me how to track the changes on the tables in that approach. Thanks in advance.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."