Forum Discussion
SQL Profiler: can I see values of a proc when it is called from another proc?
I have SQL Server 2012 Enterprise. I have run SQL Profiler to track calls of my stored procedures. I have specified SP:Starting event for this.
There was a situation when my client application calls a procedure Proc1; and Proc1 calls procedure Proc2. Profiler displays the both calls – OK. But I see that Profiler displays actual values of procedure parameters (“@param1 = xxx, @param2= yyy” etc) only for Proc1. For Proc2 it does not show the actual values; it just enlists the parameters (“@param1, @param2” etc).
Is there a way to make SQL Profiler display the actual values for Proc2? Or maybe some other (free) profiler can do this?
3 Replies
Victor_Sotnikov , Profiler can only trace external call.
For internal you could use SQL traces or extended events, see
- Thank you for the "For internal you could use SQL traces or extended events" advise.
But - just in case - will this approach work on SQL Server 2012 ?- Test it and you will see it.
I don't have such an old SQL Server to do it for you.
