...
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.
| Info |
|---|
supports provides limited support for before-after data auditing of the publisher database in SQL Servers with replication. However, this scenario is supported only when the publisher database with transaction replication is set to replicate data tables ONLY and no other objects. If the target database uses SQL Server replication set to replicate more than data tables , do not enable before-after auditing. Before and after data collection does not support SQL Server replication in that situation. For more information, see Microsoft Books Online for the version of SQL Server you are using. |
| Info |
|---|
To successfully audit specific columns on a table, ensure the table name does not contain the following special characters: \ / : * ? " |
...