Find SQL fast in SQL Server Management Studio and Visual Studio

• Find fragments of SQL in tables, views, stored procedures, functions, 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

from : https://www.red-gate.com/products/sql-development/sql-search/