Manage authentication : object permission and user permission. Manage SQL Server agent : category, operator, alert, job (with step tool and schedule tool) (SELECT * FROM million_row_table ? No mess.)Įxport 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. Streamlined Query Process best for very large table Query. Edit, delete, add data like a spreadsheet.Įxecute any SQL commands (single or compound), DBCC commands and DOS commands.
database, table, index, key, constraint, trigger, stored procedure, view, user / inline function, login, user, role etc. Connect to server using Windows or SQL Server authenticationĬreate, edit and delete any objects ie.
