Do you spend part of your day administering a remote SQL Server?
If so, has Microsoft's got the tool for you. Introducing Microsoft's
Web Data Administrator...
In Microsoft's words:
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your
SQL Server data wherever you are. Using its built-in features, you can do the
following from Internet Explorer or your favorite Web browser:
Create and edit databases in Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE)
Perform ad-hoc queries against databases and save them to your file system
Export and import database schema and data
If you ask me... it's just plain cool! They say Win 2000, but I tried it on XP
and it seemed to work fine. Another really cool point is that they ship the source code with it.
Well enough of me rambling... check out the screen caps and go download your own copy.
FYI: I did run into one issue... try as I might I could not get it to find my MSDE databases using "localhost".
When I used the actual computer name everything worked perfectly, but with "localhost" it kept saying it
couldn't find the DB.