SQL Server 2008 R2 Change Data Capture add addtional column to table

See more:

data

capture

Hello,

Let say I have a table table1 with the following columns

colID, col1, col2, col3, col4, col5

Then I enable CDC for table1 and capture the following column: colID,col2,col4

Let say tomorrow I add col6 and col7 into table1 table.

Is there a Stored Procedures to include col6 into the captured column list? Currently, this is how I do it, disabling the CDC on the table and then enable it again with col6 in the captured_column_list. The problem with this is that it will clear out all the captured data. Any thought?

Thanks,

Bryian Tan