Producing a Stored Procedure Stack Trace

• mkersh

  SSC Journeyman

  Points: 96

  More actions

  April 15, 2002 at 9:45 am

  #101119

  Does anyone know of a way of producing a Stored Procedure stacktrace from within a stored procedure?

  Is it possible to do such a thing?

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  April 15, 2002 at 9:56 am

  #427218

  You could instrument all your procedures so that each logs a line to a table as it executes, spid and proc name (and maybe parameters too).

  Andy

  Andy
  Connect with me on LinkedIn