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.
more ▼

asked Nov 14, 2011 at 03:50 AM in Default

manoj 2 gravatar image

manoj 2
11 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered Nov 15, 2011 at 10:03 PM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 14, 2011 at 03:50 AM

Seen: 686 times

Last Updated: Nov 14, 2011 at 03:50 AM