You can use the Management Console to view the properties of the SQL Server event that triggered a given alert.

To view the event data for an alert:

  1. Select Audited SQL Servers or an individual SQL Server instance in the Explore Activity tree.
  2. On the Alerts tab, right-click the alert for which you want to view event details, and then select Event Properties on the context menu.
  3. Review the event details, and then click Close.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels