Script to retrieve auditing configuration details in sql server. Auditing feature is released from SQL Server 2008 onward so if you have utilized this feature then you can make use of this script to get quick information about audit configuration.
Auditing is a new feature introduced in SQL Server 2008. Auditing is a general word and its related to sql server to capture events that occurs in sql server, it’s similar to tracking the processes happening in sql server. This feature helps database administrators to implement a strategy to know who is performing what or to track events for a particular database. Auditing is spitted into two categories a.) Server Auditing specification and b.) Database Auditing specification. Lets look into those categories