I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and other objects quicker than by using standard SSMS features. Few of them were very well usable but all of them are built to support also complex searching including schema, source code occurence, object type etc. etc. This is basically good feature but if you’re inside furious T-SQL coding you just want to jump accross objects with quickest way possible – every filter criteria or detail you must take care of is slowing you down.
This is the ideal situation for me:
1) press e.g. CTRL+T to bring tiny search window
3) enter part of object’s name
4) choose object and press ENTER to bring ALTER script or open window where this object is already opened
I prepared prototype of add-in which perfectly fulfills my requirements, sample screenshot is here:
Here is also short video showing some more use cases.
Feel free to comment.Tags: Add-In, filter criteria, quick find, search, search window, SQL, SSMS, SSMS Add-In, Stored procedure, t-sql