I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially when your environment has thousands of objects. Upon some research I found a Redgate tool that is free called SQL Search and it is an installation I do not regret at all.
Let’s dive in.
Installation is a breeze where you can download the installer from: http://www.red-gate.com/products/sql-development/sql-search/
Make sure all current SSMS connections are closed – don’t worry too much as the installer will check for you.
Let’s check out the functionality of the tool which you will now see within SSMS’s menu bar.
For the first example I leave all default options on – such as searching across all databases against all objects
I have highlighted (above) where you type and it uses a dynamic behaviour, by that I mean you get results as you type. So I decide to search for a name of a stored procedure where I totally forgot about where it resides called AttackBytes.
As soon as I type the first 2 letters (A,T)…. it will preload with options.
There it is within my playhome database where the bottom window will show you the T-SQL.
If you click the “select object in object explorer” link it will navigate to the object within SSMS.
This is totally usefully if you are searching against hundreds of objects and it has saved me time.
Wild-card searching is also supported – for example searching for table names pe% across the server where table definitions will also be provided.
1 object I couldn’t search across was sequences, ok I know sequences are not a big deal in SQL Server like in Oracle but I thought I would mention it. It is a product that I have been using for a month now without any issues.
What else would I like to see? Maybe an extra option to skip checking across comment blocks – but I feel that might be a tough one to add.