Select Database Schema Name with their Owner Name

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]

List all Error Codes with description

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.