Post reply

Definitive Word on Enterprise Manager Downloading Database List?

  • December 5, 2004 at 12:04 pm

    #163298

    I'm a web weveleper/programmer working in ASP/ASPX.  Like most developers, I use a commercial offsite web host for all of my clients' websites.  Recently I started reselling for E-insites as they offer an excellent reseller package, including unlimitted SQL Server databases (up to the total size of your account--in my case, 1GB).

    The only problem is that they have so many databases on their SQL machine that I can't use Enterprise Manager.  I double click on the databases folder in EM and 5 hours later it's still working (this on a 768 SDSL line).

    Usually this is not a serious problem--I use Query Analyzer and Access clients for most of my work.  But occasionally I really need EM and it's simply not an option.

    From reading posts on this forum I tried installing SP3a on my client, and sent a request to my web host's support department to turn Auto Close off (still awaiting a response).

    Is there

    1. anything I can do to tell EM not to download all the details for each DB, but just download the DB names?
    2. an alternative client to EM out there with which I can connect, and make design changes to my databases?

    Thank you for reading my post.  Your help is much appreciated.

    Aaron

  • December 6, 2004 at 1:46 am

    #532599

    1. No, not really. master..sysdatabases can be read by anyone who connects, AFAIK. The regulating factor however is the access to those dbs.

    2. I guess there are quite a few around. Such as myLittleAdmin. But I don't know what functionality the offer. But to simply make design changes you already have the "best" tool around. Query Analyzer.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply