can't open 'databases' folder

[Navin Kulshreshtha]

Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on?????
Please email response to nk********@hotmail.com as well as posting to
group.

Thanks,
Navin

[Erland Sommarskog]

[posted and mailed, please reply in news]

Navin Kulshreshtha (am*******@hotmail.com) writes:

Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on?????
It could be that autoclose is turned for one or more databasees. Connect
with Query Analyzer, and run an sp_help and check the options columns.

Also check that you have not enabled ODBC tracing on your machine.
Please email response to nk********@hotmail.com as well as posting to
group.

If you want replies to a certain address, please put it in the Reply-To
field of your posting.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp