Capture THROW for logging

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  August 14, 2015 at 4:36 pm

  #306814

  Hi, is it possible to capture the contents of THROW within a CATCH into a variable so that it can be written to a logging table?

  I can capture ERROR_MESSAGE() to a variable but unfortunately it only writes the last error rather than the previous one that is informational.

  I realize that THROW can be multiple lines so it may not be possible to do through TSQL but thought I should ask.

  Thanks,

  Howard

• ShineBoy

  Right there with Babe

  Points: 764

  More actions

  August 18, 2015 at 5:18 pm

  #1820920

  have a read of this article:

  http://blogs.msdn.com/b/manub22/archive/2013/12/31/new-throw-statement-in-sql-server-2012-vs-raiserror.aspx

  hope it helps.

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  August 18, 2015 at 5:43 pm

  #1820922

  Thanks, I'm not sure that it is possible to capture the informational line of the throw to a variable so it can be logged to a table.