Copy and paste code in AdventureWorks 2008 and change the string to the table name you want to search for.
Next Step: With time permitting I will improve this script to search for any particular string within the entire server, This will include searching for objects like views, stored procs etc, etc.