Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
Can I configure SQL Server Auditing feature to monitor just modifications\deletion and ignore addition of data?
KB1906 | Last review: Apr 03, 2014 | Netwrix Auditor for SQL Server | 5.0 and above
|Question||Can I configure SQL Server content changes auditing feature to monitor just modifications\deletion and ignore addition of data?|
|Answer||There is a way to configure SQL content audit to monitor certain change types (INSERT, UPDATE, DELTE) within a target DB:
The idea is to modify content audit triggers manually and add target db to exclude list so Netwrix Auditor could not modify triggers (restore INSERT). Despite the fact that the DB will be shown as excluded in the product, audit data will be logged and collected.
Was this information helpful?