SQL Manager for SQL Server

Full support of SQL Server 2005
Full support of SQL Server 2005 permission system
Schemas, CLR objects, DDL triggers, synonyms, XML schema collections, partition schemes and functions, symmetric and asymmetric keys, certificates, endpoints support
XML indexes, included index columns, index creation and lock options
Maximum size for varchar, nvarchar, varbinary fields
Support of Unicode data

Rapid database management and navigation
Multiple host/database connections
Database properties management
Server properties management
Registering databases for working with the required databases only
Projects to work with the selected database objects only
Multiple user-defined tabs for any tree node to access it in one-click.
Working with multiple selected objects at a time
Grouping/ungrouping registered databases by host name

Easy management of all SQL Server objects
Creating/dropping databases and schemas
Managing tables and all their subobjects: fields, indices, triggers, checks and foreign keys
Managing views, procedures and user-defined functions
Managing user-defined types, synonyms, DDL triggers, assemblies, aggregates, XML schema collections, defaults and rules
Managing partition functions and schemes, full-text catalogs and indices, symmetric and asymmetric keys, certificates
Managing jobs, schedules, alerts, operators, endpoints, linked servers, credentials, proxies
Duplicating all database objects
Viewing dependencies between database objects

Advanced data manipulation tools
Powerful BLOB viewer/editor with several types of viewing BLOB data
Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
Master-detail view to work with two linked tables at the same time
Table and card views to see data the way you like
Support of queries returning multiple result sets
Ability to copy and paste selected records
Advanced printing system

Effective security management
Powerful login manager for administering server logins
Managing database users and user-defined roles
Managing server roles membership
Grant manager displaying all database object grants in the form of a grid
Viewing and changing object permissions to database roles in object editors

Excellent visual and text tools for query building
Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
Multiple SQL editors with code completion, syntax highlight and code folding
Large script executing (SQL script editor)
Ability to view actual and estimated query plan as diagram
SQL Formatter (Available from SQL Editor context menu)
Favorite Queries (Save and use your frequently used queries easily)

Impressive data export and import capabilities
Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.
Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
Bulk Insert wizard
Exporting data to SQL script as INSERT statement with selecting destination DBMS

Visual Database Designer to handle database structure in a few clicks
Creating diagram of existing database using Reverse engineering tool
Dividing diagram into different subject areas located on separate pages
Navigating through diagram using preview navigation to
Creating/editing/dropping tables and table fields, visually setting links between them
Ability to add comments to diagram
Saving as image or printing database diagram
Two diagram notations (IDEF1x and IE)
A lot of visual customization options

Easy-to-use wizards performing SQL Server administrative tasks
Backing up database
Restoring database
Attaching database
Detaching database
Shrinking database
Managing indices
Updating statistics
Checking database

Powerful tools to make your work with SQL Server as easy as it can be
Extracting metadata into text files or SQL script editor
Powerful print metadata module for creating customizable metadata reports
HTML report generator to create a detailed HTML report about your database quickly
Managing backup devices
Managing database snapshots
Viewing SQL Server logs
Monitoring SQL Server activity

New state-of-the-art graphical user interface
Office 11 and Windows XP visual schemes support
Well-described Wizard System
Improved database explorer for easy management of all SQL Server objects
MDI and floating-window styles implementation
Windows Toolbar to switch between windows easily, like in Windows Task Bar
Navigation bars with hot actions in most of the windows
Ability to save all program settings
Customizable toolbars for all program windows
Fully customizable program interface
Powerful visual options module
Localizable program interface

Report designer with clear in use report construction wizard
Create Report Wizard allows you to create simple reports in a few clicks
Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree

And other useful features
Keyboard templates
To-do list
External tool manager

Powerful and easy-to-use graphical user interface
Enlarge

Effective security management
Enlarge

Rapid database management and navigation
Enlarge

Powerful visual database designer
Enlarge

Easy management of all SQL Server objects
Enlarge

Efficient reports management
Enlarge

Impressive data export and import capabilities
Enlarge

Easy-to-use wizards for running SQL Server administrative tasks
Enlarge

Powerful tools to make your work with SQL Server as easy as it can be
Enlarge

Advanced data manipulation tools
Enlarge

Excellent visual and text tools for query building
Enlarge

And other useful features
Enlarge