SQL Server Audit does not show values on a parametrized query. - by Equipo de DBA Ministerio de Justicia y DDHH

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 766164 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/4/2012 12:29:22 PM
Access Restriction Public


When a database audit specification is configured and running, capturing SELECT, INSERT, UPDATE and DELETE statements, audit files does not record parameter values when some user send a parametrized query.
Sign in to post a comment.
Posted by Microsoft on 12/4/2012 at 12:11 PM

Thanks for your feedback. I've recorded this request in our DCR database and we will fix this in a future version of SQL Server.

Il-Sung Lee.