SQL Server 2016 using SSMS 18.12.1 (had the same problem with 18.9.2)
I have two SPs: GetProduct and AddProduct.
- For the SQL Profiler only calls to GetProduct are logged
- For Extended Events they are both logged but differently - I'm using rpc_starting but I am new to Extended Events so any guidance is appreciated.
Statement: exec dbo.GetProduct
object name: AddProduct
statement: declare @p2 xml set @p2=convert...
- Interestingly, when tracing with NetMon the former looks fine. The latter has a parsing failure on the TDS Remote Procedure Call: [Malformed Packet]
I'm aware that NetMon has been deprecated and this could be a parsing issue with NetMon.
The object of the exercise is to be able to examine just the SP Calls, not the statements within them.