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
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.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

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 |