Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

J. BushPractical Database Auditing for Microsoft SQL Server and Azure SQLhttps://doi.org/10.1007/978-1-4842-8634-0_4

4. Implementing SQL Server Audit via the GUI

Josephine Bush¹  

(1)

Boulder, CO, USA

 

To make SQL Server auditing work, you need two or three components depending on what you want to audit. Chapter 3, “What Is SQL Server Audit?”, covered what each of these components are and the audit categories and groups associated with them. In this chapter, you will learn how to set up the audit in SQL Server Management Studio (SSMS) .

Setting Up the Audit

For a quick recap, to make SQL Server auditing work , you need two or three things depending on what you ...