Knowledge is Power

SELECT s.[name], s.[schema_id], aa.CATALOG_NAME, aa.SCHEMA_OWNER   FROM sys.schemas s JOIN INFORMATION_SCHEMA.SCHEMATA aa ON aa.[SCHEMA_NAME] = s.[name]

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.