Post reply

retrieve value of parameters passed to sp

  • May 20, 2011 at 10:58 am

    #239981

    Is it possible to retrieve the values of the parameters passed to a stored procedure during the past time from the logs? or any where else?

    Thanks

  • May 20, 2011 at 11:29 am

    #1327848

    The most obvious way would be a SQL Profiler trace. The TextData column of the SQL:BatchCompleted event class will give you the StartTime and name of the procedure call and parameters.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply