June 3, 2011 at 3:09 pm
Hi,
my issue is that I have hundreds of procedures and tens of databases on my projects and managing them using standard management studio (because many reasons). It is absolutely frustrating if you open stored procedures node in SSMS and it expands 200 procedures and you are browsing with your eyes for the right one. I was searching for suitable solution for a while, found one solution only but it's not good and even expensive. I decided to write my own SSMS addin and it works exactly as I need, supports custom folders within standard SSMS nodes (even nested), drag&drop etc. So I can organize my stored procedures according my modules like it could be done on filesystem. It is now still in testing but I guess that will be finished during in one month (I will make it public for free). You can check some screenshots here.
My question is if you have same experience with SSMS and hundreds of objects and whether you have any alternative solution?
Thanks
ps: if you give me any feedback on my addin, I will appreciate.
__________________________________________________________________________________________SQLTreeo.com - My Blog and Free SSMS Productivity Add-In
June 3, 2011 at 4:37 pm
I also had the same problem in my everyday work, having 10 000+ procedures per database. You can imagine how log it takes to find the right one in the tree :w00t:
That is one of the reasons I also made a plugin for SSMS, called xdetails (www.sqlxdetails.com).
Type part of the name in sql editor and press ALT+1, and you get the procedure code (or lists matching procedures if there is more than one match). Press "Edit" and procedure code is in new editor window.
June 6, 2011 at 4:50 am
I usually use SQL Search (http://www.red-gate.com/products/sql-development/sql-search/) and then double click the item I need but both the addins mentioned will get a download in the near future!
gsc_dba
August 8, 2011 at 3:07 am
Hi,
just to let you know: I've finally finished mentioned SSMS custom folders add-in. It is downloadable here.
Jakub
__________________________________________________________________________________________SQLTreeo.com - My Blog and Free SSMS Productivity Add-In
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply