Thank this author by sharing:
By Wilfred van Dijk,
Ever searched in your code for a column name? or a tablename? This script does it all!
It not only search your SP and Functions code, but also checks if your searchcriteria is part of an objectname. It also shows you the modification date (if possible)
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.