How are clients (customers) typically connecting to and managing hosted SQL 2000 databases?

We have successfully deployed SQL Server 2000 in-house and would now like to make this resource available to a handful of hosting customers. However, we're unsure how to approach client access. As far as I can tell, there is no "web interface" to SQL 2000 Server Enterprise Manager. So, do we "Link" our SQL server to the customer's SQL server in order to provide Enterprise Manager access? What if the customer doesn't have SQL Server? Are there other client tools available for remotely creating/migrating and managing a SQL 2000 database?

Any recommendations are greatly appreciated.

As far as i am aware EM 2000 is the proper software to use for access which would have to be downloaded from the msdn download site.

Other alternatives are MSACCESS 2000 ( haven't tried ) and more expensive tools like DBArtisan and SQLProgrammer. There are other odbc connection db software out there but as to whether they talk to SQL 2000 I don't really know.

Thank you so much, Steve.

That's great to hear that Enterprise Manager is available for free download. [Perhaps we could mirror it on our site, since any link we place from our support FAQs to Microsoft will certainly be broken within a week.] Given that our customers will have a client available (even if they don't own SQL and perhaps upgrade from an Access database), I'm now confident that we can roll forward.

Thanks again.