Post reply

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

  • July 16, 2009 at 7:06 am

    #208349

    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.

    My Environment: SQL Server 2008

    Thanks.

    Steve

  • July 16, 2009 at 7:34 am

    #1025634

    It'll likely be in a previously recorded event from the same SPID.

    K. Brian Kelley
    @kbriankelley

  • July 16, 2009 at 7:56 am

    #1025661

    Most of the time, when I'm observing client statements in trace events, I see the parameter values on stored procedure calls. And if I run a batch that looks like what you posted, I see the whole batch in the textdata column.

    It must matter how the procedure is called.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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