How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with SP_HELPTEXT you can get but still there is lot more to get, in this case you can make best use of INFORMATION_SCHEMA (IS) views that are enhanced since SQL Server 2000 version. Its a pity that most of DBAs and Developers miss out using these views when...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/10/15/2473.aspx