You can easily find SQL objects, data, and text in your databases with Search for SQL Server, an add-in for Microsoft SQL Server Management Studio that is available for free.

Finding a particular table or remembering the names of your stored routines can be a real challenge when dealing with databases that include many objects. Finding a specific column name or text within a stored procedure is now a breeze with Search for SQL Server, eliminating the need to scour the full SSMS Object Explorer. You will undoubtedly find this database search tool to be a lifesaver.

See the tool's details: https://www.devart.com/dbforge/sql/search/