Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    9

    Unanswered: Modifying Change Data Capture Tables

    We have enabled Change Data Capture for auditing our table changes in SQL Server 2008. There is a request to NULL out a few columns (for all rows) in a couple CDC tables, due to compliance with a certification. Is there a compelling reason not to modify these tables and to leave the audit trail as-is? Thanks for your help!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    There should not be any real reason. You will naturally get a lot of change records for these updates, so you should look at
    1) How much space is available in the database, and make sure you can hold a copy of the entire table(s) being updated
    2) Look at the downstream systems, and ask how they will react to all of these change records.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •