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.

Pages: 1 2 3


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |