I am using a remote database that has over 2500 databases registered on it.
Unfortunately for me I can not list the databases in the Object Explorer pane anymore. I have to use my Object Details window for the list of databases.
In SQL Server 2000 you could specify that you wanted to only expand a tree view of database objects from a specified node - this is missing in SQL Express 2008. I also would like to be able to Filter the database views to only list MY database, instead
of the 2500 + this server hosts.
I see the icon 'filter' on the toolbar, but it's disabled. How can I get my database to show up again in the Object Explorer instead of the Object Details window (F7).
OR How can I increase the limit of 2500 databases that will show in the Object Explorer. I can see why Microsoft set this limit ? But I can't see why they didn't allow any filtering OF that list. It's just kludgy to say- anything over aggregate
count of 2500 will mandate the entire list will no longer show in Object Explorer. I'd hope to see a feature that lets me say- ONLY show databases that match by THIS pattern - or specific name. PECULIAR I explicitly SET the database to connect
to in the Options during database registration ? But that information seems to be left out of the equation on what to show
View Complete Post