Post reply

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

  • July 16, 2009 at 6:42 am

    #212093

    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

  • July 17, 2009 at 2:04 am

    #1026048

    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