Security: Create and view Audit Logs

It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this can be difficult to achieve on large environments, where a lot of people have elevated privileges or several people have permissions to perform tasks over your data or schema. As an additional measure, an audit log should be implemented in those scenarios and review these often. SQL Server provides the functionality to implement audit logs at Server and Database level. Starting SQL Server 2008, all SQL Server editions support Server level audits. Database audits are supported beginning with SQL Server 2016 (13.x) SP1. Prior to that, database level auditing was limited to Enterprise, Developer, and Evaluation editions. On this post I will show you how to configure and view audit logs: Implement Audit Log Under security, go to Audits and select New audit... Specify a name for the audit and select an audit destination (I personally prefer a