SQL Server Management Studio: Dynamic Folders

One of the problem with SQL Server Management Studio is it shows the objects in one list. For example, see the list of stored procedures for the BizTalkMsgBoxDb database, one of the BizTalk database.
It is a huge list. Smart developers are trying to make this list useful and searchable and use suffixes and prefixes to group the objects together.
See prefixes “adm_” and “bts_”. Following this practice we have got the nested compound prefixes. See the subgroups after the “bts_” prefix.
It is completely and absolutely awful view. We have to scroll down and up this list to find out the right object.
The same lists are for others SQL objects.
But it can be much better with small change.
Let’s create the virtual dynamic folders.
Now the list is short, easy searchable and easy observable. Moreover, the long awful names are folded to something readable. Yes, now the names are readable.
All we can do to this beauty is to set up the parameters for these virtual dynamic folders.
Right-click the “Stored Procedures” folder and choose Properties / Dynamic Folders…
There are only few parameters to set up:
·         Objects to fold, more than X (auto by default)
·         Characters to fold, more than X (auto by default
·         Show full name (unchecked by default)
Folders are smart enough to fold with good taste and intellect. But sometimes it helps to fold objects with unusual name conventions.

 

Print | posted on Tuesday, January 25, 2011 8:51 PM

Feedback

# re: SQL Server Management Studio: Dynamic Folders

left by Gregor Suttie at 1/26/2011 2:34 PM Gravatar
I saw your post and wanted to scream nooo at this idea.

# re: SQL Server Management Studio: Dynamic Folders

left by Mikael Sand at 1/26/2011 11:41 PM Gravatar
Is this a SQL Server 2008R2 feature? Because when I right-click the "stored procedures" folder there is no "Properties" option.

And to reply to Greggie above: Why do you want to scream?

# re: SQL Server Management Studio: Dynamic Folders

left by Leonid Ganeline at 1/27/2011 7:29 AM Gravatar
Thanks for comments!

Mikael: It is not a feature of the SQL2008R2. This inteface addition is still imaginary. Everybody is wellcome to implement it!

Gregor: Why scream?

# re: SQL Server Management Studio: Dynamic Folders

left by Ben Cline at 2/3/2011 12:40 PM Gravatar
Sounds like a cool feature that makes the proc names much more readable!

Thanks Leonid!

# re: SQL Server Management Studio: Dynamic Folders

left by Leonid Ganeline at 2/3/2011 6:38 PM Gravatar
Thank you, Ben!

# re: SQL Server Management Studio: Dynamic Folders

left by ihtesham at 5/18/2011 7:46 PM Gravatar
Hi Leonid. The feature is what i just want now but when i right click on the stored procedure folder i cannot see the properties. How can i see that. You said that this interface addition is still imaginary. Did you implement it. How can i see the properties. Thank you

# re: SQL Server Management Studio: Dynamic Folders

left by Derek Robinson at 4/11/2012 7:38 AM Gravatar
Oh... you mean like SQL TreeO?

# re: SQL Server Management Studio: Dynamic Folders

left by Vincent at 4/30/2013 1:56 AM Gravatar
I have been using SQLTreeo for this on my SQL2012 environment. I can also create folders for databases too!

# re: SQL Server Management Studio: Dynamic Folders

left by kendraa at 11/28/2013 7:51 AM Gravatar
I have been using SQLTreeo. Try it. Here' s the link: http://sqltreeo.com

# re: SQL Server Management Studio: Dynamic Folders

left by Mazhar at 7/20/2017 6:50 AM Gravatar
Schema Folders opensource extension provide similar function though it requires you to have different schemas as logical folders.

https://ssmsschemafolders.codeplex.com/
Post A Comment
Title:
Name:
Email:
Comment:
Verification: