Forum Discussion

Copper Contributor

Jun 14, 2024

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 call...

olafhelper

Bronze Contributor

Jun 16, 2024

Victor_Sotnikov , Profiler can only trace external call.

For internal you could use SQL traces or extended events, see

Quickstart: Extended Events - SQL Server | Microsoft Learn

Victor_Sotnikov

Copper Contributor

Jun 19, 2024

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 ?

olafhelper
Bronze Contributor
Jun 20, 2024
Test it and you will see it.
I don't have such an old SQL Server to do it for you.