Filtering on databases in Management Studio

Ever since I started working with Microsoft SQL server, there have been more than only one database on each of my servers. It can ba a nightmare to manage a installation with more than a few databases, and it is much like when we are working inside a specific database, consisting of hundreds of tables.

It can be a rather large task to pinpoint the excact table, view, function, stored procedure or what have you, but since a few versions ago, we have had the possibility to filter on these objects.

050213_0643_Filteringon1

Like in the picture above, I have made a filter so only tables belonging to a schema containing the word “Human” appears on the list.

Why is it that this feature is not implemented as an option to filter on databases, in some installations, where there are maybe more than 100 databases it would be a real treat to have this option.

Since the code is already implemented as a filter option on other objects, I would have to say that it would be rather easy to implement.

As you can see I am not the only one suggesting this to the SQL server team :

https://connect.microsoft.com/SQLServer/feedback/details/718007/filter-the-databases-list-in-object-explorer-oe-list-in-management-studio

https://connect.microsoft.com/SQLServer/feedback/details/488488/hide-or-filter-databases-in-ssms

https://connect.microsoft.com/SQLServer/feedback/details/497849/ability-to-filter-database-list

https://connect.microsoft.com/SQLServer/feedback/details/270659/filter-databases-in-object-explorer-management-studio

For some reason they have decided to close this suggestion, and will not implement it in a version, they just say they would consider it.

Leave a Reply

2 comments

  1. Chance says:

    Someone I work with has this feature on his SSMS, I’m going to ask him to share the code/whatever with me, and post back here.