Simply pass the proc a value and it will search the entire database reporting every occurence of the word in tables, views, stored procedures, functions, etc...
Best of all, if you create a key stroke shortcut to execute the proc, you can highlight any text in your editor and search for it instantly. And because the proc's only parameter is of type SQL_VARIANT, there's no need to
surround the input parameter with single quotes! Hightlight, click, and find!
This proc does not query contnet of tables - I have another proce for that. Email me if interested.
Please feel free to email me with any questions, thoughts, or comments. And search SQLServerCentral for my other helpful scripts.