Database Audit Specifications in SQL Server 2008

7. You will see a dialog box with the success message as shown in the below snippet once the Database Audit Specification is enabled successfully:

8. The next step is to execute the below TSQL on the AdventureWorks Database:

Use AdventureWorks
SELECT * FROM Production.Product

9. Right click the SQLServerAuditing under Securiity | Audits and select the option View Audit Logs from the menu.

10. SQL Server will bring up a dialog box that will show the details of the select event:

The Database Audit feature in SQL Server 2008 allows Database Administrators to enable Database Level Auditing on SQL Server 2008. This feature is exteamly lightweight and has less overhead when compared  to the existing mechanisms of SQL Trace, DDL Triggers and Event Notifications.


Leave a comment

Your email address will not be published.