|
|
web based msde dba tool - Shusheng SQL Tool
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. database freeware listed in database section.
Keywords: msde 2000 sql server client tool constraint color coded inline function dba repair database automatic database open sql wysiwyg editor compound query plain html document sql script ms dos prompt dictionary accounts database automatic duplication query return ms dos command midi synth president bush
|
