Open default DB in Enterprise Manager upon connecting to server (SQL2000)

FYI: my sincere apologizes if this group is not the right place for my
questions.

Hello,

1. My hosting provider hosts ~500 databases on the server where my DB
resides. To open my database I use SQL Server 2000 Enterprise Manager.

While server connection timeout is short enough (about 1-2 seconds), when I
click "Databases" folder in server hierarchy, trying to enlist all
databases, it takes and extremely long period of time to set up a list.
Moreover - 60% of attempts usually fail. - Enterprise Manager hangs deadly
and its process could be terminated only by Task Manager.

My first question is: why does EM take such a timeout to display a list of
databases and why in most cases it halts?

2. To open my database and to start working with it I each time have to
perform the above steps. However I find it rather silly - to enlist all
databases first and ONLY THEN select mine. Logical approach to the process
of database connection suggests NOT to enlist all databases (I really need
only one!), but configure server (client?) that way that upon connecting to
server it automatically defaults to my DB.

My second question is:
Has SQL Server 2000 Enterprise Manager such a feature? Can I configure it
not to enlist all databases upon connecting to server, but switch directly
to mine by default?

Thank you in advance.
Vsevolod.


.

Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • Re: How to check if SQL 2000 is installed? (SBS 2003 SP1 Problem!)
    ... > Enterprise manager" and view the databases running on your server (just ... > click the + until you see databases), then you definitely have a SQL ... But I have sometimes installed two Tools called "MSDE Manager" and "MS SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Error trying to connect to local database - What is going on?
    ... I am certain that it is not database connectivity per se that is the problem, as most of the databases are working fine. ... This server runs some e-commerce sites that use common code, so those databases have a common structure. ... All I did was change the name of the server in the connection string. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enterprise Manager for shared server
    ... Autoclose turned off on your databases as well. ... Andrew J. Kelly SQL MVP ... > that are maintained on this same server. ... > 2-3 minutes for Enterprise Manager to propagate the ...
    (microsoft.public.sqlserver.programming)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)