SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases. You want to rename one of your table columns but aren't sure what stored procedures reference it. Using SQL Search, you can search for the column name and find all the stored procedures where it is used. Finding anything in the SSMS object tree requires a lot of clicking. Using SQL Search, you can press the shortcut combo, start typing the name, and jump right there.
Find SQL fast in SQL Server Management Studio
Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more
Quickly navigate to objects wherever they happen to be on a server
Search across multiple object types and multiple databases
Find all references to an object
Search with booleans and wildcards