Quick Search

Quick Search helps you find SQL text quickly across one database or across all accessible databases on a server.

What it searches

• Stored procedure, view, and function definitions (sys.sql_modules)
• Table names and column names
• Procedure/function parameter names
• SQL Agent job names, step names, and step commands (in msdb)

How to use

1. In Object Explorer, select a server or database node.
2. Open Quick Search and click Select Target from Object Explorer.
3. Enter search text.
4. Choose scope/options:
   • All user databases on the server or just selected database
   • Match whole words only or Use wildcards (%, _)
   • Object types to include (procedures, views, functions, tables, SQL Agent jobs)
5. Click Search (or press Enter in the search box).

Results

• The grid shows database, object type, object name, match location, and a preview.
• Selecting a row opens the source text preview below and highlights matches.
• Click Script to open object definition in a new query window.

Notes

• If a search is already running, the Search button becomes Cancel.
• SQL Agent job scripting from results is currently marked as work in progress.