How to capture executing of inner SPs using profiler

Hi,

Currently, i know that i can capture SP that executing from code or
from SQL Managmtnt studio. bit if a specific SP executing another SP i
don't see that in the profiler.

Any idea how can i see that?

omtechguy ( ) writes:
> Currently, i know that i can capture SP that executing from code or
> from SQL Managmtnt studio. bit if a specific SP executing another SP i
> don't see that in the profiler.
>
> Any idea how can i see that?

You need to add the events SP:SPStarting and SP:SPCompleted to you
trace.


--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx