Post reply

CDC and DDL

  • June 18, 2009 at 10:17 am

    #206042

    Hi all

    Investigating CDC - can't find the way to get new columns added in to it...

    Do I have to recreate it with a new cdc name and drop the old one?

    Cheers

    Rich

  • July 19, 2010 at 12:06 pm

    #1195046

    Yes, place all your audit records in a temp table, then drop cdc for the table and recreate it. Then move the data back from the temp table.

  • September 11, 2010 at 9:56 am

    #1219641

    You can also enable a 2nd CDC capture based on the new columns, then drop the previous CDC capture. The steps are covered in the SQL BOL under CDC and DDL.

    --Chris Skorlinski

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply