Post reply

How do I run a sql server trace to check if triggers are being loaded in an application?

  • February 6, 2009 at 8:34 am

    #218250

    How do I trace triggers?

  • February 8, 2009 at 1:51 am

    #940108

    You need not do anything special in profiler for that. Just create a new profiler trace and trace sql statements and stored procedures running against sql server. This will show the trigger running in background if fired on execution of any of these statements.

    MJ

  • February 8, 2009 at 2:38 am

    #940117

    joba

    run the trace server side so as not to use too much resource from the server. Either generate the script yourself (search this site for examples and check BOL) or in profiler set up the trace and start it then immediately stop it. (Ensure you capture the SP:StmtCompleted event at minimum and include the objectname and object type columns). On the file menu click File > Export > create Trace definition > for sql2005. Edit the script in the points indicated once profiler has generated it and then apply to the server

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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