Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Add-In for searching object in SSMS without touching mouse

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: , , , , , , , , ,


Comments

Posted by Anonymous on 8 November 2011

Pingback from  Dew Drop – November 8, 2011 | Alvin Ashcraft's Morning Dew

Leave a Comment

Please register or log in to leave a comment.