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

avatar image

manoj 2
12 2 2 4

(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

avatar image

Usman Butt
14.9k 6 13 21

(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.

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: 845 times

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

Copyright 2018 Redgate Software. Privacy Policy