Enumerating Sql Server Databases

Hi. I would like to enumerate all the databases in a given Sql Server instance.

I've searched and found no information. Would somebody post a piece of VB code to do that?

Thanks in advance

Rafael

You can do it with an SQL string:

use masterselect *from sys.databases

|||

SELECT

*

FROM

master.sys.databases

Should work, but there is probably a more standard way.

|||There is also a stored procedure called:sp_databases

Enumerate databases

This shouldn't be too hard but I can't find the right answer: How can I
enumerate all databases in my SQL Server (V7)?Try:

SELECT name FROM sysdatabases

I've also seen the INFORMATION_SCHEMA.SCHEMATA view (SQL 2000) used for this
purpose but that should be avoided. That technique will break in SQL 2005
because the vew behavior was changed to align with the ANSI standard.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"ab" <absmienk@.hotmail.com> wrote in message
news:1151316129.417576.287020@.i40g2000cwc.googlegr oups.com...
> This shouldn't be too hard but I can't find the right answer: How can I
> enumerate all databases in my SQL Server (V7)?|||Thanks Dan, that helped.

Dan Guzman schreef:

> Try:
> SELECT name FROM sysdatabases
> I've also seen the INFORMATION_SCHEMA.SCHEMATA view (SQL 2000) used for this
> purpose but that should be avoided. That technique will break in SQL 2005
> because the vew behavior was changed to align with the ANSI standard.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ab" <absmienk@.hotmail.com> wrote in message
> news:1151316129.417576.287020@.i40g2000cwc.googlegr oups.com...
> > This shouldn't be too hard but I can't find the right answer: How can I
> > enumerate all databases in my SQL Server (V7)?|||At some point they added

sp_databases

as a command that could be run. It works in SQL 2000 anyway.

--
-Dick Christoph

"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:rNPng.53612$fb2.23804@.newssvr27.news.prodigy. net...
> Try:
> SELECT name FROM sysdatabases
> I've also seen the INFORMATION_SCHEMA.SCHEMATA view (SQL 2000) used for
> this purpose but that should be avoided. That technique will break in SQL
> 2005 because the vew behavior was changed to align with the ANSI standard.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ab" <absmienk@.hotmail.com> wrote in message
> news:1151316129.417576.287020@.i40g2000cwc.googlegr oups.com...
>> This shouldn't be too hard but I can't find the right answer: How can I
>> enumerate all databases in my SQL Server (V7)?
>>sql

Enumerate All Database Files in Server

Did lots of searching, couldn't find the answer.

I am looking to enumerate all databases and their files on a given server. For example:

Database File Name File Path master master C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf master mastlog C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf msdb MSDBData C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf msdb MSDBLog C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf MyDB MyDB_Data C:\Databases\MyDB.mdf MyDB MyDB_Log C:\Databases\MyDB.ldf

I know you can use sys.database_files to pull this information database-by-database. But I am looking for a sql query that will generate this information at a server level.

TIA.

In SQL Server 2005, this is a snap.

select *

from sys.master_files

This doesn't suffer from any of the limitations of sys.database_files in that sys.database_files can be wrong if the database was restored and read only.

|||

Here you go.

Warning: sp_msforeachdb is undocumented procedure. Use it for single use. Don't stick on this SP.

Code Snippet

Create Table #Databases

(

[Database] nvarchar(1000),

[File Name] nvarchar(1000),

[File Path] nvarchar(1000)

);

Exec sp_msforeachdb 'Insert Into #Databases select ''?'', name,filename from [?]..sysfiles'

select * from #Databases

|||Thanks. Just what I was looking for.|||

Thanks for info on sp_msforeachdb. Very helpful.

Appreciate your time.

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.
Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:
> doug wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:
> doug wrote:
> > Yes, I do have 2 databases 'offline'.
> >
> > I do not get the arithmetic overflow error if I just select the dbid and the
> > name.
> >
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Quer
y
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one yo
u
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one
you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
>|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and t
he
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr Problem in 2000 (Please HELP!)

Typically when I bring up Enterprise Mgr, I get the options to look at the databases, tables, etc. Now, when I choose EM, it brings up the Microsoft Management Console without anything in it except 'Console', 'Window', and 'Help'. When I open a new window, I can see the databases etc. but the top of the window says 'SQL Server Enterprise Manager [2:Console Root\Microsoft SQL Servers]' and a few of the icons are grayed out like 'New Database', 'New Login', and 'New Job'. I haven't changed anything that I know of. Please Help!

thx

Kat

One of the easy ways to fix this is to re run the install of the cliet tools from the server instal disk.

|||

fyi, the reinstallation worked. Also, working on an older pc without much space probably caused the problem.

thx,

Kat

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
Richard
Check your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
RichardCheck your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager, table CreateDate doesn't sort correctly

In EM, when viewing the tables in a database, the tables do not sort
correctly by CreateDate when you click the header. However, in other
databases on the same server, it sorts correctly. Odd.
The only subtle difference we've found is that those databases where the
table create date displays with AM or PM sorts correctly. Those that
display the millisecond in the Create Date do not sort correctly?
Any ideas on how to solve this problem? Thanks in advance!
Mark
SQL Server 2000 with latest and greatest service packs> In EM, when viewing the tables in a database, the tables do not sort
> correctly by CreateDate when you click the header. However, in other
> databases on the same server, it sorts correctly. Odd.
I've seen this too, and can't explain it (nor do I know the fix). I'd show
you the article on my site, but a middleman provider is having issues.
If you really need this functionality, run a query from sysobjects WHERE
xtype='U' ORDER BY crdate DESC...
--
Aaron Bertrand
SQL Server MVP
> The only subtle difference we've found is that those databases where the
> table create date displays with AM or PM sorts correctly. Those that
> display the millisecond in the Create Date do not sort correctly?
> Any ideas on how to solve this problem? Thanks in advance!
> Mark
> SQL Server 2000 with latest and greatest service packs
>

Enterprise Manager very slowly

Hi,
Is there any parameters to configure to improve the performance in the
Enterprise Manager ? I have installed 7 small databases but when I click in
the "Databases" option, for example, I need to wait for several seconds (I
don´t think this is right). There are other options with the same problem.
It´s occur and my two machines (and I already see this in other machines),
the first running Windows 2003 Server Standard RC2 and the second running
Windows XP Professional, both with SQL Server 2000 - SP3.
Any suggest ?
Vitor Mauricio de N. Silva
Rio de Janeiro - BrazilVitor
Have you check odbc trace is running?
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>|||Perfect. I had some databases with the option AUTO CLOSE clicked. After
changed everything works fine.
Thanks,
Vitor Mauricio de N. Silva
Rio de Janeiro - Brazil
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>

Enterprise Manager takes 10+ min to open

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?What version of SQL are you using? Also indicate the service pack
please.

Johnny Ruin wrote:

Quote:

Originally Posted by

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?

|||Johnny,

You can start a profiler session, start EM, and just observe what is
going on under the hood.

--------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/|||"Johnny Ruin" <schafer.dave@.gmail.comwrote in message
news:1161612846.335787.281480@.h48g2000cwc.googlegr oups.com...

Quote:

Originally Posted by

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?

For one thing make sure you don't have the databases set to autoclose.

That can take a long time.

Quote:

Originally Posted by

>

|||Hi everyone,

Thanks for your replies. I checked the version on the production
machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

The profiler idea was a good one. EM goes through it's 16 lines of
'get config stuff' that it does every time it starts, but then it
executes the following query many times. I didn't count the times,
but it looks like it's once per database.

select name, DATABASEPROPERTY(name, N'IsDetached'),
(case when DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else
DATABASEPROPERTY(name, N'IsShutdown') end),
DATABASEPROPERTY(name, N'IsSuspect'),
DATABASEPROPERTY(name, N'IsOffline'),
DATABASEPROPERTY(name, N'IsInLoad'),
(case when DATABASEPROPERTY(name, N'IsInRecovery') is null then -1 else
DATABASEPROPERTY(name, N'IsInRecovery') end),
(case when DATABASEPROPERTY(name, N'IsNotRecovered') is null then -1
else DATABASEPROPERTY(name, N'IsNotRecovered') end),
DATABASEPROPERTY(name, N'IsEmergencyMode'),
DATABASEPROPERTY(name, N'IsInStandBy'),
has_dbaccess(name), status, category, status2 from
master.dbo.sysdatabases

As I paged through the profiler output (can't seem to make that filter
thing work correctly) I realized that a) there's a lot going on this
machine and b) I haven't got a basic sql performance monitoring in my
skill set. I'll work toward that and I'll checkout auto close too.
Thanks again.

On Oct 23, 7:01 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.comwrote:

Quote:

Originally Posted by

"Johnny Ruin" <schafer.d...@.gmail.comwrote in messagenews:1161612846.335787.281480@.h48g2000cwc.g ooglegroups.com...
>

Quote:

Originally Posted by

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?For one thing make sure you don't have the databases set to autoclose.

>
That can take a long time.
>
>

|||Johnny Ruin wrote:

Quote:

Originally Posted by

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?

Go in Options and uncheck the "Server state polling" option in the
General tab. Also in you server registration uncheck the "Display SQL
Server state in console" option.

Regards,
lucm|||Thanks for your replies. I checked the version on the production

Quote:

Originally Posted by

machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

This is the RTM (unpatched) release of SQL Server. I strongly suggest you
consider upgrading to SP4.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Johnny Ruin" <schafer.dave@.gmail.comwrote in message
news:1161696467.830677.213770@.i42g2000cwa.googlegr oups.com...

Quote:

Originally Posted by

Hi everyone,
>
Thanks for your replies. I checked the version on the production
machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "
>
The profiler idea was a good one. EM goes through it's 16 lines of
'get config stuff' that it does every time it starts, but then it
executes the following query many times. I didn't count the times,
but it looks like it's once per database.
>
select name, DATABASEPROPERTY(name, N'IsDetached'),
(case when DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else
DATABASEPROPERTY(name, N'IsShutdown') end),
DATABASEPROPERTY(name, N'IsSuspect'),
DATABASEPROPERTY(name, N'IsOffline'),
DATABASEPROPERTY(name, N'IsInLoad'),
(case when DATABASEPROPERTY(name, N'IsInRecovery') is null then -1 else
DATABASEPROPERTY(name, N'IsInRecovery') end),
(case when DATABASEPROPERTY(name, N'IsNotRecovered') is null then -1
else DATABASEPROPERTY(name, N'IsNotRecovered') end),
DATABASEPROPERTY(name, N'IsEmergencyMode'),
DATABASEPROPERTY(name, N'IsInStandBy'),
has_dbaccess(name), status, category, status2 from
master.dbo.sysdatabases
>
As I paged through the profiler output (can't seem to make that filter
thing work correctly) I realized that a) there's a lot going on this
machine and b) I haven't got a basic sql performance monitoring in my
skill set. I'll work toward that and I'll checkout auto close too.
Thanks again.
>
>
>
On Oct 23, 7:01 pm, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@.greenms.comwrote:

Quote:

Originally Posted by

>"Johnny Ruin" <schafer.d...@.gmail.comwrote in
>messagenews:1161612846.335787.281480@.h48g2000cwc.g ooglegroups.com...
>>

Quote:

Originally Posted by

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?For one thing make sure you don't have the databases set
to autoclose.

>>
>That can take a long time.
>>
>>

>

enterprise manager slow to load on shared server with 200 databases

My db is on a shared server with two hundred tiny databases. Query
analyzer connects very fast, buty Enterprise Manager stupidly reads the
schema for each of the 200 db's while it is loading the GUI. Sadly, it
freezes up for about ten minutes while loading all that stuff.
I love the way EM makes admin a breeze. Is there a way (registry tweak
or something) to make it so it will just show the databases my account
has access to (like query analyzer does)
Thanks, Tom
Nope...you can change the system stored procedures that
Enterprise Manager calls. You can learn to use Query
Analyzer more or write your own utility that works like
query analyzer. A lot of it is written using SQL-DMO. You
can also use SQL-NS for some of the user interface
components invoked with Enterprise Manager. Both SQL-DMO and
SQL-NS are documented in books online.
-Sue
On 1 Mar 2005 16:44:39 -0800, thomasamillergoogle@.yahoo.com
wrote:

>My db is on a shared server with two hundred tiny databases. Query
>analyzer connects very fast, buty Enterprise Manager stupidly reads the
>schema for each of the 200 db's while it is loading the GUI. Sadly, it
>freezes up for about ten minutes while loading all that stuff.
>I love the way EM makes admin a breeze. Is there a way (registry tweak
>or something) to make it so it will just show the databases my account
>has access to (like query analyzer does)
>Thanks, Tom
|||In addition to what Sue recommends make sure you don't have Auto Close
turned on with any of the db's.
Andrew J. Kelly SQL MVP
<thomasamillergoogle@.yahoo.com> wrote in message
news:1109724279.921121.305760@.l41g2000cwc.googlegr oups.com...
> My db is on a shared server with two hundred tiny databases. Query
> analyzer connects very fast, buty Enterprise Manager stupidly reads the
> schema for each of the 200 db's while it is loading the GUI. Sadly, it
> freezes up for about ten minutes while loading all that stuff.
> I love the way EM makes admin a breeze. Is there a way (registry tweak
> or something) to make it so it will just show the databases my account
> has access to (like query analyzer does)
> Thanks, Tom
>
|||Sorry, I don't think i have enough time on my hands to rewrite
Enterprise Manager :P
What stored procedures could be changed to speed up the way it loads
the databases when the databases node is expanded?
Sql-NS looks fascinating, i never knew about that. Looks cool!
Thanks, Tom
Sue Hoegemeier wrote:[vbcol=seagreen]
> Nope...you can change the system stored procedures that
> Enterprise Manager calls. You can learn to use Query
> Analyzer more or write your own utility that works like
> query analyzer. A lot of it is written using SQL-DMO. You
> can also use SQL-NS for some of the user interface
> components invoked with Enterprise Manager. Both SQL-DMO and
> SQL-NS are documented in books online.
> -Sue
> On 1 Mar 2005 16:44:39 -0800, thomasamillergoogle@.yahoo.com
> wrote:
the[vbcol=seagreen]
it[vbcol=seagreen]
tweak[vbcol=seagreen]
account[vbcol=seagreen]
|||Hi Tom,
No...don't think anyone has enough time to rewrite it but
thought I'd mention it as it is an option. Maybe not a
realistic one but an option nonetheless.
Anyway...it calls system stored procedures. Changing those
means you will no longer be running a supported system and
could end up with more problems than you solve. It's just
best not to go there. If you want to see what it's calling,
just run profiler and get a trace of what's executed.
Make sure you check for autoclose as Andrew mentioned...I
forgot about that. And make sure you are on the latest
service pack as there have been some fixes in some of the
service packs related to enterprise manager and it's
performance. And also make sure you don't have ODBC tracing
turned on. You can check the ODBC Administrator applet and
check the Tracing tab to see if it's on.
And then...one other option I just thought of. I don't know
about all of the third party tools but maybe one of those
has the functionality you need without some of the overhead
you are experiencing with Enterprise Manager. You may want
to look at those. You can find a list of them at:
http://www.aspfaq.com/show.asp?id=2442
Hope that helps -
-Sue
On 2 Mar 2005 08:37:15 -0800, thomasamillergoogle@.yahoo.com
wrote:
[vbcol=seagreen]
>Sorry, I don't think i have enough time on my hands to rewrite
>Enterprise Manager :P
>What stored procedures could be changed to speed up the way it loads
>the databases when the databases node is expanded?
>Sql-NS looks fascinating, i never knew about that. Looks cool!
>Thanks, Tom
>
>Sue Hoegemeier wrote:
>the
>it
>tweak
>account
|||Thanks Sue, that more than helps. Much appreciated I have learned more
from you reply then in my last hundred posts to usenet .
I passed on the sql-ns and sql-dmo items to a friend who is devleoping
a sql server front end, he *really* likes it !
Tom
|||FYI, DMO and sql-ns is being replaced by SMO in SQL2005. So he may want to
check that out as well.
Andrew J. Kelly SQL MVP
<tom.a.miller@.gmail.com> wrote in message
news:1109881960.302088.148920@.f14g2000cwb.googlegr oups.com...
> Thanks Sue, that more than helps. Much appreciated I have learned more
> from you reply then in my last hundred posts to usenet .
> I passed on the sql-ns and sql-dmo items to a friend who is devleoping
> a sql server front end, he *really* likes it !
> Tom
>
|||Good to hear and thanks!
-Sue
On 3 Mar 2005 12:32:40 -0800, tom.a.miller@.gmail.com wrote:

>Thanks Sue, that more than helps. Much appreciated I have learned more
>from you reply then in my last hundred posts to usenet .
>I passed on the sql-ns and sql-dmo items to a friend who is devleoping
>a sql server front end, he *really* likes it !
>Tom
|||If anybody else is having this problem, I solved it by installing sql
server 2000 service pack 3, which updated the client tool (enterprise
manager). It still freezes up the EM ui but only for about a minute or
so.

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Query Tool

We have noticed some random failures to write data to some
of our databases. In the
research that I have done I think it is being caused by
users querying the tables
with Enterprise Manager's Query Tool. I am seeing table
level locks that are granted
against the table in Mode IS. I am interpreting this to
mean that there is an 'Shared
Intent' Lock on that table. Which to my understanding
means that anyone can continue
to read but that I have also declared an intent to update
the table and therefore
requests for exclusive locks for update, insert or delete
operations would block
until my intent lock is removed. If the block occurs for
too long the blocked call
would then timeout. I believe that Enterprise Manager is
creating this type of lock
because the user interface allows the data that is
displayed to be updated and if the
Intent lock was not declared then data syncronization
issues would occur.
For now I have instructed people who access the tables to
use Query Analyzer since it
will only lock when queries that require the lock are
executed and will not hold the
lock while the user browses the results.
My questions are as follows:
1) Is my interpretation of the IS Mode Table lock correct?
2) Is there a way to prevent Enterprise Manager from
locking the table in this way
(i.e. make the query results read-only)?
3) If the user that is performing the query only has
dbreader privledges then why is
the Intent lock being created?
Thanxshttp://vyaskn.tripod.com/sql_enterp...er_or_t-sql.htm
"" <anonymous@.discussions.microsoft.com> wrote in message
news:535b01c4003c$1ec4aca0$a301280a@.phx.gbl...
> We have noticed some random failures to write data to some
> of our databases. In the
> research that I have done I think it is being caused by
> users querying the tables
> with Enterprise Manager's Query Tool. I am seeing table
> level locks that are granted
> against the table in Mode IS. I am interpreting this to
> mean that there is an 'Shared
> Intent' Lock on that table. Which to my understanding
> means that anyone can continue
> to read but that I have also declared an intent to update
> the table and therefore
> requests for exclusive locks for update, insert or delete
> operations would block
> until my intent lock is removed. If the block occurs for
> too long the blocked call
> would then timeout. I believe that Enterprise Manager is
> creating this type of lock
> because the user interface allows the data that is
> displayed to be updated and if the
> Intent lock was not declared then data syncronization
> issues would occur.
> For now I have instructed people who access the tables to
> use Query Analyzer since it
> will only lock when queries that require the lock are
> executed and will not hold the
> lock while the user browses the results.
> My questions are as follows:
> 1) Is my interpretation of the IS Mode Table lock correct?
> 2) Is there a way to prevent Enterprise Manager from
> locking the table in this way
> (i.e. make the query results read-only)?
> 3) If the user that is performing the query only has
> dbreader privledges then why is
> the Intent lock being created?
> Thanxs

Enterprise Manager Query Tool

We have noticed some random failures to write data to some
of our databases. In the
research that I have done I think it is being caused by
users querying the tables
with Enterprise Manager's Query Tool. I am seeing table
level locks that are granted
against the table in Mode IS. I am interpreting this to
mean that there is an 'Shared
Intent' Lock on that table. Which to my understanding
means that anyone can continue
to read but that I have also declared an intent to update
the table and therefore
requests for exclusive locks for update, insert or delete
operations would block
until my intent lock is removed. If the block occurs for
too long the blocked call
would then timeout. I believe that Enterprise Manager is
creating this type of lock
because the user interface allows the data that is
displayed to be updated and if the
Intent lock was not declared then data syncronization
issues would occur.
For now I have instructed people who access the tables to
use Query Analyzer since it
will only lock when queries that require the lock are
executed and will not hold the
lock while the user browses the results.
My questions are as follows:
1) Is my interpretation of the IS Mode Table lock correct?
2) Is there a way to prevent Enterprise Manager from
locking the table in this way
(i.e. make the query results read-only)?
3) If the user that is performing the query only has
dbreader privledges then why is
the Intent lock being created?
Thanxshttp://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
":)" <anonymous@.discussions.microsoft.com> wrote in message
news:535b01c4003c$1ec4aca0$a301280a@.phx.gbl...
> We have noticed some random failures to write data to some
> of our databases. In the
> research that I have done I think it is being caused by
> users querying the tables
> with Enterprise Manager's Query Tool. I am seeing table
> level locks that are granted
> against the table in Mode IS. I am interpreting this to
> mean that there is an 'Shared
> Intent' Lock on that table. Which to my understanding
> means that anyone can continue
> to read but that I have also declared an intent to update
> the table and therefore
> requests for exclusive locks for update, insert or delete
> operations would block
> until my intent lock is removed. If the block occurs for
> too long the blocked call
> would then timeout. I believe that Enterprise Manager is
> creating this type of lock
> because the user interface allows the data that is
> displayed to be updated and if the
> Intent lock was not declared then data syncronization
> issues would occur.
> For now I have instructed people who access the tables to
> use Query Analyzer since it
> will only lock when queries that require the lock are
> executed and will not hold the
> lock while the user browses the results.
> My questions are as follows:
> 1) Is my interpretation of the IS Mode Table lock correct?
> 2) Is there a way to prevent Enterprise Manager from
> locking the table in this way
> (i.e. make the query results read-only)?
> 3) If the user that is performing the query only has
> dbreader privledges then why is
> the Intent lock being created?
> Thanxs

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
Mark
Hello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.
|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
MarkHello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> [url]http://msdn.microsoft.com/subscriptions/support/default.aspx." target="_blank">http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==========
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.