Unanswered: Monitoring Extended SPs use through Profiler
Using Profiler, I set the ObjectType Filter to look for Stored Procs(8272) and Extended SPs(8280)
I have tried through code and Profiler to monitor Extended Stored Procedure use and have not had any luck. When I goto execute either documented or undocumented sprocs, XP_(DLL) or SP_(BuiltIn), the trace doesn't pic up any execution.
8272, regular sprocs get picked up by profiler, no trouble.
SQL Server 2005, latest patches(CUs) installed on fully updated Server 2003.