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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 04/22/04 

Date: Wed, 21 Apr 2004 17:12:48 -0700

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. Also make sure none of the databases are set to
AUTOCLOSE, because then they must be opened before they can be displayed.

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

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"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: Move 10 DBs and provide dev access thru EM?
    ... DBs open. ... "Dan Guzman" wrote: ... need to stop SQL Server. ... the process using the database files. ...
    (microsoft.public.sqlserver.security)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... this you may well enter the realm of an unsupported configuration and that's ... > things - and hence has enterprise manager - then this approach won't work. ... > If you just want to lock down a database, then I'd try my approace - lock ... >>> who needed to execute an SP on my server at his location. ...
    (microsoft.public.sqlserver.security)
  • Re: restore master and not working the enterprise manager**
    ... Enterprise Manager is different from what's stored in the backup. ... I suggest you go to command prompt, and login to SQL Server using the same ... specify the default database as master). ... restored now) was taken, then you will have to restore or attach those ...
    (microsoft.public.sqlserver.server)
  • Re: Replication left the database in a weird state
    ... I've noticed the following under the database server: ... but it was mild enought for SQL Server to recover from ... this time I could actually drill in the Enterprise Manager ...
    (microsoft.public.sqlserver.replication)
  • Re: Working with a hosted MS SQL Server database
    ... My ISP allows me to register my own database in Enterprise manager. ... Server -- especially the ones running on web servers. ... I want to be able to work with or manage an SQL Server 2000 database ...
    (microsoft.public.sqlserver.setup)