EMS SQL Manager for SQL Server is a high performance tool for SQL Server development and administration. SQL Manager works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, CLR objects, DDL triggers, XML columns, endpoints and other. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Full support of SQL Server 2005
Support of Unicode data
Rapid database management and navigation
Easy management of all SQL Server objects
Advanced data manipulation tools
Effective security management
Excellent visual and text tools for query building
Impressive data export and import capabilities
Visual Database Designer to handle database structure in a few clicks
Easy-to-use wizards performing SQL Server administrative tasks
Powerful tools to make your work with SQL Server as easy as it can be
Report designer with clear in use report construction wizard
New state-of-the-art graphical user interface
300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
64 MB RAM or more; 128 MB or more recommended
50MB of available HD space for program installation
Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
Microsoft Mouse or compatible pointing device
Microsoft Data Access Components (MDAC) or SQL Server Native Client
Local or remote SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005 (We do not support SQL Server 2005 Compact Edition)
What's new in SQL Manager for SQL Server 3.1?
Implemented support of server objects in Extract Database, Print Metadata, Duplicate Object, New Object, SQL Script Explorer tools.
Grant Manager. It is now possible to view effective permissions on objects.
SQL query editors.
>>A number of functions now work faster.
>>Fixed several bugs connected with the occurring of List index out of bounds and Access Violation errors, as well as bugs concerning the cases of incorrect recognition of table aliases in queries, the incorrect work of code folding and non-applicability of background color.
>>Keyboard templates do not trigger in comments any more.
Database Registration Info. Added the 'Always use client cursor to get data' option; this option should be enabled for remote server connections, e.g. upon connection via Internet.
Print Metadata. The possibility to interrupt report generation is added.
>>Sub-levels based on a SQL query can now be edited in the Load All Rows mode, if the query is built by one table and contains key fields.
>>When inserting text into a grid cell, pressing Shift+Ins resulted in duplicating field dialog. Fixed now.
View Editor. The possibility of editing queries in Query Builder is added.
Job Editor. Added commands for running tasks, stopping task execution, viewing task execution results.
Indices Management. Now it is possible to select several indexes and set parameters for all of them simultaneously.
>>Unicode was not supported upon inputting parameters in queries containing parameters' declaration. Fixed now.
>>When working with several instances of SQL Editor, Favorite queries were not always saved correctly. Fixed now.
>>In some cases after server connection was lost, no attempt to reconnect was made.
When duplicating full-text catalogs, an error message appeared telling that the query could not be executed inside a transaction. Fixed.
SQL Script. The 'Cannot create file' error used to occur on attempt to save the editor content to a file. Fixed.
Extract Database. After the extraction of the database the CREATE DATABASE statement in the resulted script did not contain operators for creating files and file groups. Fixed.
Server Log Viewer. When opening a log, the 'Field Date is not found' error occurred in some cases. Fixed now.
Restore Database wizard. When saving master options to a template, in some cases database file names were not written into the template. Fixed now.
Keyboard Templates. When using the Paste command in a template body, applying the template resulted in insertion of the first word only, instead of the insertion of entire text from the clipboard. Fixed now.
Dependency Tree. If the tree building was interrupted, rebuilding was not initiated after subsequent selection of an object. Fixed now.
Other minor improvements and bug fixes.