TRY CATCH And Error Messages

• hindle.steve

  SSCrazy

  Points: 2057

  More actions

  November 9, 2011 at 2:32 am

  #251519

  I have been using TRY CATCH to capture errors and write them to the log.

  One particular error I had was performing a restore via TSQL when the drive ran out of disk space. However, the error returned by the ERROR_MESSAGE() was the RESTORE failed (which it did) but what I want to really know is why ie. lack of disk space. Is it possible to retrieve this information via a TRY CATCH?

• Paul White

  SSC Guru

  Points: 150468

  More actions

  November 9, 2011 at 2:50 am

  #1405048

  Not that I know of. Some error conditions produce multiple error messages; the TRY..CATCH related error functions just capture the first one.

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi