Home Forums Programming General Trace value in stored proc RE: Trace value in stored proc

  • November 12, 2016 at 11:22 am

    #1912067

    weiran1982 (11/12/2016)

    Hi guys,

    I'm new to SQL and need a bit help here. I'm troubleshooting an application (no source code). I set up SQL profiler and captured RPC call something like RPC compeleted EXEC my_storedProc @paramater = '12345'

    I believe value '12345' was generated by one of the stored proc, is there anyway to trace it where it is from?

    thanks a lot!

    Kind of. Be sure to include the host name and user names in the trace to help you determine where the whole shebang is being called from. Also be sure to include the TextData column so that you can actually see the code for each line of output.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)