Creating a Microsoft SQL Server auditing object

Create an auditing object to store audit events.

1. Log in to your Microsoft SQL Server Management Studio.
2. From the navigation menu, select Security > Audits.
3. Right-click Audits and select New Audit.
4. In the Audit name field, type a name for the new audit file.
5. From the Audit destination list, select File.
6. From the File path field, type the directory path for your Microsoft SQL Server audit file.
7. Click OK.
8. Right-click your audit object and select Enable Audit.