- Connect
to server using Windows or SQL Server authentication
- Access
to local and remote MSDE servers
- Advanced
T-SQL editor with syntax highlighting, multi-level undo/redo, text search/replace,
whitespaces view, text indent/unindent
- Create
and maintain any server objects ie. database, table, index etc. by executing
SQL commands
- Create,
edit and compile stored procedures, views and functions
- Generate
objects scripts
- Quick
data edit and search
- Execute
SQL commands
- Multi-tabbed
and multi-threaded MDI environment
- Customise
environment options
- Export
data to character-delimited files, HTML or XML files
- Search
database objects and source code
- Manage
SQL Server agent
- Monitor
server activities: processes, locks and jobs
- Users
and roles administration: create, edit and delete
- Manage
several SQL servers simultaneously
- Manage
server authentication
- Manage
server security: logins, users and roles
- Filter
system and user objects in the server manager
- Manage
object's permissions: databases, users, roles, tables, views, stored
procedures and user-defined functions
- View SQL
server log files
- Create
and edit database in the database editor
- Attach
and detach databases
- Create
and edit table in the table designer
- Quick
script view for all database objects in the Server Manager
- Export
data to the clipboard
- SQL assistant
for quicker SQL coding - Intellisense like feature providing list of
the tables/views and columns name and data type while typing SQL command
- Objects
browser for easier T-SQL development
- Enhanced
SQL Command Console with command batch or single SQL command execution
and server messages processing
- Server
processes management
- Database
backup/restore/shrink
- Primary
key and index management
- Data import
|