Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 19, 2012 10:32 AM by molly_c
Apr 17, 2012 04:55 PM|LINK
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?
Apr 19, 2012 10:32 AM|LINK
You can use sys.sp_cdc_get_captured_columns to captured columns..after you add that columns, your table structure changed, it will be in the list.