As noted before I am using SQL 2008 CDC to incrementally update a data warehouse for the project I’m currently working on. I found this snippet of code that inserts a new record. If matching an existing row, it marks that row as no longer active and then inserts the new row as the new active row. A process I’ve …
Interesting SQL 2008 CDC Discovery
I have an SSIS package that sets up CDC in a SQL 2008 by looping through a series of tables and activating each using the following basic command: EXECUTE sys.sp_cdc_enable_table @source_schema = N’dbo’