Transact-SQL (TSQL) features control-of-flow language, local variables with various support functions for string processing, date processing, mathematics, etc. Here you will find the TSQL tips, tweaks to improve the code to attain the performance.
In addition to INFORMATION_SCHEMA VIEWS, in SQL Server 2005, we can use Object Catalog Views to know more informations about the objects
Refer this http://msdn.microsoft.com/en-us/library/ms189783.aspx
PingBack from http://sqlserver-qa.net/blogs/t-sql/archive/2008/05/03/4147.aspx
In addition to INFORMATION_SCHEMA VIEWS, in SQL Server 2005, we can use Object Catalog Views to know