Re: Enterprise Manager "New Window from Here" Hack or Whatever

From: Mark Jerde (mark.jerde_at_verizon.no.spam.net)
Date: 04/22/04 

Date: Wed, 21 Apr 2004 20:36:11 -0400

Kalen Delaney wrote:
> Do you have the latest Service Pack on the client where Enterprise
> Manager is running? There is a bug in EM where it does way too much
> work for every database while it is opening it. I'll admit, 600 dbs
> is a lot, but it shouldn't take 20 minutes.

Yes, I keep all my machines up to date.

> Also make sure none of
> the databases are set to AUTOCLOSE, because then they must be opened
> before they can be displayed.

Is this something I can do, or is it a responsibility of the web host? (I'm
in Maryland, USA, and the host is in California.)

> Also, could you consider changing the db's name to something closer
> to the start of the alphabet?

Not an option. When I signed up for the $10 per month db they assigned me
the db name. I don't see as it matters, though, as the whole tree has to
populate before I can click on anything.

> > "Mark Jerde" <mark.jerde@verizon.no.spam.net> wrote in message
> news:ukL0hx$JEHA.2012@TK2MSFTNGP11.phx.gbl...
>> Sorry if this is a FAQ. Googling way joyless. ;-)
>>
>> I have an MS SQL 2000 database on a web host. Since there are about
>> 600 dbs on the host's server it takes about 20 minutes to expand the
>> databases on the server in SQL Server Enterprise Manager. After the
>> 20 minutes, I scroll down to my db (it's near the bottom <g>) and
>> select "New Window from Here".
>>
>> I'm absolutely disinterested in the 599 dbs I can't open. I know
>> the server name and the db name that I can open. Is there any way
>> to hack MMC to do a "New Window from Here" to my database? I'd love
>> to skip the 20 minute useless population of all dbs on the server!
>>
>> Thanks.
>>
>> -- Mark

Relevant Pages

  • Re: SQL 2005 Tools
    ... I have warned the manager again via email of the risk of doing this and he ... things yet he requested the password from me to access the server and poke ... around the database and doing all sorts. ... You'll need to enable the ports and protocols using the SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: sqlservr.exe taking 90% of memory
    ... On the defrag issue I would stop all non-essential services but specifically ... It might be worth asking this on an sql server specific ... It would be interesting to have SQL Server Manager running and ... the database server every 30 minutes, which if you are having a slowdown ...
    (microsoft.public.windows.server.sbs)
  • Re: Problems with ado
    ... See if you can create a database using SQL2000 Enterprise Manager ... If none can be seen by QA => QA damaged, uninstall SQL2000 and reinstall ...
    (microsoft.public.data.ado)
  • 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)