Database Utility provides SQL Server administration.

Press Release Summary:



Supporting SQL Server 2008, SQL Manager for SQL Server v3.4 enables use of macro in SQL Editor and SQL Script. Unicode support is implemented in procedure/function bodies, views, triggers, check constraints, object description, and field default values. Users can execute procedures and user-defined functions directly from DB Explorer. Usage of separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing ability to use other functions.



Original Press Release:



The New Version of EMS SQL Manager for SQL Server Released



SQL Manager for SQL Server released

We are pleased to announce the new minor version of SQL Manager for SQL Server - a high performance tool for SQL Server database administration and development.
You can download EMS SQL Manager for SQL Server from the following link:
http://www.sqlmanager.net/products/mssql/manager/download

What's new in SQL Manager for SQL Server 3.4?

The following SQL Server 2008 feature is now supported:

Resource Governor.

Support of 'FOR XML' clause in queries used to return results as XML instead of standard rowsets.

Using macro is now possible in SQL Editor and SQL Script.

Data View | Blob View: the XML tab has been added allowing to view XML data as a tree.

The Unicode support is implemented in procedure/function bodies, views, triggers, check constraints, object description, field default values and in a number of other object properties.

Grant Manager:

Support of database permissions for SQL Server 2005 and higher has been added.
Users and roles are now separated in the 'Privileges for' list.

Database Registration Info:

The values specified on the Grid | Data Options page will be applied as default settings for newly registered databases.

A possibility to select the OLE DB Provider: OLE DB Provider for SQL Server or SQL Native Client has been added.

Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.

DB Explorer:

The Find Object dialog has been improved.

The possibility to execute procedures and user-defined functions directly from DB Explorer (through the context menu) has been added.

The button for switching search mode has been added to the Search Panel toolbar.

Double-clicking an object group node folds and unfolds its branch.

Extract Database:

Now the script is directly generated in the selected charset, which reduces the script generation time.

Export as SQL Script: now the script is directly generated in the selected charset, which reduces the script generation time.

Visual Database Designer:

Tables are arranged more compactly in the reverse engineering mode.

Data Grid: the method of work in asynchronous mode is changed - the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program.

Job Step Editor: support of the 'Write log to table' option and new subsystems of SQL Server 2008 have been added.

Other minor improvements and bug-fixes.

We hope you'll enjoy working with our software.

More from Material Processing

All Topics