is it possible that SQL Profiler trace does not show calls done within a trigger?

I am just suspicious that the SQL Profiler does not show the calls done within by one of the triggers I have.

If I am right,

Is there a setting to force profiler to show also the calls done within triggers?

Note: The trigger I am talking about 开发者_运维技巧makes some sp calls

Try adding the SP:StmtCompleted and/or SP:Completed events to your trace setup - this should provide you with what you're after.

Some possibilities include:

• Not choosing the correct EventClasses to monitor.
• Inadvertently filtering out what you wish to record.
• The specific step of interest within the Trigger is not being executed (conditional operations etc.)

If your Trigger is definitely executing T-SQL code then it will be recordable.

See The Basics of SQL Server Profiler and for more generic Performance Tuning see Performance Tuning for SQL Server