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