SQL Server Performance

Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Oct 15, 2007.

  1. Anonymous New Member

    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...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/10/15/2473.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2473" width="1" height="1">

Share This Page