FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019

Applies to: SQL Server 2019 on LinuxSQL Server 2019 on Windows

Symptoms


Assume that you use BATCH_COMPLETED_GROUPaudit action group combined with database-level audit action in SQLServer 2019, you may notice that the audit of batch may be skipped when thebatch causes a fatal error that closes the session.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in thefollowing cumulative update for SQL Server:
Aboutcumulative updates for SQL Server:
Each new cumulativeupdate for SQL Server contains all the hotfixes and all the security fixes thatwere included with the previous cumulative update. Check out the latestcumulative updates for SQL Server:

References


Learn about the terminology that Microsoft uses to describe software updates.