SQL Server 2005 Profiler How do you view the entire Stored Procedure Chain

Question

SQL Server 2005 Profiler shows that a Stored Procedure (SP) was called and what variables were passed. However I don't know how to get profiler to show me subsequent calls. By this I mean when SP A calls SP B and SP B calls SP C.

Is there a way to get profiler to show this chain?

Thanks

Answer 1

You can enable the SP:StmtCompleted event to see each statement inside the procedures, insluding calls to other procedures. Note that this is quite heavy tracing, should be used exclusively for debugging purposes, not on live servers.