sql server connect: When I connect to my MSSQL 2000 host with Enterprise
Manager using my own private username/password, I still
get a listing of all the other databases (owned by all the
other users). It is not bad incredibly bad for security
as you can only view that the databases exists, but the
problem is that the database list is huge!

On my cable modem it locks up Enterprise Manager for about
20 minutes when I try to expand the Databases section of
the navigation tree. Sometimes it just crashes EM (I'm
assuming that the transfer times out, but EM keeps waiting
to finish). For people with 56k, they cannot access their
own database through EM because of this.

Update: When I use Query Analyzer to connect, it seems to
work properly, so I believe this could be fixed from a
client standpoint.

Does anybody know of any options in Enterprise Manager
that would limit your database listings to only ones that
you own?

Or another option would even be, if anyone knows of any
Enterprise Manager replacements. Software/websites made
by other people which might not have this problem. Any
input would be much appreciated. thanks!

I feel your pain. However I spend most of my time in QA, not EM. The problem is due to the SQL-DMO library that EM is based on, because it loads all information for all databases, not just the names - thus usnig up your bandwidth. This will be "fixed" in SQL Server 2005 ("Yukon"), in that the database access API will only load the database names, and not all other information, which will speeds things up many times

Your best bet is to use QA. You can't filter your list. You might also want to consider using the new WebAdmin tool from Microsoft - this might speed things up for you (http://tinyurl.com/3cuzt)

-
Mark Allison, SQL Server MV