question

manoj 2 avatar image
manoj 2 asked

CDC - SQL Server 2008 - Urgent Help

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.
sql-server-2008sqlserver
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Usman Butt avatar image
Usman Butt answered
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.
10 |1200 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.