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?