The following procedure gets a TSQL program object
(View/UDF/stored procedure) and a given string
It searched object's source code for the string and returns the number of lines where a match is found.
This is helpful when we want to search all our TSQL code for a specific table name, column etc. and investigate where it is referenced without using sp_depends function
Get a summarized report of all DataBases options
This SELECT will give you a summarized report for the options selected for ALL the databases on your SQL Server. It's compatible with versions 7 and 2000.