Centralized Administration in a Distributed Environment (ASP and SQL Server)

?bill’s vast expanse (my personal web site since 1995) includes a collection of SQL Server admin scripts, tools, and utilities I collectively refer to as the
admin subsystem. The tool set is intended for the DBA working in a distributed SQL Server 6.5 environment that finds the Maintenance Wizard too limiting. Features include automated
DUMP/LOAD replication, error reporting by email and network broadcast, and log dump replication with automated failure recovery.

There have not been many changes to the original information posted on the vast expanse for over a year in the interest of keeping it simple. At the same time, the admin subsystem has evolved. What you’ll find posted here is a distributed SQL Server 6.5 administration utility that plays with ASP, ADO, JavaScript, DHTML, Stored Procedures, TSQL scripts, Triggers, and the NT command line to enable an
albatross grade Administrator to get the job done. The tasks are table driven and the enrollment of remote servers is automated from an ASP page. The result is an administration tool that is
slightly more difficult to set up because it is more complex yet extremely flexible and easy to
use once in place.

This article will describe a three step implementation of the utility.
The first step will be to set up an Intranet web site that will allow
you to check the status of the active scheduled tasks
on a SQL Server. In this step, you must resolve all issues around web site access
and security. The second step will be to establish a database that will act as the focal point of
all administrative tasks in the environment. The aim will be to establish a single point of
maintenance administration.
The third step will be to enable the browser front end to drive
the administrative database. This will provide you with an alternate access to your SQL
Server administration system for
those times when you do not have access to an Enterprise Manager. At this point you will be
prepared to modify and
enhance functionality of the admin subsystem to the precise requirements of your


So, if you’re ready and interested start building
your admin subsystem
. If your not absolutely convinced
that this is the best thing since the
pop top beer can, maybe you’d like to see a

demo of the front end

. There is also a working copy of this component at VI Gallery.
Here at www.swynk.com the demo is a snapshot of the utility while the VI Gallery
had a SQL Server 6.5 scheduler available to show the utility in action.

Download the complete admin subsystem with installation instructions.

Latest Articles