Filter Databases In Object Explorer (Management Studio) - by Darren Terrell

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 270659 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/13/2007 7:21:14 AM
Access Restriction Public


I work in environments where hundreds of databases exist on a particular server/cluster.  It's a headache to scroll down the list especially when I only use a couple of the databases on the server.  
Sign in to post a comment.
Posted by Gaijintendo on 1/30/2012 at 1:40 AM
It isn't about working with a single database. I might be working on a family of databases, for example Northwind_dev, Northwind_demo, Northwind_live, Northwind_arch, Northwind_SpuriousExample, the filter which appears on every level of the hierarchy would allow me to focus on a single project family.... not just a single database... consider reopening this, or else you might be fixing a problem that doesn't exist.
Posted by RSLewis on 7/30/2011 at 1:02 PM
Wow. It's 2011, and a feature that one would think would be obvious, considering that a filter already exists within the database level already, is still not available. I never thought about it too much until I started working with remote servers that contain hundreds of databases. Every time I have to find my database in the list, it wastes my time, which is the same as wasting my money. The best Microsoft can do is blow us off with the "looking for alternatives" line? Come on. It's been four years since the post by Darren Terrell. I have made a living developing in Microsoft technologies, and I still wonder why I bother. How many service packs have been released for management studio 2008? You couldn't find time to add this little feature that would save me so much time and aggravation? Thanks so much, Microsoft for your usual attention to detail.
Bob Lewis
Posted by Microsoft on 7/1/2009 at 11:39 AM
Hi Darren,
Thank you for your feedback regarding the desire to filter the databases you see in Object Explorer. We are looking into different alternatives to make working with a single database easier, but for now, we are closing this issue.
Thank you,
Bill Ramos
Posted by Microsoft on 11/12/2007 at 8:21 AM
Hello Darren Terrell,

Thank you for reporting this problem. We understand the inconvenience caused in finding information when there are large number of databases, tables, views or columns.

We would try to address this problem in the future releases of SQL Server.