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.
...
| Info |
|---|
To successfully audit specific columns on a table, ensure the table name does not contain the following special characters: \ / : * ? " |
Available actions
Specify tables for before and after data collection
...
CLR is required by .NET Framework to access details about DML events on the SQL Server database. For more information, see Microsoft Books Online.
Available fields
Table Name
Provides the name of the table you are auditing on this database.
...
If the audited table contains BLOB data and individual columns have not yet been selected, the status will display as Not Configured. SQL Compliance Manager does not support auditing BLOB data. To audit data changes on this table, click Edit and then choose the available columns that do not contain BLOB data.
Set up auditing before and after data
Auditing before and after data is an extension of DML event auditing at the table column level.
- 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.