Capture thread flow in SQL Server

Question

I am very new to Microsoft SQL Server. I am wondering if it is possible to capture the trace of an sql query in a database executed from an external program, while ignoring the actions caused by the trigger.

I used the SQL profiler and choose to capture text content for the SP: StmtCompleted event. The result is very overwhelming and contains a lot of code, which is indicated in the trigger.

Thanks Derek

Answer 1

Add a filter to ObjectType from <> 21076 (you will need to select the "Show all columns" option so that it appears in the list)