Error Handling in SQL Server

• ikorenbl

  SSCommitted

  Points: 1750

  More actions

  September 23, 2004 at 3:33 pm

  #59954

  Is there a way to catch exact error message that SQL throws?

  For example, the SQL throws this message:

  Server: Msg 208, Level 16, State 1, Line 1

  Invalid object name 'TBL_C'.

  If I catch the @@Error and query master..sysmessages table I can get a general description:

  208         16       0      Invalid object name '%.*ls'.

  How do I capture exact error description - "Invalid object name 'TBL_C'."?

  Thanks

• olavho

  Say Hey Kid

  Points: 706

  More actions

  September 23, 2004 at 3:44 pm

  #524266

  Unfortunately there is no (at least easy way) of doing this. There was an article about it some time ago:

  http://www.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp