• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

Trace SP hit which is inside another SP using Profiler

I would like trace SP hit which is inside another SP using Profiler. As of now, I get only parent SP hit. How to get sub procedure hits in profiler? Please do assist.
0
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
1 Solution
 
Pratima PharandeCommented:
0
 
NormanMainaCommented:
In the New Trace window,go to the Trace tab and select All Events and Show All Columns.

Make sure the following columns are also selected:
SQL:Batchstring - will show the sub procedure executing
SP:StmtStarting  -will show the excecuted query from the sub procedure
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now