Page History
Before-After Data
This tab allows you to select the tables for which you want to collect before and after data. You can collect before and after data for DML events generated by DELETE, INSERT, and UPDATE commands.
Collect before and after data when it is critical to capture the exact data change in a table column. When this feature is enabled, you can evaluate the before value and after value for each change in the Audit Events view. Enabling this feature can impact your Collection Server and Management Console performance.
If you want to collect before and after data, verify that you are auditing DML events on this database and that common language runtime (CLR) is enabled on the corresponding SQL Server instance. If the target database uses SQL Server replication, do not enable before-after auditing. Before and after data collection does not support SQL Server replication. For more information, see Microsoft Books Online.
TIP | To successfully audit specific columns on a table, ensure the table name does not contain the following special characters: \ / : * ? " |
...
- Ensure Database Modification (DML) activity is selected on the Audited Activities tab.
- Ensure the appropriate tables are specified on the DML/SELECT Filters tab.
- On the Before-After Data tab, click Add to choose which audited tables should also be audited at the column level for before and after data.
- Choose the appropriate tables, and then click OK. By default, all columns are audited.
- If you want to audit specific columns, select the table, and then click Edit.