Auditing rows on a refresh

When you are performing a refresh on a target table, you can specify that all rows should be audited.

1. Click Configuration > Subscriptions.
2. Select the subscription.

   Ensure that your subscription contains a table mapping that was mapped using LiveAudit™.

3. Select the table mapping in the Table Mappings view.
4. Right-click and select Open Details....
5. Click the Operation tab.
6. Select Audit from the On Clear/Truncate list.
7. Click Save.

Results

When you start a refresh on the table mapping, CDC Replication audits the table-level clear or refresh operations applied to the target table.