Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This tab The Before-After Data tab of the Audited Database Properties window 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.

...

  1. Ensure Database Modification (DML) activity is selected on the Audited Activities tab.
  2. Ensure the appropriate tables are specified on the DML/SELECT Filters tab.
  3. 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.
  4. Choose the appropriate tables, and then click OK. By default, all columns are audited.
  5. If you want to audit specific columns , select the table, and then click Edit.

 

Excerpt
SQL Compliance Manager audits all activity on your server. Learn more > >