How do I run a sql server trace to check if triggers are being loaded in an application?
-
How do I trace triggers?
-
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
-
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