Recently, I was facing some problem to check the proper error code in my procedure.
Thanks to Sql Server 2005. It gives a great user friendly Schema & System table names.
So This is the query by which we can see all the Error Codes,
SELECT s.[error], s.severity, s.dlevel, s.[description], s.msglangid
FROM sys.sysmessages s
Now, I can use Try-Catch block in sq l server 2005 & can raise appropriate Error also depending upon the Error Code.