SQL Server developers and DBAs use SQL Search to:
- Find fragments of SQL text within stored procedures, functions, views and more
- Quickly navigate to objects wherever they happen to be on a server
- Find all references to an object
http://www.red-gate.com/products/sql-development/sql-search/