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?
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? Read More
