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!
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.