web SQL programming tool - Shusheng SQL Tool

- Version 1.1

web-based SQL programming tool for sql programmer.
Program stored procedure, view, user function, inline
function, trigger, checks, job steps and other sql
scripts from a web browser with syntax highlighting,
syntax check and sql query optimizer.

1. MDI SQL Programming Interface, exec / stop sql
query.
2. Login as Windows or SQL user.
3. Streamlined for large sql query program (return
million rows without freeze).
4. Pure ASP script program, no installation needed.

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

For SQL Programmer
o Color-coded SQL Program Editor for View,
Stored Procedure, User function, Inline function and
Trigger.
o Create and modify sql database, table,
index, constraint (default, check and foreign key).
o Automatic sql script programming for
Duplication and Orphanage check.
o Database-wise search for a specific value
(number, datetime or text format).
o Database-wise search for a specific sql
object (table, view, stored procedure, user / inline
function and trigger).
o Automatic sql database documentation /
dictionary.

For SQL End User
o Query any data with a color-coded SQL panel.
o Edit sql 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 sql database.
o Create user table, view, function, trigger,
index and other sql constraint.
o Execute any SQL script (multiple, compound
query), MS DOS command.
o Save and open SQL script from local disk.