© 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 Bush1  
(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 ...

Get Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.