SQL Server: Debug – Why can’t I find a stored procedure by SQL Profiler?

  • Because that stored procedure is executed inside a stored procedure. Stored procedure executed inside a stored procedure is not hit by SQL profiler (?)
  • Because that stored procedure is executed inside a stored procedure. Stored procedure name is passed to this SP as an input parameter and that SP is not hit by SQL profiler (?)
  • Because no stored procedure is called. Work was done by executing SQL query directly.
  • Because that stored procedure is called by a job, not at the moment you did profiling

Be the first to comment

Leave a Reply

Your email address will not be published.


*