Online Documentation for SQL Manager for SQL server

Version history

 

Full version history is available at http://www.sqlmanager.net/products/mssql/manager/news

 

Version 5.1.1

1. Custom format mask is now applied correctly to DATE type for CAST operator.

2. Script for updating dependent views on table update is now generated with correct schema value.

3. The popup list is closed instead of the dialog with ECS in Find or replace editor.

4. Services. The issue of connecting to the databases with Unicode names has been resolved.

5. GEOGRAPHY computed values are not updated on table editing now.

6. Empty toolbars are no longer displayed after program update.

7. Some other fixes and minor improvements.

 

Version 5.1

1. Compatibility level for SQL Server 2022 added.

2. Connection issues fixed for Azure Managed Instance.

3. Increased performance for Dependency Tree.

4. Dependencies tree fixed for XML Schema Collections.

5. Improved work with BLOB editor.

6. Wizard templates are now saved in UTF8.

7. Scaling improved in DB Designer editor.

8. The issue with displaying Unicode parameters in tables fixed.

9. The new scheme name was missing in Duplicate wizard in some cases. Fixed now.

10. Commit after all records is now set by default in Import data wizard.

11. Unicode strings in DB properties are now processed correctly.

12. Selected data is not reset on moving between steps in Statistics Update and Indices Management Wizards.

13. Incorrect applying of On All group actions on Permissions tab in object editors fixed.

14. Many other fixes and improvements.

 

Version 5.0.6

1. Added option to connect to the server without checking its certificate.

2. The ability to rebuild views has been added.

3. The ability to rebuild metadata of dependent views after making significant changes in table fields added.

4. Fixed errors when importing data from some XML files.

5. XML data was not filled in correctly for Path in Data import wizard. Fixed now.

6. Dependent objects were incorrectly displayed in the Dependency Tree for role synonyms. Fixed now.

7. Other changes and improvements.

 

 

Version 5.0.5

1. Editor tabs can be now highlighted with the specific DB color.

2. Improved processing of dependencies in large databases.

3. Incorrect copying of Null cells from tables grid fixed.

4. Field name was modified in Duplicate table wizard if it was the same as table name. Fixed now.

5. Seed property for identity fields was set to 0 instead of 1. Fixed now.

6. BIGINT data types are now exported correctly into XLS and XLSX fils.

7. Other minor fixes and improvements.

 

Version 5.0.4

1. Support for compatibility level 15 added.

2. Custom toolbars are no longer removed.

3. Query plan resulted in error on second execution in Query Builder. Fixed now.

4. Memory-optimized table parameters are displayed correctly now.

5. Minor fixes and interface improvements.

 

Version 5.0.3

1. Desktop was not restored correctly if server name contained non-Latin characters. Fixed now.

2. 'List index out of bounds' error occured on filtration if connection was lost. Fixed now.

3. The main menu disappeared with some specific localizations used. Fixed now.

4. Default values are now set correctly on client side.

5. Deafult names for tables didn't apply current schema. Fixed now.

6. Confirmation was added for closing all editors.

7. 'Invalid variant type' error on editing datetime2 data in SQL Azure fixed.

8. Now the number of fetched records is displayed right in Load visible rows mode.

9. Other minor fixes.

 

 

Version 5.0.2

1. The error occured on editing data in Hungarian locale. Fixed now.

2. DATA_COMPRESSION option was not generated correctly. Fixed now.

3. Path to the recent file is now saved in Restore database wizard.

4. Notifications are now displayed if Debugger cannot be started due to privilegies restriction.

5. Key mapping didn't work correctly for displaying some objects. Fixed now.

6. SQL Assistant. Data was not displyed for newly created objects. Fixed now.

7. Quotes are now correctly applied to objects on duplication.

8. Code was not formatted correctly with nested WHEN conditions. Fixed now.

9. Now the error line is shown correctly when code starts with comment.

10. The body of the procedure created on assembly was not displayed. Fixed now.

11. SQL Script. The editor froze on execution after file drag-and-drop. Fixed now.

12. Export of settings to the restricted folder doesn't fail with the Access Violation error now.

13. Other minor fixes.

 

Version 5.0.1

1. Tabs couldn't be reordered. Fixed now.

2. The 'Access Violation' error occasionally occured on toolbar customization. Fixed now.

3. Display of sql_variant data has been fixed.

4. Incorrect refresh of tables in SQL Server 2000 has been fixed.

5. Columns autofit didn't always work correctly. Fixed now.

6. The error on compiling stored procedure has been fixed.

7. The object was not focused in the collapsed node on Ctrl+O use.

8. The variable color has been changed for the dark color schema.

9. Fragmentation data was not displayed for indices. Fixed now.

10. Many other improvements and bugfixes.

 

Version 5.0

1.

 

 

2. Added new objects of SQL Server 2017, Azure SQL and Azure Datawarehouse:

• External table
• DB Scoped Credential
• External file format
• Graph table

3. Support for Amazon RDS for SQL Server implemented.

4. MS OLE DB provider for connecting to SQL Server has been updated.

5. Unicode object names are supported now.

6. Improved support of high-DPI monitors and large-scale fonts added.

7. Objects can be now added to the Favorites node from the popup menu.

8. Encryption algorithms for symmetric and asymmetric keys have been updated.

9. Now it's possible to view object creation and modification date.

10. Code completion has been improved.

11. Format set in Color & Formats was not applied. Fixed now.

12. Many other improvements and bug-fixes.

 

      Version 4.4.1

1. Data frame. Implemented the ability to add values to the current filter instead of replacing them by using the Shift button.
2. TSQL Debugger. Debugging large procedures has been improved and optimized.
3. Data frame. When adding a new row empty strings were displayed instead of default values. Fixed now.
4. SQL Editor. Query execution failed when NULL-value was set as a string-parameter. Fixed now.
5. Objects at the Dependencies tab sometimes were added as new nodes instead of adding inside the right nodes. Fixed now.
6. Query Builder. Arrow direction was incorrect for the LEFT OUTER JOIN relationship. Fixed now.
7. Query Builder. The field moved outside list visible area and there was no possibility to scroll the list. Fixed now.
8. An object was not focused using Ctrl+O shortcut when it was out of visible range. Fixed now.
9. The ‘Online’ field option was incorrectly set by default. Now it is available for the Enterprise edition of SQL Server only.
10. Now it is possible to sort and filter data rows returned by a stored procedure.
11. The error occurred when launching the program on OS with Breton locale.
12. Confirmation window appeared twice on exit the program. Fixed now.
13. Table name disappeared in its sub-objects editors in some cases. Fixed now.
14. Data frame. If data was shorter than column header column width was set incorrectly. Fixed now.
15. Fixed errors of highlighting and execution code with nested comments.
16. There was an error opening table indices after changing this table fields order. Fixed now.
17. Many other improvements and bugfixes.

 

 Version 4.4

1. Support of Azure SQL Database v12 new features.
2. Added the ability to browse binary data in Debugger as text or hexadecimal value.
3. The ability to encrypt objects with context menu.
4. It is possible to change field order in Index more efficiently now.
5. It is possible to select several table fields for reordering now.
6. It was not possible to distinguish NULL-values from empty strings in Debugger watches list. Fixed now.
7. The cursor moved to the end of SQL-text on formatting. Fixed now.
8. 'The style 121 is not supported for conversions from varbinary to nvarchar' error occurred on opening partition function based on binary types. Fixed now.
9. The field list of alias was displayed incorrectly when the same alias was used in several queries. Fixed now.
10. The script was not generated on reordering Index fields. Fixed now.
11. The charset was always reset to default on each saving of the object DDL. Fixed now.

 

 

 Version 4.3

1. Support for new features of SQL Server 2016 has been added.

   - Truncate table partition has been added.

   - Added support for altering columns with ONLINE option ON.

   - ‘Maximum degree of parallelism’ option has been added in Check database wizard.

   - Support for DROP IF EXISTS statement in Extract database wizard.

2. The possibility to browse PDF has been implemented in BLOB Editor.

3. The algorithm for Code Completion list has been improved.

4. Now information messages and errors in the dialogs can be copied with Ctrl+C.

5. Applying of Schema-organized database tree option is performed without reconnect now.

6. SQL Editor. The results of the query without key fields couldn’t be edited. Fixed now.

7. Now you can drag-and-drop triggers to set breakpoints in Debugger.

8. ‘Out of memory’ error has been fixed in Extract database wizard.

9. The query executing couldn’t be cancelled in ‘Open server cursor’ and ‘Asynchronous query’ execution modes. Fixed now.

10. The error on loading VARBINARY data has been fixed.

11. The tables containing ‘Space’ symbol were processed incorrectly in Query Builder. Fixed now.

12. Drop\Create statements were generated in Index Editor even if no changes were made. Fixed now.

13. Code Completion list didn’t appear for functions and procedures with database name added. Fixed now.

14. Many other fixes and improvements.

 

 

  Version 4.2.2

1. Some performance issues have been resolved: slow connection and services launch on some specific client configurations.

2. Data Frame. Cells were filled with empty strings instead of default values when a new row was added. Fixed now.

3. Defaults and computed fields definitions were truncated in table DDL. Fixed now.

4. Data Frame. Incorrect sorting and filtering has been fixed for the case when data was loaded partially.

5. Favourite Queries were not shown when ODBC connection was used. Fixed now.

6. The procedures were executed twice in Procedure Editor. Fixed now.

7. Many other improvements and bug-fixes.

 

 Version 4.2

1. ODBC driver support has been implemented to ensure best compatibility with all server versions.

2. Support of privileges for Routes, Message Types, Services, Service Bindings and Queues has been added.

3. Support of new Full-text Indices properties has been added.

4. Corresponding Registry settings are cleaned up on unregistering the database.

5. The error on applying Quick Filter for Decimal fields has been fixed.

6. Ctrl+O hot key added for focusing the currently edited object in the DB Explorer tree.

7. Object editors can be opened from Grant Manager by double-clicking now.

8. Other improvements and bug-fixes.

 

 

 Version 4.1.1

1. The 'DROP' statements were not generated while synchronizing databases. Fixed now.
2. The 'Code Completion' windows did not appear for the INSERTED and DELETED keywords. Fixed now.
3. Sometimes the values of BIGINT type were displayed incorrectly. Fixed now.
4. The 'Floating point: division by zero' error occurred when the FLOAT-typed values were edited. Fixed now.
5. Some fixes of synchronization of views.
6. Lots of other improvements and bug-fixes.

 

 

 Version 4.1

1. Support of Azure SQL Database.
2. Now when modifying an object, a window is marked with an asterisk (*) in the Windows Bar. The same is for files opened in SQL Script form, Visual Database Designer diagrams, etc.
3. DB Explorer.
4. • Type of field and nullability are now displayed in DB Explorer tree.
   • Favourite queries and scripts may be added into Favourite Objects folders.
4. Data Grid. Now it has become possible to select several cells and copy them to clipboard. To do this it is necessary to switch on the 'Cell selection' and 'Row/cell multi-selection' options on Grid tab of the Environment Options dialog.
5. Dependency Tree, Dependency tab in object editors. Now dependencies on external and dropped objects are shown (for SQL Server 2008 and higher).
6. Export Data as SQL Script, Extract Database. Now in the field 'Script destination | File charset' the last charset saved is chosen.
7. Restore Database wizard. Now the name of the restoring database is displayed in the form header.
8. DDL Trigger Editor, Server Trigger Editor. Events are sorted in alphabetic order.
9. SQL Monitor. Now parameter values, used at query/procedure run, are also displayed in the log.
10. Data Grid.
11. • If the fractional seconds precision of the time value in the field datetime2 exceeded three signs after decimal point, there used to arise an error at data opening. It is fixed now.
    • Default values for datetime types were displayed wrong when adding a new entry. It is fixed now.
    • Big values of bigint type used to be displayed in scientific notation. It is fixed now.
    • Data of the tinyint field was not sorted in the 'Load Visible Rows' grid mode. Fixed now.
11. Login Editor. Refresh didn’t work in the User Mapping tab. Fixed now.
12. SQL Editor. If you execute the query, and then disable the 'Show Actual Execution Plan' option, odd record set would display in the results for subsequent queries. Fixed now.
13. Attach Database, Detach Database wizards. Some passwords were encoded wrong on saving the template. Fixed now.
14. DB Explorer. If you enable the 'Sort by aliases' option table fields were sorted as well. Fixed now.
15. At opening the Database Properties dialog for the disconnected database, the value of the database owner was not displayed. Fixed now.
16. SQL Script. At saving the script was scrolled up to the beginning. Fixed now.
17. A lot of other small improvements and bug fixes.

 

 

 Version 4.0

1. The ability to debug Transact-SQL code is now implemented in SQL Editor. The debugger makes it possible to find errors in SQL scripts, stored procedures, user-defined functions by observing their run-time behaviour. It is possible to trace into bodies of stored procedures and functions, see the value of local and global variables, set the breakpoints, etc.
2. Added the Database Comparer tool which allows getting a script to synchronize the database structure.
3. Added support of new SQL Server 2014 features:
4. • Support of memory-optimized tables.
   • Support of backup encryption.
   • Support of backup to Windows Azure.
4. The Search in Metadata tool is implemented for performing the quick search within the scope of database metadata. The tool allows you to set various search conditions and view the results.
5. Added the ability to create SELECT/INSERT/UPDATE/DELETE procedures from tables and views easily.
6. Visual Database Designer.
7. • Added the Undo and Redo commands.
   • Added tools for visual formatting diagram objects: setting fonts, colors, etc.
   • Now views, procedures and functions can be added to a diagram.
   • Added the possibility to display attribute properties (optionality, keys, etc.) in parentheses after the attribute name and type.
   • Diagram print options are now saved in the diagram file.
   • Added the possibility to display printing page borders on a diagram.
   • Added the possibility to drag and drop schemas to a diagram.
7. DB Explorer.
8. • The database tree now contains Scripts branch for fast access to SQL files from a specified folder (set in Database Registration Info dialog) and its subfolders.
   • Added the ability to duplicate objects to other databases by using drag-and-drop.
   • Restore of previously opened object editors when connecting to database is carried out more quickly as far as majority of repeated requests to server are excluded.
8. HTML Report.
9. • Now it is possible to define report visual style.
   • Triggers, indices, foreign keys, check constrains are now displayed in a separate general list.
   • Now it is not necessary to connect to database to create a report for server objects only.
9. Added the Instance Manager tool which allows checking statuses of SQL Server services and starting/stopping them.
10. Added the Database Registration Manager which allows adding and deleting database registrations quickly.
11. New Object Templates window allows you to preset property values for newly created objects: fields, indices, triggers, views, procedures, functions. Also it is possible to define name template for new database and server objects.
12. Environment Options.
13. • Added the possibility to define shortcuts for some commands in DB Explorer, SQL Editor, SQL Script and other tools (Global Shortcuts).
    • Now it is possible to specify the display style of object names as schema.name or name (schema).
    • It is possible to set the font for data grid separately.
    • Added the possibility to specify which database should be selected for a newly opened editor or tool: the database selected in DB Explorer or the one from the currently focused editor.
13. Dependency Tree.
14. • Added the possibility to move the tree within the display area by holding the left mouse button.
    • Changed the drawing of selected object and recursive objects for better distinction.
    • Added different display modes of dependency tree: to show all objects, to show objects depending on selected object, or only objects selected object depends on.
    • Selected object is placed to the display area automatically now when the dependency tree is too large.
14. Windows panel.
15. • Switch between windows is now possible with Ctrl+Tab shortcut.
    • Added the ability to move tabs of open windows with a mouse.
    • Now it is possible to close the windows with the scroll button.
15. Table Editor. Data tab.
16. • Added the possibility to create automatically the detail data levels for tables connected with the given one by means of foreign keys.
    • Values of geometry and geography types are now displayed as a text. Now it is possible to edit them.
16. Object names in DDL are not quoted now, if it is not necessary.
17. Export/Import Data. Now in most cases exported data is not re-requested from server.
18. Procedure and Function Editors. It is possible to set use of default parameter values when executing procedures/functions.
19. SQL Formatter now allows formatting DDL statements.
20. SQL Editor. Now the query execution time is displayed more accurately with no additional cost in the program itself.
21. Indices Management, Update Statistics, Shrink Database and Check Database wizards are non-modal now; operation is executed in a thread.
22. Visual Options. Added the possibility to set Slants Kind property value for page controls.
23. SQL Editor, Procedure Editor. The query execution process is completely revised: repeated query executions to display forward-only cursor results or to get info messages are excluded.
24. Some of the forms were not scaled in Control Panel\Display | Size of All Items - Medium mode. Fixed now.
25. Lots of other improvements and bug-fixes.

 

 

 Version 3.9.0.1

• The possibility to record object definitions to files for further use with version control systems (menu Tools | DDL to Files).
• SQL Editor. Quick Code.

• The list of table fields of current SELECT query is now shown at 'Code Completion' even without indicating table alias.
• Context sensitive elements: table aliases of the current SQL query, local variables, query table fields now are arranged at 'Code Completion' at the top of the list.
• The support of table-valued user-defined functions to get the field list in 'Code Completion' was added.
• It is possible to choose the value in 'Code Completion' with the spacebar (option in Options | Editor Options | Display | Quick Code).
• Code Parameters did not work if the user-defined function name was quoted. Fixed now.

• Duplicate Object wizard. When duplicating the table to database at the same server, the copying is made with SQL statement INSERT FROM … SELECT. But when duplicating to the other server the data copy statements are not recorded to the main script, and are fulfilled separately that requires less memory.

• Check Constraint Editor. Now the property setting "Check existing data" is taken from the system catalogue, and is included to constraint definitions.
• SQL Editor. For convenience the query execution timing information is drawn at the same status bar as the number of returned records is.
• Activity Monitor. The filter is not reset with clicking Refresh.
• Job History. The time values are now formatted for more convenient comparison.
• Jobs. When opening the form the data were not refreshed: at times only the names of jobs were shown, and all the rest information was blank. Fixed now.
• New Table form. The right-click menu was not opened for field list. Fixed now.
• DDL Trigger Editor. After compiling the disabled trigger was enabled. Fixed now.
• UDT Editor. When saving changes of table type constraints the incorrect script was at times generated. Fixed now.
• Save Settings wizard. The database projects for servers with the named instances were not saved. Fixed now.
• Environment Options. Naming Rules. The value of index type tag for XML indexes was not saved. Fixed now.
• Select Object dialog. At Users section the roles were shown, and at Roles - the users. Fixed now.
• Credential Editor. If fields 'Password' and 'Confirm password' contained distinct values, two error messages appeared when compiling. Fixed now.
• Environment Options dialog. For Tools | Object Editors tab the wrong Help page was opened. Fixed now.
• Lots of other improvements and bug-fixes.

 

 

 Version 3.8.0.1

• Added support of new SQL Server 2012 features:

• Support of sequences.
• Support of custom server roles.
• Support of columnstore indices.
• Support of FileTables.
• Support of contained databases.

• Added support of spatial indices (SQL Server 2008 and higher).
• Login Editor. Added the possibility to set up permissions on logins and server roles.
• Role Editor.

• Added the possibility to rename the role and define its description (SQL Server 2005 and higher).
• Now when editing the application role, the following fields are available: "Confirm Password" and "Default Schema".
• The definition is now displayed as CREATE ROLE statement and the modification script as ALTER ROLE (SQL Server 2005 and higher).

• DB Explorer. Now when pressing "Left", first the subnodes of the current node are collapsed, after pressing again the parent node is focused.
• Database Registration Info. OLE DB Provider. Added ability to select SQL Native Client 2008 to connect to the server. Also added the "Default" option, which allows connecting by the client corresponding to the Server version.
• BLOB view. Added the support of PNG images.
• Table DDL. Added the "Show collation in table DDL only if it is different from database collation" option (Tools tab of the Environment Options dialog)
• Database Properties. Added the ability to modify the following database options: Non-transactional access to FILESTREAM data, Directory name for FileTable data, Containment (all up to SQL Server 2012).
• Server Properties. Added the ability to modify the following server options: Filestream access level (SQL Server 2008 and higher), Database containment (SQL Server 2012), Compressed backups by default (SQL Server 2008 and higher), Max number of locks, Query wait.
• Editor Options. Quick Code. Now when pressing the space bar, the Code Completion list can be closed with the selected item input.
• Dependencies tab. Before displaying the dependencies of procedures, functions, and views, the dependencies on the server are refreshed by the sp_refreshsqlmodule procedure.
• Table Editor.

• Now it is possible to set FileTable options when creating and deleting tables.
• Data tab. After refreshing the corresponding button in the DB Navigator, the current record is not changed.

• Added the "Download User's Manuals and Languages" item to the Help menu.
• Now the Help file is opened in the selected language of the program.
• Query Builder.

• Queries, having a statement in the parsing join condition, gave an error.
• When calling the "Create View" option, the changes made in the Edit tab were not displayed in the view definition. Fixed now.

• View Editor. When changing an indexed view which contained multiple indices, the index creation order in the generated script could be incorrect. Fixed now.
• When creating an SQL login, the "Enforce password policy" option value was not saved. Fixed now.
• If the directory name required quoting while rebuilding the full-text directory, an error occurred. Fixed now.
• Foreign Key Editor. If the foreign key name was automatically created by the server, saving the changes caused the "The foreign key is not found in the database" error. Fixed now.
• SQL Editor. When executing the SELECT query using the SQL Native Client, if there was a single-line comment before the WHERE clause, the empty data set was returned. Fixed now.
• UDT Editor. The negative and very large positive values were allowed to be input ​​in the "Size/precision" and "Scale" fields. Fixed now.
• Some other improvements and bugfixes.

 

 

 Version 3.7.0.1

• Added the support of ANSI_NULLS and QUOTED_IDENTIFIER options for procedures, functions, views, table triggers, database triggers и server triggers.
• Aggregate Editor. Added the possibility to create/edit aggregates with several parameters (SQL Server 2008).
• Full-Text Catalog Editor. Added the possibility to create full-text indexes for the indexed views.
• DB Explorer.

Now searching with the toolbar "Search" is possible by both expanded and collapsed tree nodes.

In the script generated by the 'Script to ...' command, the declarations of variables for the return value and output parameters are added to the stored procedure.

• Editor Options. The maximum value for the "Right margin position" field is increased.
• SQL Editor.

Some national characters could not be displayed. Fixed now.

After making a replacement using the "Replace Text" dialog, in some cases it was not possible to close the end of operation message. Fixed now.

In SQL Server 2000 when opening the "Code Completion" option for the text '<database name>.<schema name>.', the "Invalid object name 'sys.schemas'" error occurred. Fixed now.

• Data View.

In some cases the presence of sublevels caused the "The component with name ... already exists." error. Fixed now.

Some national characters were not displayed in the "Find" field. Fixed now.

If there was a national character in the column header, the data in this column were displayed as null. Fixed now.

If the active view is a sublevel, changing the "Record Limit" value caused AV error. Fixed now.

• Server Roles. Opening the form greatly increased CPU usage of the program. Fixed now.
• Export/Import Data. In some cases when importing/ exporting data to/from the xlsx and docx files in Windows 7, an error occurred. Fixed now.
• Export Data as SQL Script. Now when creating an SQL script for SQL Server, the constraint definitions of the table are added to the result script in table DDL.
• UDF Editor.
  The table type parameters were not displayed on the Parameters tab. Fixed now.
  The size of the function return value was not displayed in DDL. Fixed now.
• Procedure Editor. The parameter default values were not displayed for SQL procedures on the Parameters tab. Fixed now.
• If the default object was assigned to the table field, the table scheme was not specified in the EXEC sp_bindefault command in table DDL. Fixed now.
• Server Properties. If opening the form caused an error, AV error occurred instead of the error message. Fixed now.
• Queue Editor. When editing/deleting a queue, generated in the non-current scheme, the scheme name was not added to the script and an error occurred. Fixed now.
• Field Editor. It was not possible to set "precision 0" for the TIME type (SQL Server 2008). Fixed now.
• Duplicate Object Wizard. When duplicating a value ​​to another scheme, in some cases the scheme name was not substituted in the script. Fixed now.
• Aggregate Editor. If a parameter or a return type of the aggregate was UDT, when opening this aggregate, the corresponding field in the editor was empty. Fixed now.
• If during the disconnection from the database the request to save data in any open form of the program is occurred, clicking the Cancel button caused the AV error. Fixed now.;
• If the current Windows locale uses a multi byte encoding (e.g. Chinese), when using national characters in the object names, the name was truncated on saving the object. Fixed now.
• Some other improvements and bugfixes.

 

 

 Version 3.6.0.1

• SQL Editor.

Now the number of affected records is displayed for each batch statement.

If a query returns multiple recordsets, the number of records is now displayed for every recordset.

Data of FOR XML queries were displayed incorrectly if the data were presented as elements. Fixed now.

Labels in the procedures were considered as parameters during execution. Fixed now.

For certain types of queries returning multiple recordsets, the export of the second and subsequent recordsets worked incorrectly. Fixed now.

The varchar and text fields data that contained national alphabet characters were sorted incorrectly. Fixed now.

Info messages were sometimes not displayed during repeated execution on SQL Server 2000. Fixed now.

Sometimes the run-time timer did not stop after the execution. Fixed now.

• Table and View editors, Data tab. Now the editing of the new datetime types values is possible with the input mask and the drop-down calendar.
• Table Editor, Data tab.

The width of the uniqueidentifier fields has been enlarged in the Form View.

On Windows 7 the grid was resized incorrectly after resizing of the form. Fixed now.

The grid level disappeared if the grid level was added and then the Refresh command was executed. Fixed now.

The “Set to Empty String” command did not work for varchar (max) fields. Fixed now.

When pressing Fetch All in tables with large number of records, the records were loaded slowly. Fixed now.

• Extract Database.

When extracting a table with the filestream field, the incorrect script was generated: the data were inserted before the creation of the unique key, which caused an error. Fixed now.

In some cases the commands of indexes creation were duplicated in the result script. Fixed now.

• Activity Monitor. The text is highlighted now in the SQL Text dialogue.
• During the text input some national characters were replaced by question marks in the grid and SQL editor. Fixed now.
• Query Builder. The query containing a clause or a value in brackets in the TOP was not parsed. Fixed now.
• Windows toolbar. The switching between windows worked incorrectly if a large number of windows were opened. Fixed now.
• When renaming the procedure without recompiling its body, the old name was displayed in the DDL. Fixed now.
• In some cases, the extra brackets in field default values were cut off incorrectly. Fixed now.
• In some cases constraint names autogenerated by the Server were displayed in table DDL. Fixed now.
• Procedure Editor. If the data export was launched after executing a procedure which returned the recordset, the Missing SQL property error occurred. Fixed now.
• Now it is possible to change the columns width on the Permissions tab of the objects editors.
• Table Editor. If on the DDL tab the filestream option and a constrained were set for the field, the erroneous SQL was created. Fixed now.
• Indices Management. When working with SQL Server 2000, empty strings could appear in the index list if the selected table contained the statistics objects. Fixed now.
• Table Editor. The statistics objects were displayed in the index list in SQL Server 2000. Fixed now.
• Other small improvements and bug fixes.

 

 

 Version 3.5.0.1

• Database Properties: the 'Transparent data encryption' option is now available when working with SQL Server 2008
• The Jobs form now opens faster
• SQL editors:

Added the possibility to load the file contents into SQL Editor by dragging the file from the Windows Explorer onto the editor 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

• SQL Editor:

If a file name and path were too long for the window caption, the application used to cut the filename. Now it cuts the path

XML field values were 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 a record set. Fixed now

The Ctrl+D shortcut is added for the “Show Results on Edit Tab” command

With a certain option combination set, all queries resulted in “0 records fetched”. Fixed now

• SQL Script: if a file name and path were too long for the window caption, the application used to cut the filename. Now it cuts the path
• Now it is possible to connect to a database if the user does not have the necessary rights to obtain the collation list
• Duplicate Object Wizard: now it is possible to change the form size
• Key mapping: the confirmation dialog is now displayed on deleting a scheme and key combinations
• 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

• Certificate Editor: the Start Date and End Date parameters now include the drop-down calendar to choose the date
• 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
• Data View: due to an error in Windows Vista, the grid size did not change when enlarging the form size. Fixed now
• Query Builder: an error occurred during the reverse engineering of a query where object names were quoted. Fixed now
• 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
• UDF Editor: when launching a UDF, its name was not quoted – an error occurred if the name included invalid characters. Fixed now
• 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
• 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

• It was not possible to open the editor for an object if its name looked like ‘text (text)’. Fixed now
• 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
• Field Editor: if the default object was bound to the field, an error occurred on saving – a wrong script was generated. Fixed now
• Index Editor: the Partitioning column list was not filled after choosing the partition scheme as an index data space. Fixed now
• Export as SQL Script: the values of numeric fields with a large precision were displayed as nvarchar values. Fixed now
• It was not possible to open Job Editor if connection to a database with a case sensitive collation was established. Fixed now
• Other minor improvements and bug-fixes

 

 

 Version 3.4.0.1

• 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: added the XML tab allowing you 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:

added support of database permissions for SQL Server 2005 and higher

users and roles are now separated in the 'Privileges for' list

column permissions were not always displayed correctly: the higher-level object permissions were not considered. Fixed now

• Database Registration Info:

most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified on the Grid | Data Options page will be applied as default settings for newly registered databases

added a possibility to select the OLE DB Provider: OLE DB Provider for SQL Server or SQL Native Client

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

• SQL Editor:

after the USE Transact-SQL statement execution the name of the current database is displayed in the status bar area of the editor

fixed several errors concerning syntax highlight

fixed several bugs concerning incorrect parsing of table aliases in queries

the Ctrl+Alt+C shortcut did not work for showing the list of fields of the table whose name is copied to clipboard. Fixed now

the displayed number of affected records was not always correct. Fixed now

• DB Explorer:

the Find Object dialog has been improved

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

the program saves the information about the last opened database before shutdown. When the application is started next time, this database will be automatically selected in the DB Explorer tree

the button for switching search mode is added to the Search Panel toolbar

double-clicking an object group node folds and unfolds its branch

when adding a server object, if the branch had not been refreshed yet, only this new object was displayed in the tree. Fixed now

• Extract Database:

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

with the 'Generate DROP statements' option enabled, odd statements for deleting table subobjects were generated. Fixed now

• 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

alignment options did not work when a diagram was loaded from a file

• Options: the ability to apply default settings (to all or just to a separate category of options) is implemented for all option dialogs
• Windows List: the 'Close All Database Windows' command is implemented
• 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
• Data Grid: the selected data record highlight changes when the focus is switched from the grid
• Job Step Editor: added support of the 'Write log to table' option, and new subsystems of SQL Server 2008
• Changes that take place upon table recreation are now written to the log of metadata changes: changing column identity, reordering columns
• Save Settings wizard: now, when saving settings to an existing file, the program suggests that you overwrite the file or make the new file unique by adding the current date and time to the file name
• Environment Options | Tools | SQL Server Reference: added an option for SQL Server 2008 Books Online
• Full-Text Catalog Editor:

the data type value of a full-text index was not applied on saving the object

when saving changes, pressing Cancel in the Changing Metadata window resulted in losing changes in the editor

• The DDL of user-defined functions did not contain comments to fields of the returned table. Fixed now
• Linked Servers: the content of the linked server was not displayed by the application if the provider did not support the information in the catalog. Fixed now
• Partition Function Editor: milliseconds in threshold values of datetime type were not displayed. Fixed now
• Export Data: when exporting data of type decimal with precision less than 15 digits, the numbers were rounded to the 4th decimal digit. Fixed now
• Query Builder: the width of the Link Properties dialog was set incorrectly when running in Windows Vista. Fixed now
• It was impossible to change object description if the object's description was an empty string. Fixed now
• Role Editor: the 'Refresh' command did not work within the Member of tab. Fixed now
• Field Editor: the 'Sparse' option could not be disabled for NOT NULL fields (in SQL Server 2008)
• It was impossible to turn off the database compatibility level warning on connection - the 'Do not ask me again' option value was not saved after closing the program
• Other minor improvements and bug-fixes

 

 Version 3.3.0.1

• The following SQL Server 2008 features are now supported:

compressed Tables and Indexes;

Field and file group filestream

filtered indexes

sparse columns

• Query Builder:

when a table is added to a query, its foreign key links to other tables participating in this query are reflected by JOIN statements

in some cases renaming a table and moving to the SQL tab resulted in the “Cannot bind JOIN expression” error. Fixed now

• DB Explorer:

the possibility to reorder hosts using drag-and-drop is implemented

the User role and Application role objects now have different icons

pressing the Edit Object button or selecting the corresponding context menu item with multiple selection of server objects resulted in opening a single editor. Fixed now

it is now possible to disable the warning that the database compatibility level is not set to its maximum value

• SQL Assistant: the Edit objects command did not work with server objects. Fixed now
• Database Registration Info: the 'Schema-organized database tree' option is added. With this option disabled, the object tree is built without grouping by schemas
• Database Properties: database owner information is now available
• The ability to edit the result of a query containing JOIN statements is implemented
• The seed and increment parameters of the IDENTITY field can now be negative
• Restore Database wizard: it is now possible to disconnect all users while restoring an existing database
• HTML Report: added a possibility to change the font size for the DDL section (the corresponding option is added to the Setting additional report options step of the wizard)
• The Changing Metadata window can now be closed by pressing the ESC key
• The Access Violation error appeared sometimes when deleting a User-defined data type. Fixed now
• Queue Editor: if the Rollback operation was made in the Changing Metadata window while editing a queue, all changes made in the Queue Editor disappeared. Fixed now
• Database object comments containing national symbols were displayed improperly if their collation differed from the client machine default language. Fixed now
• Extract Database: bugs concerning wrong statements order and incomplete object definition, and a number of others are fixed now
• Code Completion window: some system functions used to be duplicated in the list. Fixed now
• Code Parameters: the list of parameters did not appear if the object name was put into square brackets. Fixed now
• Visual Database Designer: some printers could not print field and table icons. Fixed now
• Table Editor: the Property tab could not be refreshed. Fixed now
• An attempt to connect to a SQL Server 2005 database with compatibility level 8 led to an error; contracts and routes were not refreshed in that case. Fixed now
• If different languages that use different decimal separators were set at the first and the last tabs of the Regional and Language options dialog (Start->Control panel), an error occurred when viewing tables with numeric data. Fixed now
• Data Grid: an error occurred when editing data of the date format with month as text (e.g. dd-MMM-yyyy). Fixed now
• Wrong shortcuts were displayed for a number of commands from the Quick Code context menu group. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 3.2.0.1

• Service Broker support is implemented; now all Service Broker objects are supported: message types, contracts, queues, services, routes, remote service bindings
• SQL Server 2008 support:

new data types support: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography;

table types support implemented: table types are displayed within the UDTs branch in the DB Explorer tree;

Backup Database wizard now supports new backup parameters such as compression, buffer count, max transfer size;

logon triggers support implemented: logon triggers are created in the server DDL Trigger Editor. New DDL trigger events are currently supported as well

• The Same queries for all databases option is added for the SQL Editor. With this option enabled SQL Editor stores all queries in a shared repository so that switching to another database does not cause loading that database queries (applying that option does not affect the currently opened copies of the SQL Editor). The values of the option can be changed freely without any risk to lose the query repository content
• SQL editors:

some functions work faster now

now you can change the size of the Code Completion list

the 'Search next' feature now works even if the ‘Find dialog’ was opened for another SQL Editor

• Job History tool: jobs can now be edited, stopped, run and deleted directly within the Job History form
• Server Log Viewer: time in the date field is now displayed with milliseconds
• Now on attempt to connect to database the compatibility level is checked with the prompt for changing it, if needed
• The ‘Invalid date’ error occurred when entering a date with different languages set at the first and last tabs of the Control Panel | Regional and Language Options dialog. Fixed now
• In some rare cases the ‘Multiple-step operation generated errors’ error used to occur when executing a query containing XML fields. Fixed now
• Activity Monitor: after refreshing the content, filtering options used to be resetted. Fixed now
• Dependency tab: the dependencies used to be displayed improperly for some types and procedures. Fixed now
• Location of toolbars within the program main window used to be resetted. Fixed now
• Print Metadata: the table field comments were not displayed. Fixed now
• Visual Database Designer: the default settings for the diagram were not applied to its first tab. Fixed now
• Export Data Wizard: now you can export all results of the multi-recordset query
• BLOB Editor used to allow editing data even in read-only levels. Fixed now
• Fixed the error that occurred on attempt to connect to a database using a password containing punctuation marks
• Many other minor improvements and bug-fixes

Scroll to top

 

 Version 3.1.0.1

• Implemented support for 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 Editor: a number of functions now work faster
• SQL Editor: fixed several bugs concerning incorrect work of code folding, 'List index out of bounds' and 'Access Violation' errors, cases of incorrect recognition of table aliases in queries, non-applicability of background color
• SQL Editor: 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: added the possibility to interrupt report generation
• Data Grid: sub-levels based on a SQL query can now be edited in the Load All Rows mode as well, if the query is built by one table and contains key fields
• Data Grid: upon insertion of text into a grid cell, Shift-Ins resulted in the duplicating field dialog. Fixed now
• View Editor: added a capability for editing queries in Query Builder
• 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
• SQL Editor: Unicode was not supported upon inputting parameters for queries containing parameters' declaration. Fixed now
• SQL Editor: when working with several instances of SQL Editor, Favorite queries were not always saved correctly. Fixed now
• SQL Editor: in some cases, after server connection was lost, no attempt to reconnect was made. Fixed now
• Upon duplicating full-text catalogs an error message appeared stating that the query could not be executed inside a transaction. Fixed now
• SQL Script: the 'Cannot create file' error used to occur on attempt to save the editor content to a file. Fixed now
• Extract Database: the generated CREATE DATABASE statement did not contain operators for creating files and file groups. Fixed now
• Server Log Viewer: in some cases the 'Field Date is not found' error occurred while opening a log. 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 entire text from the clipboard. Fixed now
• Dependency Tree: if the tree building was interrupted, rebuilding was not initiated upon subsequent selection of an object. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 3.0.0.1

• Added several new tools for working with the server: Server Log Viewer, Activity Monitor, Shrink Database wizard, Check Database wizard, Indices management and Update statistics wizards, server roles management
• Implemented support for a number of additional SQL Server capabilities: support of Symmetric keys, Asymmetric keys, Certificates; support of Full-text catalogs and Full-text indices; support of server DDL triggers; support of Endpoints; support of Database Snapshots; support of Shared Schedules, Proxies and Target Servers in Jobs; support of new login properties, such as password policy, enable/disable; creating Certificate-mapped and Asymmetric key-mapped logins; capability of mapping logins to database users in Login Editor; assigning credentials to SQL Server Logins
• Support of Unicode in SQL Editor, Query Builder, Grid View, Import/Export Data wizards
• All wizards, including Import/Export Data wizards, Extract Database wizard, Backup/Restore Database wizards run in background mode now, allowing one to continue working with the program
• New advanced SQL Editor of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
• Enhanced Import Data Wizard - now data can be imported up to 10 times faster; also added support of the following source file formats: HTML, XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007)
• Added the Permissions tab to object editors, making it possible to grant privileges on objects to users and roles
• Improved DB Explorer in several respects: added a menu for generation of common SQL statements for database objects (Script to SQL Editor, Script to Clipboard) - it is now possible to get CREATE, ALTER, DROP, SELECT statements for each database object; DB Explorer displays server objects (objects of the server level) as well; object status (e.g. enabled/disabled) is indicated by corresponding icons; added Tasks submenu to the context menu, items of the submenu provide access to basic operations that can be performed over the selected object/database/server; added the Search Panel
• Now it is possible to save frequently used queries within the Favorite Queries node of DB Explorer; Favorite Queries can be stored either locally in Windows Registry (in this case they are only available for local users), or in a special table of the database (therefore, the queries can be accessed by all database users)
• Enhanced Visual Database Designer: added a new diagram object (Comment); possibility to select the specification level for displaying objects (only object names, only fields); upon Reverse Engineering one can select schemas to add their tables to the diagram
• Improved Export Data Wizard: now works faster; added several output file formats: XML Document, Open Document Format (ODF), Open XML Format (MS Word 2007, MS Excel 2007)
• Advanced Table Editor: added a possibility to view and edit table properties within a separate tab
• Added the Find Option tool which allows one to find the required option in the scope of all program settings, by a word or an expression from the option title
• Enhanced reports management system
• It is now possible to execute functions directly in Function Editor window
• Extract Database wizard: object dependencies are now handled correctly
• Backup/Restore Database wizards: implemented support of several additional backup/restore parameters applied to SQL Server 2005 (copy-only backup, verify backup when finished, checksum support)

Scroll to top

 

 Version 2.7.0.1

• Database properties: information about the database is now displayed: the size of the entire database, data, indexes, transaction log, etc.; the date of the recently performed full, differential, transaction log backup
• Database properties: possibility to rename the database added
• Database properties: it is now possible to open this dialog for disconnected databases and for databases in the offline mode
• Database properties: it has become possible to change the name and location of database files (the latter is applied to SQL Server 2005 only)
• DB Explorer: it is now possible to view brief table information in SQL Assistant
• It is now possible to modify the schema/owner in object editors
• Incremental search has been added to a number of object lists
• Data View: for string fields of 80 and more characters in length an editor similar to that used for editing TEXT fields is implemented in the Form View; also, the "Word wrap in string editor" option is added
• Table Editor, Fields tab: the Data Type column now contains the basic type on which the current data type is based
• SQL Editor: when several copies of SQL Editor are used and the content of one of them is being saved, the changes in the content of the other ones are also considered
• Export as SQL Script: you are now prompted to confirm the result file replacement if the file already exists
• HTML Report: an error used to occur when building a report for SQL Server 2000 users ("Invalid object name sys.schemas"). Fixed now
• Fixed the "List index out of bounds" error that occurred on Step 2 of Export Data Wizard with German localization applied
• An error used to occur upon attempt to add the IDENTITY field to an existing table. Fixed now
• When working on Windows Vista, with Native Client installed and SQL authentication used, it was impossible to connect to the server. Corrected now
• Trigger Editor: it was impossible to change the 'Enabled' property for encrypted triggers when using the editor
• In SQL Editor the name of the object was not displayed as a link when the default schema was not [dbo] for the current user and the name of the object of this schema did not contain the [dbo] schema name
• Restore Database: there was an error when specifying the backup file on selecting backup set to restore from (in the "Backup of database" mode). Fixed now
• Extract Database: dependencies between Views and User-Defined Functions were not considered in the generated script. Corrected now
• Grid: in the Load Visible Rows mode the Blank and the Non Blank filters did not work. Fixed now
• After aligning windows, e.g. by title vertical, another object selection in the object editor caused changing the position and the size of the form. Fixed now
• Visual Database Designer: the Primary keys that were created for several fields were not displayed. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 2.6.0.1

• SQL Script: ability to execute selected statements and statements under cursor added
• The identity field property can now be edited
• Reorder Fields: field order can now be changed no matter if the table has other dependent objects or not
• Table Editor: if Object Explorer is turned off, Table Editor opens quicker. Object Explorer can be disabled within the Object Editors section of the Environment Options dialog
• Table Editor, Fields tab: the Identity column added
• Extract Database: view triggers used to be extracted with empty bodies. Fixed now
• SQL Editor, Query Builder, Procedure Editor: when executing a query asynchronously, CPU load could reach 100%. Fixed now
• The DDL of assemblies is now represented as binary code
• Dependency Tree: with the 'Show subobjects' option enabled, the dependencies were displayed not quite correctly. Fixed now
• Dependency Tree: object icons were not printed. Fixed now
• SQL Script: the SQL Script window does not close upon disconnect from the database
• SQL Script: the error list was not cleared when loading a file. Fixed now
• Editor Options: the ability to set default colors added
• Index Editor: when creating an index, you need not specify the data space; the data space of the table is used by default
• SQL Editor: when switching between queries, the cursor and the scrolling bar position were not saved. Fixed now
• DDL Trigger Editor: wrong script used to be generated when disabling/enabling an existing trigger. Fixed now
• Data View: mouse-wheel scrolling for the Form View is implemented
• Visual Options: the 'Menus show recently used commands first' option added
• Environment Options | DB Explorer: the 'Refresh object on showing in SQL Assistant' option is added
• Add Grid Level: with the ‘Show tables related by foreign keys only’ mode enabled, loading tables used to take much time on SQL Server 2005. Fixed now
• It was impossible to create a TIMESTAMP field with a NOT NULL restriction. Fixed now
• To-Do List: on selecting a disconnected database in the list the ‘Invalid authorization specification’ error message used to appear. Fixed now
• In some rare cases when executing several queries simultaneously in asynchronous mode, the 'Access Violation' error used to appear. Fixed now
• DB Explorer: a newly created object was not listed in the 'Recent Objects' drop-down menu
• View Editor, Triggers tab: if a view had more than one trigger, the type for the second and the succeeding triggers used to be displayed incorrectly. Fixed now
• Visual Database Designer: in some rare cases when opening a chart the ‘Could not convert variant of type (OleStr) into (Double)’ error occurred. Fixed now
• Export as SQL Script: the values of DATETIME and binary types used to be returned incorrectly for the sql_variant fields. Fixed now
• Import Data Wizard: when importing from DBF format, the default values for the Boolean type were 'False' and 'True' (instead of the required 'F' and 'T'), so it was necessary to change them into the appropriate ones while processing the data. Fixed now
• The Changing Metadata window can now be closed with the Esc button applying no changes
• Environment Options | Windows: the 'Number of open editors is restricted' option did not function. Fixed now

Scroll to top

 

 Version 2.5.0.1

• Database Registration Info: an option that allows one to skip refreshing objects on connection to database is added
• SQL Editor, SQL Script, Procedure Editor: information messages are displayed correctly now; to enable the messages, switch on the corresponding options within the Tools and the SQL Script sections of the Environment Options dialog)
• French localization added
• Grid: items that allow switching between grid tabs are added to the context menu
• Grid: in some cases for the master-detail views related by decimal or money type field in the "Load all rows" mode the records were not displayed. Fixed now
• Grid: filtering of DATETIME type data used to work incorrectly in SQL Filter mode. Fixed now
• Grid: the "Word wrap in memo editor" option added (Environment Options | Grid | Advanced)
• Grid: formats set in Grid | Color & Formats were not applied to detail levels. Fixed now
• Linked Servers: Now this feature works fine with SQL Server version 7.0
• Export as SQL Script: 'COMPUTED BY' fields were not excluded from the INSERT statements. Fixed now
• Export as SQL Script: sql_variant type data were always represented as strings in the result script. Fixed now
• CLR User-defined data types were not shown in the DB Explorer tree. Fixed now
• When duplicating a table with data into another database, the TEXT and NTEXT type data were not copied. Fixed now
• When duplicating a procedure, its name remained. Fixed now
• DB Explorer: after adding an object into the project it did not appear within the Projects node. Fixed now
• Trigger Editor: the comments preceding the CREATE TRIGGER statement were not displayed in trigger DDL. Fixed now
• SQL Editor: for queries returning more than one dataset the value of Fetched records is changed now in the status bar on switching between the grid tabs
• On executing a procedure with parameters, those of DATETIME type containing the time part were not saved between execution sessions. Fixed now
• Visual Database Designer: after resetting all toolbars and opening Visual Database Designer, the toolbar used to disappear from the form. Fixed now
• The 'Reset all Toolbars and menus' command did not work properly for DB Explorer toolbar. Fixed now
• Now it is possible to resize the To-Do Item Editor window
• Dependency Tree: the 'Save as image' button is now available on the Navigation bar
• When creating a table without the NOT NULL flag for the Primary key, the constraint was not applied automatically, which caused wrong script generation and resulted in error upon its execution. Fixed now

Scroll to top

 

 Version 2.4.0.1

• Export as SQL Script: now you can specify the DBMS for which the script should be generated
• BLOB Editor now supports BINARY and VARBINARY field types
• Linked Servers: now you can see the tables and views contained by a linked server
• Extract Database: now views and procedures are arranged in accordance with the object dependencies in the target script
• DB Explorer: the 'Add to Projects' command implemented; now objects can be added by specifying them in the corresponding dialog, and not only by dragging into the Projects folder
• When duplicating an object into another schema, for some objects its definition used to change incorrectly in DDL generated. Fixed now
• Grid: the 'Expand All' and 'Collapse All' context menu items added
• Grid: the 'Save column sorting' option is added for the 'Save and restore layout' mode
• Grant Manager: now User Editor and Role Editor can be called directly from this window
• Naming Rules: XML index support implemented
• CPU usage significantly decreased
• For the fields allowing NULL value the 'Null' sign is indicated in table definition now
• SQL Editor: for the queries which allow data insert the ability to import data into the table implemented
• SQL Editor: the Code Completion tool did not start automatically. Fixed now
• SQL Editor: in some cases the Results tab was not displayed. Fixed now
• SQL Editor: in some rare cases the 'Range Check Error' message appeared during query execution
• SQL Editor: upon opening object editor with the Ctrl+Enter shortcut used, the scheme was ignored. Fixed now
• SQL Editor: the Ctrl+Shift+Enter shortcut for pointing out the corresponding item in the DB Explorer tree worked incorrectly. Fixed now
• SQL Editor: the Code Completion tool used to work incorrectly with the "[" and the "]" symbols. Fixed now
• SQL Editor: after dragging objects from DB Explorer to SQL Editor the Undo command worked improperly in some rare cases
• SQL Editor: the 'Select All' command did not work correctly on text with long lines (more than 4096 symbols)
• Restore Database: it was impossible to use logical backup device containing the space character(s) in its name. Fixed now
• Job schedule, daily frequency: fixed the bug with improper handling of Daily frequency control (minutes used to be interpreted as hours and vice versa)
• The size and Scale for input parameter type could not be set when creating new partition functions. Fixed now
• Table Editor, Data tab: fixed the bug with incorrect displaying of the bit-typed fields in the 'SQL filter' mode
• The dependencies were not displayed for XML schema collections. Fixed now
• To avoid script errors, the name of XML schema collection is always quoted now when creating an XML-typed field
• Import Data Wizard: when setting column correspondence for import from Excel, selecting a new column caused the cursor to move to the first column in the grid. Fixed now
• Database Registration Info: when applying changes, the originality of database aliases used not to be checked. Fixed now
• Visual Database Designer: switching to another visual scheme did not take any effect in context menu style. Fixed now

Scroll to top

 

 Version 2.3.0.1

• Editor Options: added the Key Mapping section that allows you to set shortcuts for SQL editors
• XML Schema collections support is implemented
• Query Builder: query execution plan is now displayed as a graphical diagram
• Query Builder: queries containing user-defined functions are now supported
• Dependency Tree: the diagram can now be printed
• SQL Editor: now it is possible to rename and move query tabs
• SQL Editor: ability to execute statement under cursor added
• SQL Editor: query execution time is now displayed in the hh:mm:ss format
• SQL Editor: the timer in status bar area used to stay running on after aborting query execution. Fixed now
• SQL editors: now you can set a source code fragment as a comment with a single click
• SQL editors: next Bookmark, Previous Bookmark context menu items added
• SQL editors: with 'Trim trailing spaces' option on, an attempt to use Code Complete used to clear the whole line. Fixed now
• SQL editors: dragging the field names from SQL Assistant works perfectly now
• When opening Grant Manager window, it was impossible to edit statement permissions without forced refresh. Fixed now
• HTML Report: now you can include user and role information into reports
• HTML Report: ability to change header/footer of the report added
• Extract Database: now provides an option adding the CREATE DATABASE statement to the script
• Extract Database: server version is included into comments for the script now
• Environment Options: now it is 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
• The open/save backup file dialogs now look more like standard ones in behaviour
• Import Data Wizard: with the 'Use transactions...' option disabled, in the 'Commit changes manually' mode you are now prompted for an action on transaction
• Import Data Wizard: ability to resize the wizard window added
• Import Data Wizard: the 'Division by zero' error used to appear after importing data with the 'Commit changes manually' option switched on. Fixed now
• Import Data Wizard: having specified user-defined fields to import, the rest of them were filled with empty strings; so that the default values defined for the fields were not applied. Fixed now
• Trigger Editor: when altering a trigger, the schema/owner name was not added to the trigger name in the generated script, that in some cases raised errors. Fixed now
• Foreign key/check constraint editors: the 'Not for replication' option added
• Visual Database Designer: it was impossible to drop table via the corresponding context menu item when just a field, not the table itself, was selected. Fixed now
• Visual Database Designer: when dragging a table of a non-default schema (SQL Server 2005) from DB Explorer to the working area, an error used to appear and the table was not added. Fixed now
• Grid: the 'Paste Cell' context menu item did not work in the Lite version. Fixed now
• Grid: in some rare cases the data of of BIGINT fields were displayed improperly. Fixed now
• Grid: with the 'Column auto-width' option enabled, BLOB field columns used to become too wide. Fixed now
• SQL Script: confirmation of abort script execution added
• Restore Database: it was impossible to type in backup file name in the corresponding window. Fixed now
• Restore Database: prompt for database registration used to appear even if restoration was unsuccessful. Fixed now
• Job Editor: fixed the bug with wrong script generation when you saved the job in which the created schedule was deleted
• DB Explorer: it was unable to open index or trigger via the Recent Objects menu. Fixed now
• DB Explorer: the context menu used to stay on top when switching between applications. Fixed now
• DB Explorer: after table duplication the indices and triggers of the new table were not displayed in the tree. Fixed now
• Export Data Wizard: with the 'Export empty tables' option disabled, on attempt to export an empty table there appeared an error containing no text. Fixed now
• Export Data Wizard: in some cases, when exporting data to MS Excel, the 'Data format \ Styles' options used to work incorrectly. Fixed now
• Export Data Wizard: when exporting data to MS Excel, the user-adjusted Boolean True format used to be ignored. Fixed now
• Detach Database: having used the 'Clear connections' function, the database was still displayed in the DB Explorer tree and further attempts to access its objects returned errors. Fixed now
• Many other small improvements and bug-fixes

Scroll to top

 

 Version 2.2.0.1

• SQL Editor: query execution plan is now displayed as a graphical diagram
• SQL Formatter: formats SELECT, INSERT, UPDATE, DELETE queries (available from SQL Editor context menu)
• Grid: when pasting records from the clipboard, you can now set correspondences between clipboard columns and query columns
• Form View: Memo-fields editor is extended (can be customized within the Grid | Advanced section of the Environment Options dialog)
• Blob View: 'Word Wrap' option for text added
• Grid: 'Set to Empty String' and other similar operations do not result in posting records in the table any more
• SQL Script: the progress of script execution is now displayed and the execution process can be stopped
• SQL Script: several windows can now be opened simultaneously
• SQL Script: SQL Script used to hang when a large (>10Mb) script was edited and Enable Parsing was on. Fixed now
• SQL Script: now some additional statement types can be parsed
• SQL Editor: query execution plan can now work with SQL Server 2005
• SQL Editor: now there are no limitations for the size of edited scripts
• Field Editor: default constraints now can be renamed
• DTS Packages: now you can remove imported packages
• Table Data: not all the records added with the following COMMIT in "Use transactions in Data tab of object editors, SQL Editor and Query Builder" mode (Environment Options | Tools) were displayed. Fixed now
• Extract Database: with the "Insert COMMIT after each block" option on, COMMIT was added without corresponding BEGIN TRANSACTION. Fixed now
• Extract Database: empty NOT NULL image fields used to be displayed incorrectly. Now fixed
• Extract Database: dbo name was missing when generating INSERT INTO [dbo].[table_name]
• Export as SQL Script: with the "Insert COMMIT after each block" option on, COMMIT was added without corresponding BEGIN TRANSACTION. Fixed now
• Dependency Tree: wrong dependency order was shown for Assemblies, Aggregates, Partition Functions and Partition Schemas: the parent object used to be displayed after the dependent one. Fixed now
• Visual Database Designer: changing the table name and editing the fields did not affect the currently opened graphical diagram. Fixed now
• Reorder Columns, Duplicate Table, Extract Metadata: tables with timestamp/rowversion fields are processed correctly now
• Switching program interface language took a long time if there were any databases connected. Fixed now
• Database Properties: if the "auto file growth" option was off for a DB file, it could not be turned on. Fixed now
• Attach Database: it was impossible to set login and password using SQL Authentication. Fixed now
• Attach Database: the 'File name' field did not have the Explorer button to call the "Open File" dialog. Fixed now
• UDF Editor: options of the 'For new columns only' group are processed properly now
• DB Explorer: it was impossible to duplicate triggers and indices. Fixed now
• DB Explorer: after dropping a trigger or Index it was still displayed in the tree
• Query Builder stores queries between sessions now
• The 'Don't fill server lists in connection forms' option is added; the option disables retrieving information about all SQL servers available on the local network because in some rare cases it might take a long time
• The border of the SQL Editor window is now painted according to the current visual scheme
• Procedure Editor: if the FLOAT type was specified for a procedure parameter and had a value equal to 0, it used to be processed as NULL. Fixed now
• Restore Database: sometimes due to the improper size of the dialog the directory tree at the Select Backup Set step was not seen. Fixed now
• The corresponding documentation page did not open for some forms when pressing F1. Fixed now
• Synonym Editor, Aggregate Editor: it was impossible to create an object when the <Default> scheme was selected because of wrong script generation. Fixed now
• Create Database wizard: if log and data files had the same names when creating a database, the log file was not created. Fixed now
• Aggregate Editor: if a parameter does not contain the at ("@") sign, it is added automatically now
• Aggregate Editor: turning on the Max Size option disables the Size field now
• Fixed the bug with the Code Completion drop-down list which could be partially covered with Windows Taskbar
• On continuous holding F5 button to refresh the objects in DB Explorer they used to double. Fixed now
• Table/Field Editor: identity seed is now displayed properly for values greater than 65536
• Check Editor: the "Check existing data" option is not cleared anymore after compiling the current check
• After renaming the object its name was not refreshed in DB Explorer context menu. Fixed now
• For some forms the Refresh operation could not be performed with F5 key used. Fixed now

Scroll to top

 

 Version 2.1.0.1

• Partition functions and partition schemes are now supported
• Added the ability to work with linked servers
• German localization is implemented (Michael Albrecht)
• Export/Import wizards: added the "Save Current Settings as Default" drop-down menu and the "Reset Saved Settings" option in Templates
• New editor options added: trim trailing spaces, Drag and drop text, Group undo, Keep caret horizontal position
• Grid: large queries were opened very slowly because the switch to Grid Mode Load All Rows was executed after the grid was filled. Fixed now
• Export Data Wizard: added the 'Finish' button that runs the Wizard at any moment
• Export as SQL Script and Extract Database wizards gave values of datetime type in the formats predefined in Windows settings, which sometimes caused execution errors. Fixed now
• When creating a CLR user-defined data type, correct script is generated now
• Unicode data are now displayed correctly for the system language for non-Unicode programs
• Object editors: when pressing F5 in the subobjects lists, the 'Access Violation' error occurred. Fixed now
• Window List: added the 'Close window' item to the context menu
• The "Don't save query text" option available back in version 1.x of the program is now restored in SQL Editor
• Grid: adding level bound by several fields caused “Invalid column name” error. Fixed now
• Save Settings: multi-line keyboard templates were blank when imported from a file. Fixed now
• Keyboard templates: the #Date tag gave the wrong date. Fixed now
• Printing now works correctly in Aggregate, DDL Trigger and Synonym editors
• Index editor: clicking the header of selected fields list returned the 'Access violation' error if the list was empty. Fixed now
• SQL Script is now saved with any content of the editor
• Allow parameters in SQL (Environment Options | Tools) for currently opened Query Builder and SQL Editor windows can now be activated; also, when running queries asynchronously, the values of parameters were not taken. Fixed now
• Other small improvements and bug-fixes

Scroll to top

 

 Version 2.0.5.1

• When closing the program it gave a number of errors if no other programs were running. Now fixed
• Field default values are now displayed correctly now when working with SQL Server 2005
• SQL Editor: text search did not work when called from the context menu. Fixed now
• SQL Editor: sometimes the Limit bar was displayed for grid. Fixed now
• SQL Editor: code completion across databases did not work by table alias with owner (schema) not specified. Fixed now
• SQL Editor: code completion by table aliases did not work after 10-15 table lines down the text. Fixed now
• SQL Editor: when adding a new tab and trying to delete a row, the "Access Violation" error emerged. Fixed now
• Database Registration Info: Display Options were not saved after closing/restarting the program. Fixed now
• Now the size of stored procedure and UDF parameters is shown correctly
• SQL Script: the "Access Violation" error arose upon calling Code Completion if there were no connected databases. Fixed now
• DB Explorer: now the parameter information of some stored procedure types is displayed correctly in SQL Assistant
• Grid: filtering by value that had an apostrophe (‘) character did not function. Fixed now

Scroll to top

 

 Version 2.0.0.1

Basic features:

 

Latest SQL Server versions support

• Full compatibility with all SQL Server versions from 7 to 2005
• Full support of SQL Server 2005 permission system
• DDL Triggers, Synonyms and Aggregates support
• Typed XML columns

Significantly improved user interface

• New well-described Wizard System to perform complex tasks easily
• Fast access to most essential actions using Navigation bars in most of the windows
• New Windows Toolbar to switch windows easily, like in Windows Task Bar
• Office 11 and Windows XP visual schemes support

Improved Database Explorer

• Creating tabs for any tree node to access it in one-click
• Work with multiple selected objects at a time
• Much more convenient toolbar and context menu

New powerful tools to perform SQL Server administrative tasks

• Server Properties and Database Properties windows
• DTS Packages management tool

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 tool
• Creating/editing/dropping tables and table fields visually setting links between them
• Saving as image or printing database diagram
• Two diagram notations (IDEF1x and IE)
• A lot of visual customization options

New powerful data management tools

• 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
• Ability to copy and paste selected records
• Advanced printing system
• Fully customizable interface

Improved report management

• The new Create Report Wizard allows you to create a simple report in a few clicks
• Managing reports in the same way as if they were database objects: accessing reports directly through DB Explorer tree

and more...

Scroll to top

 

 Version 1.8.5.1

• Support of Microsoft® SQL Server 2005
• When an error arises in SQL Editor or in the Changing Metadata window, the cursor is placed to the proper place now
• Creating table: enhanced editing abilities in the Fields grid
• Editor Options: added the 'Convert Tab character to spaces' option
• SQL Editor: implemented the 'Don't save query text' option
• SQL Editor: added an ability to reset current execution point - the corresponding item is added to the context menu
• Table Editor: confirmation request was not displayed upon deletion of table subobjects even if the corresponding option was on. Now fixed
• Query Builder: the WHERE part was parsed incorrectly if there were several IN operators - the list was duplicated
• Timeouts did not work in SQL Script
• Sometimes when disconnecting from a database, its objects were refreshed if viewing table subobjects was off
• Grid: the time values were not shown on attempt to enter the edit mode for datetime fields
• When trying to open a procedure with number (e.g. proc;1), there occurred an error saying that the procedure was not found in the database
• The program hanged when using keyboard templates if Windows clipboard had the hash (#) sign
• To-Do List: upon editing an item a second copy of the item used to appear in the list. Fixed now
• Table Editor, the Dependency tab: tables with foreign keys referring to a currently opened table were not shown in the dependent objects list
• If the Clustered checkbox was off when creating an Index, keyword NONCLUSTERED was not added to the script, which led to creating a clustered primary key
• Shortcuts for tabs did not work. Now fixed
• Resolved the issue when the state of the main form window was not restored when running the application
• It was impossible to edit fields having a dot (.) character or the 'on' word in their name. Now fixed
• Code Completion did not work with table aliases which had the dollar ($) sign in their name, e.g. "TableName$". Now fixed
• Editor Options: decreased the minimum possible value for Quick Code delay
• Other small improvements and bug-fixes

Scroll to top

 

 Version 1.8.0.1

• Implemented the ability to generate names for the table subobjects on their creating automatically; you can customize the name templates or disable this option using the Naming Rules section of the Environment Options dialog
• Extract Metadata: changed the sequence of some operator types to register possible dependencies between objects; included support for identity and calculated fields; added an ability to generate the IF EXISTS... DROP statements
• SQL Editor: now it is possible to view the query results under the same tab with the query text
• There is a new possibility to disable the Changing Metadata window using the corresponding option within the Confirmations section of the Environment Options dialog
• Query Builder: the "Access Violation" error emerged on attempt to add a criterion and close the form. Fixed now
• Table Data: the 'DataD: Cannot perform this operation on a closed dataset' error does not appear anymore
• On creating a unique Index you can now select whether to create an index or a constraint
• Grid: added the possibility to set format for the money fields within the Grid tab of the Environment Options dialog
• Table Data: fixed the bug when the Grid layout was not saved
• The 'Make hidden Table Explorer visible on new table window' option is substituted for 'Hide Table Explorer'; a new button is added to the toolbar of Table Editor to show/hide the explorer
• If a field was indexed, you could not change its type or the NOT NULL constraint - the script error arose. Fixed now
• Extract Metadata & Export as Insert: when extracting BLOB data, the final bytes with 0x00 value were cut. Fixed now
• Export Data Wizard: when the 'Current record only' option was selected the cursor jumped to the first record and the first record was exported. Fixed now
• When running the program, it was impossible to shut down Windows. Fixed now
• Print Metadata: fixed the bug when the Primary Key and Unique columns of table fields were not filled out
• Now the 'Help | Send bug report to' main menu item allows you to access our Support Ticket System
• The 'Class TSynEdit not found' error arose on attempt to open the localization form. Fixed now

Scroll to top

 

 Version 1.7.0.1

• Implemented a new form for creating tables: now it allows you to define all table fields before table creation
• Import Data Wizard: added a possibility of defining the error log file name
• Backup/Restore: while working with large databases, the operation was canceled by timeout in 30 seconds. Now the problem is solved
• Fixed the following bugs concerned with Code Completion: processor loading was raised after the window "code completion" had been opened with a non-default localization used; the focus bounced back to the top of the list after one started typing; the view was not canceled in case a space character was entered or the cursor was moved after typing a letter or a number; there was a problem with re-opening the code completion window after inserting a keyword
• Export as Insert: in float fields the dot (.) character is used as a fractional part separator now
• The bug that caused only tree-choice of backup filename in case of using non-logical device is fixed now
• Wrong script was generated when a Not Null field with a Unique constraint and without default value had been added. Fixed now
• After a field with a unique non-constrained index was changed, wrong script was generated. Fixed now
• Available permissions were defined incorrectly for UDF. Fixed now
• Edit login: the password could not be cleared. Fixed now
• Confirmation is requested now on attempt to delete query pages
• Integer field changes (if the field was not in edit mode) were saved incorrectly. Fixed now
• The font size changes in Environment Options were not applied to menus and toolbars. Fixed now
• Corrected the "RecordIndex out of range" error that used to appear when editing database file list
• The Row Guid flag could not be changed for fields with type "uniqueidentifier". Fixed now
• Sometimes after upgrade to a new product version the language settings could not be changed. Fixed now
• Export to XML: if table field names contained spaces, the summary file would not open. Fixed now
• Changing Metadata window: now the editor font is determined by the database properties instead of the defaults used previously

Scroll to top

 

 Version 1.6.0.1

• Significantly improved the Export data dialog: now you can add notes, hyperlinks and charts based on exported data to Excel documents; you can also define graphical styles for column captions, data, footer, and header for export to RTF documents; ability to define strip styles is also included
• Significantly improved Import Data Wizard to make most of EMS QuickImport 2 component suite new abilities available in MS SQL Manager: import from XML format is available now; a possibility of importing data from different Excel sheets is implemented; a possibility of importing formulas from Excel is added
• We have implemented a new service - Backup Devices Manager: you can access this tool using the Services menu
• SQL Editor: now you can use the Shift+Ctrl+Space key combination to view function parameters after you enter a function name in your code; the Shift+Ctrl+P key combination can be used to insert names of the function parameters into your code
• Duplicate Table: in this version you can copy the table metadata and data to another schema/database
• Added a new localization - Chinese (Simplified)
• The Database Metadata log now contains only records that are executed completely and not rolled back
• The SQL Editor log now contains only statements that are executed successfully. You can disable this feature using the corresponding option within the SQL Editor section of the Environment Options dialog
• Now the program correctly displays all objects within the Dependencies tab
• If a table contained a calculated field with more than 4000-char length, then the 'List index is out of bounds' error appeared. Now fixed
• Form View: NULL values of date fields were displayed as 30.12.1899. Now fixed

Scroll to top

 

 Version 1.5.0.1

• Implemented two new services - Backup Database and Restore Database: you can access these tools through the Services menu
• Data Grid: now you can filter data in the 'Load Visible Rows' mode; the program exports only the filtered data
• Improved the reporting tools (Print Metadata and Print Data tabs of the program windows): added powerful filters for exporting data to different formats, such as XLS, RTF, HTML, BMP, JPEG and TIFF
• Now the program compiles large procedures, views, user-defined functions and triggers without losing spaces in the object body
• Now you can create fields flagged with the Not Null constraint without any problems
• SQL Script: fixed a bug that caused the "Control 'tlMessages' has no parent window" error after successful script compilation
• Now the program correctly creates fields with the Collation and the Default parameters defined; correct DDL is also built for tables that contain fields with these parameters
• SQL Script: now the program correctly saves scripts upon pressing the Ctrl+S shortcut
• Fixed a bug that caused high processor loading when typing text in SQL Editor if the selected interface language was different from default
• Now the program correctly displays connection errors that appear when connecting to the database
• If the database contained two procedures with names different only in character case, then the 'Index is out of bounds' error appeared. Now fixed
• Fixed the 'Index is out of bounds' error that appeared on attempt to create a job schedule
• If an operation caused many errors on the server, then the program returned only the last one; now all errors are returned
• SQL Script: fixed a bug that caused incorrect word wrapping in the Messages window
• Fixed a bug with a button on the Form View tab that shows BLOB content
• View Editor: fixed a bug that sometimes caused the 'List index is out of bounds' error when switching between the Description and the Data tabs
• Extract Metadata: now the program correctly extracts values of BIT fields
• Small improvements and bug-fixes

Scroll to top

 

 Version 1.4.0.1

• Implemented four new services: Jobs, Job History, Alerts, and Operators; these services are available through the respective items of the Services menu
• Added Romanian localization to the installation package
• SQL Editor: the grid did not show results of any queries after executing query that returned empty dataset in asynchronous mode. Now fixed
• The 'Class Tcxbutton not found' error appeared when trying to open the Keyboard Templates dialog. Now fixed
• SQL Editor: Fixed bug with displaying number of affected rows when executing queries in asynchronous mode
• SQL Script: The Rollback on Abort option works correctly now
• Added the vertical scrollbar to the stored procedure parameters dialog; now you can define the procedure parameters without any difficulties
• Fixed the bug giving the 'Insufficient key column information for updating or refreshing' error when refreshing query results
• Fixed several bugs in the Code Insight system; now the system correctly works with queries that contain aliases
• Export data: now the Export dialog automatically adds the file extension to the file name
• Now you can call the Replace Text dialog using the Ctrl+R keyboard shortcut in SQL Editor and in SQL Script editors

Scroll to top

 

 Version 1.3.0.1

• Implemented the threaded query execution: now you can stop query execution at any time. To enable this feature, check the "Asynchronous query execution" option within the Tools tab of the Environment Options dialog
• SQL Editor: now you can view the query execution plans. You can view the plans by pressing the corresponding button on the SQL Editor toolbar, or by checking the "Explain Query" option within the SQL Editor section of the Environment Options dialog
• Now grids automatically switch to the "Load Visible Rows" mode on opening queries with a large amount of result rows
• Now the DDL tab and the Extract Metadata Expert show object owners that differ from "dbo"
• We have fixed a bug with stored procedure execution
• Now the "Refresh" item of the DB Explorer context menu includes the type of object to refresh
• Now the table explorer is correctly refreshed after deleting the table subobjects in the DB Explorer
• Some small improvements and bug-fixes

Scroll to top

 

 Version 1.2.0.1

• Added the Services menu which contains two database services - Attach Database and Detach Database
• Now you can run stored procedures directly from Procedure Editor
• Now MS SQL Manager supports operation timeouts. You can setup the timeout values using the Timeouts panel available within the Tools section of the Environment Options dialog
• Added the "Try to open server cursor" option to the SQL Editor section of the Environment Options dialog
• The "Field 'Name' not found" error appeared on registering database for some servers. Now fixed
• Now MS SQL Manager correctly opens tables with large NUMERIC and DECIMAL fields
• Fixed a bug in the Code Completion system. Now it correctly displays view fields
• Fixed a bug with comments on altering procedures and functions
• The "Cannot focus a disabled or invisible window" error appeared in some cases. Now fixed
• SQL Editor: fixed a bug when the "There is no active transaction" message appeared during query execution, with transactions disabled
• Query Builder: fixed a bug with dragging and dropping tables from the explorer panel to the workspace
• SQL Script: fixed bug in building the object tree, if the script contains objects, which names differ only by char cases
• Editor Options: now you can customize colors for SQL functions and SQL data types
• Now SQL Editor saves the cursor position for every script, which is currently opened
• Added 'Copy' and 'Paste' items to the grid context menu
• Now MS SQL Manager does not show the _WA_Sys_xxx indexes
• A large amount of bug-fixes in Query Builder
• Some small bug-fixes and improvements

Scroll to top

 

 Version 1.1.0.1

• Implemented an opportunity to view dependencies between database objects: this feature is accessible through the Dependencies tab of all Object Editors
• Considerably increased connection speed
• Now you can set almost all database options using the Database Properties dialog
• Implemented Default Editor and Rule Editor
• Now object names containing unavailable symbols are enclosed in square brackets []
• Now text editors are displayed much faster than in the previous version
• Fixed a bug with connection to database with SQL Authentication if the 'Password' field was not empty
• The "Cannot sort a row of size XXXX, which is greater than the allowable maximum of 8094." message appeared upon connection to databases containing large objects. Now fixed
• Fixed error "Field 'sql2' not found" that used to occur on connection to databases containing large triggers
• Fixed the "Invalid column name 'Collation'" error that appeared on connection to the database if the 'Collation' property was set to a case-sensitive value
• Now you need to confirm record deletion on pressing the Delete key in the grid
• Fixed a bug with displaying object comments
• The 'Login prompt before connection' option available in the Database Info dialog works properly now
• All windows with text editors are displayed correctly now
• Now View Editor generates correct update script if there is a comment before the view definition
• Small bug-fixes and improvements

Scroll to top

 

 Version 1.0.0.1

Basic features:

• Easy management of all MS SQL objects: creating/dropping databases; creating/dropping/altering tables, views, procedures, etc.
• Creating/dropping/altering all the table subobjects
• Viewing/editing data in tables
• Support of all MS SQL field types
• Multiple database connections
• Powerful Login Manager and Grant Manager
• SQL Editor with syntax highlight
• Visual Query Builder
• Powerful BLOB Viewer/Editor that provides several ways of viewing BLOB data
• Export data to 14 popular formats, including MS Access, Excel, RTF (Word), HTML, etc.
• Import data from most popular formats, including MS Excel, Access, etc.
• Customizable program interface
• Detailed Help System and User's Guide

and more...

Scroll to top

 

---