Creating and Managing Audits with SQL Server Management Studio

You can perform several audit-related tasks by using Object Explorer in SQL Server Management Studio. For example, start or stop data collection and view the data collection logs.

Audit-related nodes are located as follows in the Object Explorer hierarchy in Management Studio.

SQL Server Instance

---- Security

-------- Audits

-------- Server Audit Specifications

SQL Server Instance

---- Databases

-------- Database Name

------------ Security

---------------- Database Audit Specifications