How to get SQL Profiler to monitor trigger execution

sql-server sql-server-2005 sql-server-profiler
firedfly picture firedfly · Oct 1, 2008 · Viewed 46.8k times · Source

I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace to monitor the execution of triggers?

Answer

Mladen picture Mladen · Oct 2, 2008

Stored procedures: - SP:StmtStarting - SP:StmtCompleted

Related questions

How to filter SQL Server 2008 Profiler Output for a single database?

SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can that be done most easily?

Read More
In SQL Server, how to move/import a multiple .trc files to a trace table

I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO trace_folder FROM::fn_trace_gettable('C:\…

Read More
SQL server profiler not showing LINQ To Sql queries

I am trying to view SQL generated by Linq to SQL in the SQL Server Profiler (2005). I can see the sql sent to the server from anything except for linq to sql. I'm betting that I need to change event …

Read More