Great free tool from Microsoft to manage MSDE

[Berry Morgan]

Try the SQL Server Web Data Administrator at:

http://www.microsoft.com/downloads/...98-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Overview

The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:

Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000
Desktop Engine (MSDE 2000)

Perform ad-hoc queries against databases and save them to your file system

Export and import database schema and data

Manage users and roles

View, create and edit stored procedures

Whether you are doing Microsoft Windows or Web development, or just need
remote access to data for yourself or your clients, the Web Data
Administrator is the perfect complement to your toolbox.



-Berry

 

[Wayne Wengert]

Berry;

I tried it out and am very unimpressed. It is VERY slow (I was testing using
a SQL 2000 DB). Whatever you select (tables, SPs, etc.) they take quite a
bit of time to load. The Query tool requires you to know all field names
from memory (no way to open a table and keep the list of fields open while
writing the query). I wrote a query, ran it and then saved it. I have no
idea where it was saved or what its name is.

Good idea but, in my opinion, a poor implementation.

Wayne