ASP 101 - Active Server Pages 101 - Web01
The Place ASP Developers Go!

Please visit our partners

Windows Technology Windows Technology
15 Seconds
ASP 101
ASP Wire
VB Forums
VB Wire
internet.commerce internet.commerce
Partners & Affiliates

ASP 101 is an site
ASP 101 is an site
Internet News
Small Business
Personal Technology

Corporate Info
Tech Jobs
E-mail Offers

ASP 101 News Flash ASP 101 News Flash

 Top ASP 101 Stories Top ASP 101 Stories
Getting Scripts to Run on a Schedule
The Top 10 ASP Links @
What is and Why Do I Need It?

Use design-time controls
Show All Tips >>
ASP 101 RSS Feed ASP 101 Updates

A Look at Microsoft's "Web Data Administrator"

by John Peterson

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.

Screen Capture - Login
Screen Capture - Databases
Screen Capture - Edit Table
Screen Capture - Edit Stored Procedure
Screen Capture - Query

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.


Download details: Web Data Administrator

Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback
The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers