Post reply

Logging Query in Manages Stored Procedure

  • December 13, 2010 at 8:10 pm

    #228480

    Hey there,

    I'm looking for a way to see the actual query (or queries) that is (are) fired when a managed stored procedure is called. How is that possible in MSSQL2008? How to log that?

    Thanks! Cheers

    Dankbart

    --------------------------------------------------------
    [font="Comic Sans MS"]Correct me if I'm wrong[/font]

  • December 13, 2010 at 10:11 pm

    #1262025

    you can use sql profiler trace use "sp:stmtcompleted" event class

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 13, 2010 at 10:27 pm

    #1262030

    Sounds good. Pardon my ignorance - How do I do that?

    --------------------------------------------------------
    [font="Comic Sans MS"]Correct me if I'm wrong[/font]

  • December 13, 2010 at 10:34 pm

    #1262033

    dankwart menor (12/13/2010)

    Sounds good. Pardon my ignorance - How do I do that?

    http://blog.sqlauthority.com/2009/08/03/sql-server-introduction-to-sql-server-2008-profiler-2/

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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