Re: Enterprise Manager for shared server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 14:32:25 -0400

Yes but is it off for all the others as well? In either case 500 +
databases will make it somewhat slow. There is no current way to filter in
EM for 2000 but there will be a way in 2005. 

-- 
Andrew J. Kelly  SQL MVP
"rc" <no@email.com> wrote in message
news:u1Go31TXEHA.1164@tk2msftngp13.phx.gbl...
> The "Auto Close" option located in the Database/Properties/options was
> unchecked (off).
>
>
>
> Like you said, I can see all the databases (500+) but only have access to
> mine.
>
>
>
> Initially, I was thinking I could specify the exact DB name in the
> registration properties of the server (e.g. xxx.xxx.xxxx.xxx\mydb), but I
> don't think it works this way.
>
>
>
> Perhaps there is no way around this. You are forced to drill down to find
> you DB only after all object have been loaded.
>
>
>
>
>
> Any other ideas?
>
>
>
> Thanks
>
>
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:e06uFrSXEHA.1888@TK2MSFTNGP11.phx.gbl...
> > Sounds like the databases may have Auto Close turned on.  Check to be
sure
> > they don't.
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
>
>

Relevant Pages

  • Re: Error 22029 on Maintenance Plan
    ... > Thanks, Andrew, I'll give that a try. ... >> Andrew J. Kelly SQL MVP ... Maintenance plan 1 is for user databases ... >>> databases and does not do log backups. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 user limit
    ... Andrew J. Kelly SQL MVP ... "Marcin S." ... > I just created two databases and two users but both users can see ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Located databases no longer used.
    ... Everyone wants that feature though. ... Andrew J. Kelly SQL MVP ... >> Andrew J. Kelly SQL MVP ... >>> a specified period of time; we are looking to locate databases that are ...
    (microsoft.public.sqlserver.tools)
  • Re: Multiple Access database connections
    ... Thanks, Andrew. ... set up a link for all the databases, so I'll try the dataset solution. ... >> model of Commands and Recordsets. ... >> on my refStateName table on databaseB. ...
    (microsoft.public.data.ado)
  • Re: Moving the Data directory in Desktop Edition
    ... Andrew J. Kelly SQL MVP ... "boe" wrote in message ... > Is it possible to change the location of the databases on the desktop ...
    (microsoft.public.sqlserver.server)