Pamela M. has a script for a difficult scenario:
This is what I use when these moments happen. This script will go out and search for occurrences of the search parameter in every table, view, synonym, stored procedure and function on the instance and will return the results in a single set.
Click through for the script, which Pamela warns us will be slow.