Finding Objects throughout databases can be challenging. Use this script to search the syscomments for objects.
SELECT DISTINCT a.[name] FROM sysobjects a INNER JOIN syscomments b on a.id = b.id WHERE b.[text] LIKE '%[search-term]%'
We're available if you need assistance implementing custom SQL code. Contact us for help!