about error message

External Since: Aug 07, 2005 Posts: 1

hello,i meet a problem!
when i write a store procedure ,i want to show error msg myself,so i
use @@error to point the error. the question is how can i find which
column induce the error just like the DBMS tell me when i run a sql in
isql?
pls help me!

External Since: Dec 09, 2004 Posts: 61

You can generally get the error message template from
master..sysmessages where error = @@error. However, there is no way to
get any of the values (table name, page number, etc) that are
substituted into the error message outside of the client program
parsing the message it received (i.e. it has to be done outside of
TSQL)

There is an open feature request for a global variable that would
contain the full text of the most recent error raised, CR 296395.