Post reply

SQL Profiler

  • May 10, 2004 at 2:40 am

    #359640

    Hi All,

    How can I Trace varuiables in sql profiler(or else), profiler returns every sql statement executed and that OK, but if I have a variable e.g. @Amount, it returns it as it is , how can I get its value during the trace at every occurance through the stored procedure being traced ? thanks.

  • May 11, 2004 at 8:12 am

    #505978

    Quick and dirty but it works.

    Run an insert query to insert the value of the variable into a temp table every time the variable is set and select * from the temp table at the end.

    Note* I am assuming you do have access to the Stored Procedure to be able to run an alter statement.

    ------------------------------
    The Users are always right - when I'm not wrong!

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

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