Hi Experts, We are using SQL Server 2008 and using CDC functionality for auditing purpose. we have identified tables and columns needed for Auditing purpose. As according to SQL Server internal mechanism for each CDC table it is creating CDC table inside system tables under that database. is there any way instead of having various "_CT" table i can have one table for all together, which can reduce overhead for me. immediate help needed please.
Sorry Manoj, but you are asking something against the basic functionality of the CDC. The default behavior is to add information about changes to the tracked table’s **associated change table**. So it is not possible. Besides, this technology mainly targeted an extraction, transformation, and loading (ETL) application which incrementally loads change data from SQL Server source tables to a data warehouse. So this functionality make more sense. Moreover, I am not able to understand what is the overhead? To me, it would have been much more difficult to maintain a single CDC table for every change in source tables.