web based msde dba tool - Shusheng SQL Tool 1.0

web-based MS SQL Server(MSDE)2000 client tool, query analyzer and dba utility to design, create, query, backup, manage and monitor database from a web browser. Pure ASP script, no installation needed. Freeware for Educational and Personal usage.

For DBA ( Database Admin )
o Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
o Monitor connections, locks and performance of SQL server. Kill bad process.
o Administrate security for server logins (Windows and SQL accounts), database users and roles.
o Assign permission to user(s), role(s), object(s). Support column level permission.
o Backup, Restore and Repair database. Compress Transaction Log.

For Developer ( Database application )
o Color-coded Editor for View, Stored Procedure, User function, Inline function and Trigger.
o Create and modify database, table, index, constraint (default, check and foreign key).
o Automatic Duplication and Orphanage check.
o Database-wise search for a specific value (number, datetime or text format).
o Database-wise search for a specific object (table, view, stored procedure, user / inline function and trigger).
o Automatic database documentation / dictionary.
o Automatic Parent / Child Key tracking and Object Dependency tracking.

For End User ( Specific permission might required from DBA )
o Query any data with a color-coded SQL panel.
o Edit table data in a spreadsheet-like Editor. (with row/column copy/paste/reset, fill down feature)
o WYSIWYG Editor to edit and store large plain/HTML document in the database.
o Create user table, view, function, trigger, index and constraint.
o Execute any SQL script (multiple, compound query), MS DOS command.
o Save and open SQL script from local disk.

For all
o Secure login from Internet as a Window.
o Streamlined query process for large query (return millions of rows without freeze).
o Virtual MS DOS prompt window.
o Current running Query cancellation.