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

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

Date: Wed, 21 Apr 2004 17:56:40 -0700

Mark

Please verify the actual version of EM that you are using and the version of
SQL Server itself.

AUTOCLOSE is a property of the database in SQL Server.

SELECT databasepropertyex('<dbname>', 'Isautoclose')

if this returns 1, the database is set to autoclose. So are not all the
other databases under your control? If they all have autoclose on, you're
pretty much SOL until the next version of SQL Server comes out. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@verizon.no.spam.net> wrote in message
news:OreERHAKEHA.3120@TK2MSFTNGP11.phx.gbl...
> 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: Slow initial record write
    ... 'autoclose' as 'off' so I guess this isn't the issue. ... directly to the SQL server and it was as follows: ... > To find out execute the following within Query Analyzer: ... > be due to the database starting up. ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow initial record write
    ... > 'autoclose' as 'off' so I guess this isn't the issue. ... > directly to the SQL server and it was as follows: ... >> To find out execute the following within Query Analyzer: ... >> be due to the database starting up. ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sql server slow
    ... My autoclose suggestion might help Miles' EM database enumeration problem ... Slow connectivity can have many ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)