Advanced Objects Search

Advanced Objects Search allows to search for database objects, columns and function parameters across one or multiple connections directly from the SSMS user interface.

To open the search dialog click button on the SSMSBoost toolbar. Appeared Dialog can be used in docked or floating state within the SQL Server Management Studio interface.
To use the search function simply start typing first letters of the object, column or parameter name in the filter row. You can use Wildcard characters ? and * in your search string.

  • 1. Sync connection with current document sets search context to the current connection of the active SQL Editor window.
  • 2. Current search context drop-down (in single-database search mode) allows you to select search context.
  • 3. Refresh reloads objects cache. Use it only if you have modified database objects.
  • 4. Limit to Favorite Object Types search will be performed only within your favorite object types (configurable in settings).
  • 5. Show System Objects adds system objects to search results
  • 6. Multi-Database search button switches between single- and multi-database search modes.
  • 7. Settings button opens Settings window where you can configure default behavior of the dialog and some additional useful options. Make sure you check these options - they can save you a lot of time.
Here's the list of operations that can be performed with Search results:
Double click the Object to set it as the Search Context, that will allow you to perform further search for object's columns or parameters. (This function will only work for database objects with columns/parameters)
The following buttons at the bottom of the dialog will be enabled if an object is selected in search results:

  • 8. Script Selected Object(s) - opens SQL source in new editor window
  • 9. Locate Object - navigates Object Explorer to object's node
  • 10.Copy Selected Identifier(s) into Current Document - inserts selected objects into current cursor position
  • 11.Right-click an object (or the selection of multiple objects) to open the context menu with the functions described above.

Advanced database objects search in SSMS with SSMSBoost add-in