Click here to Skip to main content
12,406,342 members (31,312 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Posted 17-Apr-12 6:59am
Bryian Tan40.6K

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160730.1 | Last Updated 17 Apr 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100