Is this a recurring need?
If not, I do this kind of impact analysis using a multi-query window in SSMS and running a "find" proc that can search the metadata of all databases in an instance for a specific term.
If it is a recurring need then what is your ideal output? rows in a table? a text file? some info to stdout is ok?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato