How do I capture the active Stored Procedure Name to use in an error message

• jpgillum

  Old Hand

  Points: 326

  More actions

  April 20, 2016 at 1:12 pm

  #325747

  Hello everyone,

  Does anyone know if there is a variable name which contains the active stored procedure name so that I can include or use it in the error message of the active stored procedure error message?

  This would help to determine which stored procedure raised the error.

  Thanks

  JP

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 20, 2016 at 1:18 pm

  #1873455

  Here: https://msdn.microsoft.com/en-us/library/ms188398.aspx

• jpgillum

  Old Hand

  Points: 326

  More actions

  April 20, 2016 at 1:25 pm

  #1873456

  Thank you very much Lynn! 🙂

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  May 11, 2016 at 7:22 pm

  #1878418

  Inside of a stored procedure you may use OBJECT_NAME(@@PROCID)

  This will work for triggers as well.

  _____________
  Code for TallyGenerator