Connect to server using Windows or SQL Server authentication
Create , edit and delete any objects ie. database, table, index, key, constraint, trigger, stored procedure, view, user / inline function, login, user, role etc.
Quick data search. Edit, delete, add data like a spreadsheet.
Execute any SQL commands (single or compound), DBCC commands and DOS commands.
Streamlined Query Process best for very large table Query. (SELECT * FROM million_row_table ? No mess.)
Export data to MS Access 97, MS Excel, CSV, XML, WDDX, HTML Formated E-Mail, Fixed Length Text and other 6 text based format for download or sending.
Manage SQL Server agent : category, operator, alert, job (with step tool and schedule tool)
Manage security: logins, users and roles
Manage authentication : object permission and user permission.
Monitor who, since when, from where, through what application, connect to which database, lock what table, view, index, what kind of lock, CPU time and Memory holding in an easy-to-read flat table.
|
Screenshot
