mitracv
Old Hand
Points: 376
More actions
February 14, 2002 at 11:22 pm
#78008
Hi,
I am just wondering on how could I get hold of 'error description' in t-sql. When a statement errors I can get hold of error number from @@ERROR but what about the error description.
Thanks & Regards,
Mitra
ramakrishna100
SSC Enthusiast
Points: 196
February 15, 2002 at 2:15 am
#423893
Hi Mitra
You can see all the error messages in "sysmessages" system table. You can use like "select description from sysmessages where error= 207"
Thanks
Ram(DBA)
ramakrishna100@yahoo.com
nigelrivett
SSCertifiable
Points: 5362
February 16, 2002 at 10:50 pm
#424024
To get the error message you need to look at the output buffer as the substitutions are not held anywhere.
An example of how to do this is at
http://www.nigelrivett.com
direct link to page
http://home.btclick.com/NIGELRIVETT/spFormatOutputBuffer.html
Cursors never.DTS - only when needed and never to control.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply