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 SQL Server auditing?
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 audit is implemented in SQL Server?
- In the Object Explorer panel on the left, expand Security.
- Right-click Audits and select New Audit… from the menu. …
- In the Create Audit window, give the audit settings a name in the Audit name.
