Description
You inherit a database with hundreds of tables, need to change one column, and have no idea which procedures, views and triggers reference it, so you end up writing LIKE queries against sys.sql_modules and repeating them database by database. dbForge Search is a free SSMS add-in whose single search box reaches across several databases at once: type a name or fragment and tables, views, procedures, functions, triggers and columns all come back, with a double click jumping to the definition.
It searches two ways: object search matches names and definition bodies, data search looks inside the stored values, which is how you find which table and column a given phone number actually lives in. The results grid shows match counts and DDL, filters by object type, database and connection, accepts wildcards, and exports to CSV for handing to a colleague.
It is the fully free member of the Devart dbForge family, adding a dbForge Search entry to the SSMS menu bar without a separate window.
Cross database object search: Query tables, views, procedures, functions, triggers and columns across many databases in one pass.
Data search: Find a value inside actual table data to locate which table and column holds it.
Definition body matching: Matches the SQL text of procedures and views, not just object names, so dependencies show up before a change.
Results grid: Object type, database, match count and a DDL preview, with a double click to the definition.
Filters and wildcards: Narrow by object type, database or connection; wildcards substitute any characters.
CSV export: Export results to build a change impact list.
SSMS integration: Loads as an add-in inside SQL Server Management Studio, no separate window.
It searches two ways: object search matches names and definition bodies, data search looks inside the stored values, which is how you find which table and column a given phone number actually lives in. The results grid shows match counts and DDL, filters by object type, database and connection, accepts wildcards, and exports to CSV for handing to a colleague.
It is the fully free member of the Devart dbForge family, adding a dbForge Search entry to the SSMS menu bar without a separate window.
Features
Cross database object search: Query tables, views, procedures, functions, triggers and columns across many databases in one pass.
Data search: Find a value inside actual table data to locate which table and column holds it.
Definition body matching: Matches the SQL text of procedures and views, not just object names, so dependencies show up before a change.
Results grid: Object type, database, match count and a DDL preview, with a double click to the definition.
Filters and wildcards: Narrow by object type, database or connection; wildcards substitute any characters.
CSV export: Export results to build a change impact list.
SSMS integration: Loads as an add-in inside SQL Server Management Studio, no separate window.
