how to get SQL Server error message

• Sandy1970

  Grasshopper

  Points: 18

  More actions

  June 5, 2003 at 9:32 am

  #159984

  I am trying to develop a SQL Server Stored Procedure, which will be called from shell scripts, so I can not really trap the error messages on the Front End. Inside Stored Procedure, I get @@Error, but that is just a error number. The SysMessages table has general info about this table, but would not give me the column name etc.

  Does anyone know how to get exact error message in Stored Procedure?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  June 6, 2003 at 12:26 am

  #460097

  Cross post ?!?

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]