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

Please visit our partners


Windows Technology Windows Technology
15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com
internet.commerce internet.commerce
Partners & Affiliates














ASP 101 is an
internet.com site
ASP 101 is an internet.com site
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
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 @ Microsoft.com
What is Adovbs.inc and Why Do I Need It?

QUICK TIP:
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

Download details: Web Data Administrator


Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

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