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.