Post reply

Profiler - View Statements In Stored Procedure Execute?

  • November 12, 2015 at 5:04 am

    #302291

    To identify why and when a database table column is changing I have set up a profiler to run.

    Triggers are not appropriate as I want to see the statement and the user that performs the update.

    I have selected just SQL:BatchCompleted and filtered to the database.

    It lists all SQL executed but does not show any SQL statements run within a stored procedure.

    It just shows the stored procedure execution line.

    I have tried adding all the events within Stored Procedures events but none show the SQL statements executed that are within the stored procedure.

    Is there any way to show SQL statements in profiler executed below the stored procedure statement?

  • November 12, 2015 at 5:17 am

    #1839318

    SP:StmtCompleted will show statements executing within a procedure. Be careful of filters, they're the most common reason why events don't show up.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 18, 2015 at 1:32 am

    #1840545

    Hi,

    Yes that did it.

    Thanks.

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

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