Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    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.

    http://support.microsoft.com/kb/967552

    Event Captured :

    database_name:OnlineRegs

    schema_name:dbo

    object_name:Test

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

    additional_information:

    Can any one suggest how we can resolve this issue?

    - Arul

    Tuesday, June 18, 2013 7:57 AM