Page History
...
Note |
---|
Row count information does not show when capturing DML and SELECT activities using SQL Server audit specifications. |
See row count information
The row count information is available in the General tab of any event properties, as well as the Audit Events tab in the Explore Activity view.
For select statements with sensitive columns, event properties contains contain a Sensitive Columns tab which shows the row count value for each audited sensitive column.
...
Info |
---|
If you use SQL statements with joined queries, SQL Compliance Manager displays multiple (equivalent to the number of distinct queries joined) events, however, row count information is available only with the primary statement and not applicable with other statements. |
Row count Alerts
IDERA SQL Compliance Manager allows you to set alerts on row count and data access. Alerts can be set by row count alone or adding a specific time interval.
...
Info |
---|
If you use SQL statements with joined queries, only the primary statement triggers any alert set for row count. |
Row count Reports
IDERA SQL Compliance Manager allows you to generate reports on data access, including the new row count feature. You can generate reports with the SQL Compliance Manager console and with Reporting Services.
...