web based msde dba tool - Shusheng SQL Tool 1.0 details

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.