SQL Profiler: How do I see the value of a parameter?

  • When using SQL Profiler, I would like to be able to view the value of the parameter passed into a stored procedure.

    For example,

    Delcare @MyValue Int

    SET @MyValue = 10

    Exec spShowValue @MyValue

    In SQL Profiler, how can I see the value of @MyValue.

    Thanks.

    Steve

  • Unless I'm missing something, couldn't you look for the call to the stored procedure in Profiler by capturing TSQL > SQL:BatchCompleted ? In my setup that's one of the default events when setting up a new Profiler trace.

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

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