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_5

5. Implementing SQL Server Audit via SQL Scripts

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 with SQL scripts. Chapter 4, “Implementing SQL Server Audit via the GUI,” covered how to set up SQL Server Audit via the GUI in SSMS. In this chapter, you will ...