CODEWITHSUNDEEP
sql-serversql-server-2008sql-server-profiler
defoo
defoo

Reputation: 5297

capture flow of execution in SQL Server

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

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

Thanks, Derek

Upvotes: 4

Views: 265

Answers (1)

Martin Smith
Martin Smith

Reputation: 452947

Add a Filter on ObjectType of <> 21076 (You will need to select the "Show all columns" option to make it appear in the list)

Profiler screenshot

Upvotes: 2

Related Questions