SQL Server auditing is a new feature which makes use of extended events to allow you to audit everything that happens in your server, from server setting changes all the way down to who modified a value in a specific table in the database.
What is a SQL Server audit?
SQL Server auditing is a new feature which makes use of extended events to allow you to audit everything that happens in your server, from server setting changes all the way down to who modified a value in a specific table in the database.
How do I know if SQL Server audit is enabled?
- In SQL Server Management Studio, in the Object Explorer panel, expand Security and.
- Right-click the audit object that you want to view and select View Audit Logs from the menu.
- In the Log File Viewer, the logs will be displayed on the right side.
