Re: Enterprise Manager for shared server

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

Date: Mon, 28 Jun 2004 11:01:29 -0400

If you open the properties of the MMC (EM) and go to the advanced tab there
is a checkbox to tell it to open to the last active node. This may or may
not speed up the time it takes to get there though. Make sure you have
Autoclose turned off on your databases as well. 

-- 
Andrew J. Kelly  SQL MVP
"rc" <no@email.com> wrote in message
news:%23WLFo$RXEHA.2364@TK2MSFTNGP12.phx.gbl...
> Hello,
>
>
>
> We currently have our web site hosted and are also using a shared SQL
Server
> for the site. When programming the site, I routinely use Enterprise
Manager
> to design tables, look at raw data, write or diagnose Stored Procedures,
> etc..etc...All of this works fine.
>
>
>
> However, because this server is shared, there are several hundred
databases
> (in addition to our one) that are maintained on this same server. It takes
> 2-3 minutes (over a DSL line) for Enterprise Manager to propagate the
entire
> list of databases.
>
>
>
> I currently have the IP address of the server listed in the "Registered
SQL
> Server properties"
>
>
>
> Is there any way for Enterprise Manager to only go directly to our
database?
>
>
>
> Any insight would be helpful.
>
>
>
>
>
>
>
> Thank You
>
>

Relevant Pages

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • REPOST:SQL Login with no Fixed Server Role and DB Role can stop SQL Agent Service?
    ... I had checked all the user rights, and everything seems to be proper...but ... running SQL 2000 Enterprise Edition on ... Windows 2000 Server. ... SQL Server on his Enterprise Manager using this SQL Login. ...
    (microsoft.public.sqlserver.security)
Quantcast