Error in stored proc and write error result in Errorlog sql 2000

• freewarefw

  Right there with Babe

  Points: 715

  More actions

  June 1, 2004 at 2:44 pm

  #152161

  Hello

  I need some helps. I saw an article if I remembered that told how capture an error coming from stored proc and write it in SQL 2000 errorlog. (the type of error could be critical because even I tested the @@error the stored proc stopped before my tests...)

  but I can't remember where !!!! if someone has a solution or knows where I can find this article I will appreciate a lot. If I remembered it could be with the Daily update that I saw the article

  thanks in advance....

   

   

• PurpleLady

  SSCertifiable

  Points: 7819

  More actions

  June 2, 2004 at 6:03 am

  #508631

  Check out http://www.sommarskog.se/error-handling-II.html 

• Arvind-57714

  SSCrazy

  Points: 2529

  More actions

  June 2, 2004 at 8:50 am

  #508671

  You can also use "With Log" option of RaiseError (....).

  And if you want you can also customize the Error Message i.e create your own.

  Cheers,

  
  Arvind