locked
Sql Profiler: which Event , column returns stored proc name? RRS feed

  • Question

  • What Event, column name will return the name of the stored proc called?  (I have tried options such as Stored Procedure : RPC Completed and get strings like

    declare @p1 int

    set @p1= 1245

    exec sp_preexec @p1 output, NULL

    "exec 12345643 output NULL, N'SELECT col1, col2 ,..... from TableA"

    Helpful but I still would like the name of stored proc that invoked this SELECT statement.

    TIA,

    edm2



    • Edited by edm2 Wednesday, February 27, 2013 5:56 PM
    Wednesday, February 27, 2013 4:45 PM

Answers

  • You need to select the TextData column across the events to get the specific stored procedure name under SP:Starting event.

    Regards,


    Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

    • Marked as answer by edm2 Wednesday, February 27, 2013 8:18 PM
    Wednesday, February 27, 2013 6:00 PM