EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

SQL Server Products News

SQL Manager for SQL Server version 3.5 released

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

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

  1. Database Properties. The Transparent data encryption option is now available when working with SQL Server 2008.
  2. The Jobs form now opens faster.
  3. SQL editors.
    • Added the possibility to load the file contents into SQL Editor by dragging the file from the Windows Explorer into the editor’s area.
    • The file encoding selected in the Open/Save file dialog is saved and then used when opening/saving files next time.
    • When using comments like /** ... **/, the text after the block was highlighted like comments. Fixed now.
  4. SQL Editor.
    • If a file name and location were too long for the window title the utility used to cut the filename. Now it cuts the file location.
    • XML fields values were sometimes not displayed when connecting through the Native Client. Fixed now.
    • If the last line of the executed query contained comments, the query did not return record set. Fixed now.
    • The Ctrl+D shortcut is added for the Show Results on Edit Tab command.
    • With the certain option combination set, all queries resulted in “0 records fetched”. Fixed now.
  5. SQL Script. If a file name and location were too long for the window title the utility used to cut the filename. Now it cuts the file location.
  6. Now it is possible to connect to a database if the user does not have the necessary rights to obtain the collation list.
  7. Duplicate Object Wizard. Now it is possible to change the form size.
  8. Key mapping. The confirmation dialog is now displayed on deleting a scheme and key combinations.
  9. Extract Database.
    • Added the possibility to extract system objects.
    • The certificate dependency on users by the Authorization property is taken into account when a script is generated.
  10. Certificates Editor. The Start Date and End Date parameters now include the drop-down calendar to choose the date.
  11. Activity Monitor. Sometimes the “Overflow while converting variant of type (Int64) into type (Integer)” error occurred when opening a form for SQL Server 2008. Fixed now.
  12. Data View. Due to the Windows Vista error the grid size did not change when enlarging the form size. Fixed now.
  13. Query Builder. An error occurred during the reverse engineering of a query where object names were quoted. Fixed now.
  14. Procedure Editor. After executing a procedure which returned a record set, the Ctrl+Ins and Shift+Ins shortcuts stopped working on the procedure text editor’s tab. Fixed now.
  15. UDF Editor. When launching UDF, its name was not quoted – an error occurred if the name included invalid characters. Fixed now.
  16. Export Data, Export as SQL Script. When working with queries returning several record sets, it is now possible to export the second and the following record sets.
  17. Login Editor.
    • An error occurred when revoking permissions for a database. Fixed now.
    • Now it is possible to create a login with a blank password.
  18. It was not possible to open the editor for an object if its name looked like ‘text (text)’. Fixed now.
  19. Table Editor. If non-English localization was used in the program, the “Floating point division by zero” error occurred when switching to the Dependencies tab. Fixed now.
  20. Field Editor. If the default object was bound to the field, an error occurred on saving – a wrong script was generated. Fixed now.
  21. Index Editor. The Partitioning column list was not filled after choosing the partition schema as an index data space. Fixed now.
  22. Export as SQL Script. The values of numeric fields with a large precision were displayed as nvarchar values. Fixed now.
  23. It was not possible to open the Job Editor if the connection to a database with the case sensitive collation was established. Fixed now.
  24. Other minor improvements and bug-fixes.

We hope you’ll enjoy working with our software.