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

One possibility would be to use query analyzer instead of enterprise
manager. If they gave you the client tools to install it should have
included QA. You might also want to install SP4 because if I remember
correctly there were some improvements that may help this situation.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Vsevolod Ukrainsky" <vsevolod@xxxxxxxxxxxx> wrote in message
news:%23LG0a4ALHHA.3872@xxxxxxxxxxxxxxxxxxxxxxx
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: Bug bei Sql2000 SP3???
    ... Wie kann man denn nur die Managementkonsole neu installieren? ... bleiben wir doch beim richtigen Namen "Enterprise Manager", denn Du hast ja wohl einen SQLServer 2000, oder? ... Ich benutze den Enterprise Manager auf den Servern fast nie, sondern fast immer meinen lokal installierten, bzw. administriere die Server mittlerweile über das 2005er SQLServer Management Studio. ...
    (microsoft.public.de.sqlserver)
  • Re: Enterprise Manager 2000?
    ... MS Web Data administrator acts similar to Enterprise ... Install this on the Database Server. ... Windows 2000 Server which has IIS. ... I am afraid you cannot use Enterprise manager until you ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 Enterprise Manager wont connect to SQL 7.0 database
    ... After clearing the history try connecting to databases using enterprise ... > I am using SQL Server 2000 Enterprise Manager to try to connect to a ... > remote SQL Server 7.0 database which resides at my web hosting ...
    (microsoft.public.sqlserver.connect)
  • Re: Enterprise Manager "New Window from Here" Hack or Whatever
    ... > Do you have the latest Service Pack on the client where Enterprise ... > work for every database while it is opening it. ... >> databases on the server in SQL Server Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • RE: Kein Zugriff auf Daten!
    ... Enterprise Manager und Access-Projekte). ... Manager auf dem Server resultiert. ... Next by Date: ...
    (microsoft.public.de.sqlserver)