If you would like to know the description of an error when
your application, using SQL Server as a back end, returns an error number; It is
very easy!! SQL server stores this information in its meta tables i.e the SYSTEM
Tables.
Use the following query to obtain the description of any
error id or message id returned by your application-
SELECT message_id,severity,text
FROM
SYS.MESSAGES
WHERE message_id=104 --error number
and
language_id=1033 --
represents English language
To know more click here.
No comments:
Post a Comment