Loading

Parameter values are not shown in AuditLog File viewer(2016

Sanket Jain

7y1.4k

I want to capture insert & Update transaction operations of some tables. So I create 1 SQL audit to perform this operation. I am using SQL Server 2016 audit. In that, Parameter values are not shown in Audit Log File viewer.

I want to see parameter values in Audit Log File viewer. So how to resolve this issue?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirav Gandhi7y ago
I would suggest use extend event, it is light weight and no performance issues while audit the data
https://docs.microsoft.com/en-us/sql/relational-databases/extended-events/extended-events?view=sql-server-2017
+1
Afzaal Ahmad Zeeshan7y ago
Please show the SQL code that is being used for this, if any. It is quite unclear as to what might be going wrong here. Also, it would help us if you can share how you are trying to pass the parameter.
+1