SQL 2000SP3 Enterprise Manager

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maida - 30 Oct 2006 18:45 GMT

How can you troubleshoot why it is taking so long for the databases to
display after selecting Databases? It's for ever - - - - -- -

Thanks for your help!

Reply to this Message

Kevin3NF - 30 Oct 2006 19:07 GMT

How many are there? Is it over the LAN or a remote SQL Sever?

Are the databases set to AutoClose?

Signature

Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com

> How can you troubleshoot why it is taking so long for the databases to
> display after selecting Databases? It's for ever - - - - -- -
>
> Thanks for your help!

Reply to this Message

Maida - 30 Oct 2006 19:40 GMT

WE have 17 db including Northwind, Master and pub and no auto close.
Everything was working fine until we moved it to our new Domain. We have a
software firewall between the two domains. All are in the same building -
Thank you,

> How many are there? Is it over the LAN or a remote SQL Sever?
>
[quoted text clipped - 4 lines]
> >
> > Thanks for your help!

Reply to this Message

Dan Guzman - 31 Oct 2006 02:05 GMT

Also check to make sure ODBC tracing is turned off.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> WE have 17 db including Northwind, Master and pub and no auto close.
> Everything was working fine until we moved it to our new Domain. We have a
[quoted text clipped - 9 lines]
>> >
>> > Thanks for your help!

Reply to this Message