>>Hi,
>>
>>SQL2000 - We are having significant performance issues with some users in Enterprise Mgr. Specifically, it takes 30-40 seconds to several minutes to bring up the list of databases and tables, etc.
>>
>
>The only thing I have seen with EM is making sure that the Auto-Close property of the databases is NOT enabled. This has been reported to make a huge difference in EM.
>
>Also, what type of connection do you have? Are you using the TCP/IP protocol?
>
>BOb
auto close is not enabled - using TCP/IP
Ken B. Matson
GCom2 Solutions