Error Description in T-SQL

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

ramakrishna100 SSC Veteran Points: 216 More actions · Answer 1

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)

nigelrivett SSCertifiable Points: 5472 More actions · Answer 2

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

direct link to page

Cursors never.
DTS - only when needed and never to control.