SQL Server 2008 Database Auditing shows query criteria as a parameterized value instead of the actual record RRS feed

  • General discussion

  • Dear Partners

    We are running with below

    SQL Server Version : Microsoft SQL Server 2008 R2 (SP2) - 10.50.4276.0 (X64)   Feb  8 2013 10:37:00   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    the below article states if said CU is applied on SQL Server 2008 , the issue will be resolved. We are using SQL Server 2008R2 SP2 and CU5 but not able to capture actual value and parameterized value is show.


    Event Captured :




    statement:select * from Test where id=@id; (we need actual value instead of parameter).


    Can any one suggest how we can resolve this issue?

    - Arul

    Tuesday, June 18, 2013 7:57 AM