EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Product News

04/24/2006
SQL Manager 2005 for SQL Server ver. 2.3 released

We are pleased to announce new version of SQL Manager 2005 for SQL Server. You can download the newest version from the download page.

What's new in SQL Manager 2005 for SQL Server version 2.3?

  1. Editor Options. Key Mapping tab added which allows you to set the shortcuts for SQL editors.
  2. XML Schema collections support is implemented.
  3. Query Builder.
    • Query execution plan is now displayed as a graphical diagram.
    • Queries containing user-defined functiouns now supported.
  4. Dependency Tree. The diagram can now be printed.
  5. SQL Editor.
    • Now it's possible to rename and move query tabs.
    • Ability to execute statement under cursor added.
    • Query execution time is now displayed in hh:mm:ss format.
    • The timer in status bar area used to stay running on after aborting query execution.
  6. SQL editors.
    • Now you can set a source code fragment as a comment with a single click.
    • Next Bookmark, Previous Bookmark context menu items added.
    • With 'Trim trailing spaces' option on, an attempt to use Code Complete used to clear all the line. Fixed now.
    • Dragging the field names from SQL Assistant works perfectly now.
  7. When opening Grant Manager window it was impossible to edit statement permissions without forced refresh. Fixed now.
  8. HTML Report.
    • Now you can include user and role information into a report.
    • Ability to change header/footer of the report added.
  9. Extract Database.
    • The option adding the 'create database' statement to the script appeared.
    • Server version is included into comments for the script now.
  10. Environment Options. Now it's possible to set refreshing objects timeout. Refresh of the objects can be terminated after timeout expired if there is an active transaction that made any changes to metadata.
  11. Open/save backup file dialogs now look more like standard ones in behaviour.
  12. Import Data wizard.
    • With 'Use transactions...' option disnabled now in 'Commit changes manually' mode you will be prompted for an action on transaction.
    • Ability to resize wizard window added.
    • 'Division by zero' error used to appear after importing data with the 'Commit changes manually' option switched on. Fixed now.
    • Having specified user-defined fields to import, the rest of them were filled with empty strings; so that default values defined for the fields were not applied. Fixed now.
  13. Trigger Editor. When altering a trigger schema/owner's name wasn't added to the trigger name in the script generated, that in some cases raised errors. Fixed now.
  14. Foreign key/check constraint editors. 'Not for replication' option added.
  15. Visual Database Designer.
    • It was impossible to drop table via corresponding context menu item when just a field, not the table itself, was selected. Fixed now.
    • When dragging a table not from default schema (SQL Server 2005) from DB Explorer to the Query Builder working area an error used to appear and the table was not added. Fixed now.
  16. Grid.
    • The 'Paste Cell' menu item didn't work in Lite version. Fixed now.
    • In some rare cases the data of of bigint-typed fields were displayed improperly. Fixed now.
    • With 'Column auto-width' option enabled BLOB field columns used to become too wide. Fixed now.
  17. SQL Script. Confirmation of abort script execution added.
  18. Restore Database.
    • It was impossible to type in backup file name in corresponding window. Fixed now.
    • Prompt for registration the database used to appear even if restoration was unsuccessful. Fixed now.
  19. Job Editor. Fixed the bug with a wrong script generation when you saved the job in which the created schedule was deleted.
  20. DB Explorer,
    • It was unable to open index or trigger via Recent Objects menu. Fixed now.
    • Popup menu used to stay on top when switching between applications. Fixed now.
    • After table duplication the indices and triggers of the new table were not displayed in DB Tree. Fixed now.
  21. Export Data wizard.
    • With 'Export empty tables' option disabled on attempt to export an empty table there raised an error containng no text. Fixed now.
    • In some cases, when exporting data to MS Excel format the 'Data format \ Styles' options used to work incorrectly. Fixed now.
    • When exporting data to MS Excel format the user-adjusted Boolean True format used to be ignored. Fixed now.
  22. Detach Database. Having used 'Clear connections' function, the database was still displayed in DB Tree and further attempts to access its objects returned errors. Fixed now.
  23. Many other other small improvements and bugfixes.

We hope you'll enjoy our products.

twitterfacebook