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
Go
SELECT * FROM Production.Product
GO
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:
Conclusion
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.
]]>