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
To open the trace file: Open SQL Profiler, Start > Programs > Microsoft SQL Server > Profiler. Select File > Open >Trace File. Navigate to the directory where the trace file was stored and open it.
How do you trace the traffic hitting a SQL Server? Example: "You use SQL profiler to trace the traffic on the SQL Server instance. To narrow down the transactions that are captured, you can use a filter. The trace files can be searched, saved or even replayed to help with troubleshooting."
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With