How to search a column name within all tables of a database and how to search stored procedures containing a particular text

Note, the query mentioned in the section "How to search Stored Procedures containing a particular text?" will not return Stored Procedures which have the first occurance of the serach string after 4000 characters. It would be better to use the sys.procedures View as explained in my blog:...