Statistics for SP SQL Statement

Oct 27, 2008 at 9:31 AM
Hi,

I have selected events "RPC:Starting", "SP:Completed", "RPC:Completed", "SP:StmtStarting" and "SP:StmtCompleted" for the trace.

However, only SP_EXECUTE is shown on the report. Is there any way to show statistics of sql statement inside a procedure?