web based msde dba tool - Shusheng SQL Tool - web-based MS SQL Server (MSDE) 2000 client tool, query analyzer and dba utility

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.