Softpedia >Windows >Internet >Servers >Database Utils >SQL Manager for SQL Server >  Changelog

SQL Manager for SQL Server Changelog

What's new in SQL Manager for SQL Server 5.1.0 Build 56643

May 5, 2023
  • Compatibility level for SQL Server 2022 added.
  • Connection issues fixed for Azure Managed Instance.
  • Increased performance for Dependency Tree.
  • Dependencies tree fixed for XML Schema Collections.
  • Improved work with BLOB editor.
  • Wizard templates are now saved in UTF8.
  • Scaling improved in DB Designer editor.
  • The issue with displaying Unicode parameters in tables fixed.
  • The new scheme name was missing in Duplicate wizard in some cases. Fixed now.
  • Commit after all records is now set by default in Import data wizard.
  • Unicode strings in DB properties are now processed correctly.
  • Selected data is not reset on moving between steps in Statistics Update and Indices Management Wizards.
  • Incorrect applying of On All group actions on Permissions tab in object editors fixed.
  • Many other fixes and improvements.

New in SQL Manager for SQL Server 5.0.6 Build 55882 (Aug 17, 2022)

  • Added option to connect to the server without checking its certificate.
  • The ability to rebuild views has been added.
  • The ability to rebuild metadata of dependent views after making significant changes in table fields added.
  • Fixed errors when importing data from some XML files.
  • XML data was not filled in correctly for Path in Data import wizard. Fixed now.
  • Dependent objects were incorrectly displayed in the Dependency Tree for role synonyms. Fixed now.
  • Other changes and improvements.

New in SQL Manager for SQL Server 5.0.5 Build 55299 (Jan 20, 2022)

  • Editor tabs can be now highlighted with the specific DB color.
  • Improved processing of dependencies in large databases.
  • Incorrect copying of Null cells from tables grid fixed.
  • Field name was modified in Duplicate table wizard if it was the same as table name. Fixed now.
  • Seed property for identity fields was set to 0 instead of 1. Fixed now.
  • BIGINT data types are now exported correctly into XLS and XLSX fils.
  • Other minor fixes and improvements.

New in SQL Manager for SQL Server 5.0.4 Build 54454 (Nov 2, 2021)

  • Support for compatibility level 15 added.
  • Custom toolbars are no longer removed.
  • Query plan resulted in error on second execution in Query Builder. Fixed now.
  • Memory-optimized table parameters are displayed correctly now.
  • Minor fixes and interface improvements.

New in SQL Manager for SQL Server 5.0.3 Build 53390 (Dec 17, 2020)

  • Desktop was not restored correctly if server name contained non-Latin characters. Fixed now.
  • 'List index out of bounds' error occured on filtration if connection was lost. Fixed now.
  • The main menu disappeared with some specific localizations used. Fixed now.
  • Default values are now set correctly on client side.
  • Deafult names for tables didn't apply current schema. Fixed now.
  • Confirmation was added for closing all editors.
  • 'Invalid variant type' error on editing datetime2 data in SQL Azure fixed.
  • Now the number of fetched records is displayed right in Load visible rows mode.
  • Other minor fixes.

New in SQL Manager for SQL Server 5.0.0 Build 51680 (Oct 5, 2018)

  • Dark visual schema added.
  • Added new objects of SQL Server 2017, Azure SQL and Azure Datawarehouse:
  • External table
  • DB Scoped Credential
  • External file format
  • Graph table
  • Support for Amazon RDS for SQL Server implemented.
  • MS OLE DB provider for connecting to SQL Server has been updated.
  • Unicode object names are supported now.
  • Improved support of high-DPI monitors and large-scale fonts added.
  • Objects can be now added to the Favorites node from the popup menu.
  • Encryption algorithms for symmetric and asymmetric keys have been updated.
  • Now it's possible to view object creation and modification date.
  • Code completion has been improved.
  • Format set in Color & Formats was not applied. Fixed now.
  • Many other improvements and bug-fixes.

New in SQL Manager for SQL Server 4.4.1 Build 49818 (Jul 5, 2017)

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

New in SQL Manager for SQL Server 4.4.0 Build 48936 (Mar 8, 2017)

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

New in SQL Manager for SQL Server 4.3.0 Build 47830 (Sep 15, 2016)

  • 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.
  • The possibility to browse PDF has been implemented in BLOB Editor.
  • The algorithm for Code Completion list has been improved.
  • Now information messages and errors in the dialogs can be copied with Ctrl+C.
  • Applying of Schema-organized database tree option is performed without reconnect now.
  • SQL Editor. The results of the query without key fields couldn’t be edited. Fixed now.
  • Now you can drag-and-drop triggers to set breakpoints in Debugger.
  • ‘Out of memory’ error has been fixed in Extract database wizard.
  • The query executing couldn’t be cancelled in ‘Open server cursor’ and ‘Asynchronous query’ execution modes. Fixed now.
  • The error on loading VARBINARY data has been fixed.
  • The tables containing ‘Space’ symbol were processed incorrectly in Query Builder. Fixed now.
  • DropCreate statements were generated in Index Editor even if no changes were made. Fixed now.
  • Code Completion list didn’t appear for functions and procedures with database name added. Fixed now.
  • Many other fixes and improvements.

New in SQL Manager for SQL Server 4.2.2 (Sep 15, 2016)

  • Some performance issues have been resolved: slow connection and services launch on some specific client configurations.
  • Data Frame. Cells were filled with empty strings instead of default values when a new row was added. Fixed now.
  • Defaults and computed fields definitions were truncated in table DDL. Fixed now.
  • Data Frame. Incorrect sorting and filtering has been fixed for the case when data was loaded partially.
  • Favourite Queries were not shown when ODBC connection was used. Fixed now.
  • The procedures were executed twice in Procedure Editor. Fixed now.
  • Many other improvements and bug-fixes.

New in SQL Manager for SQL Server 4.2 (Sep 15, 2016)

  • ODBC driver support has been implemented to ensure best compatibility with all server versions.
  • Support of privileges for Routes, Message Types, Services, Service Bindings and Queues has been added.
  • Support of new Full-text Indices properties has been added.
  • Corresponding Registry settings are cleaned up on unregistering the database.
  • The error on applying Quick Filter for Decimal fields has been fixed.
  • Ctrl+O hot key added for focusing the currently edited object in the DB Explorer tree.
  • Object editors can be opened from Grant Manager by double-clicking now.
  • Other improvements and bug-fixes.

New in SQL Manager for SQL Server 4.1.1 (Sep 15, 2016)

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

New in SQL Manager for SQL Server 4.1.0 Build 45480 (Mar 27, 2015)

  • Support of Azure SQL Database.
  • 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.
  • DB Explorer.
  • Type of field and nullability are now displayed in DB Explorer tree.
  • Favourite queries and scripts may be added into “Favourite Objects” folders.
  • 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.
  • Dependency Tree, Dependency tab in object editors. Now dependencies on external and dropped objects are shown (for SQL Server 2008 and higher).
  • Export Data as SQL Script, Extract Database. Now in the field ‘Script destination | File charset’ the last charset saved is chosen.
  • Restore Database wizard. Now the name of the restoring database is displayed in the form header.
  • DDL Trigger Editor, Server Trigger Editor. Events are sorted in alphabetic order.
  • SQL Monitor. Now parameter values, used at query/procedure run, are also displayed in the log.
  • Data Grid:
  • 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.
  • Login Editor. Refresh didn’t work in the User Mapping tab. Fixed now.
  • 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.
  • Attach Database, Detach Database wizards. Some passwords were encoded wrong on saving the template. Fixed now.
  • DB Explorer. If you enable the 'Sort by aliases' option table fields were sorted as well. Fixed now.
  • At opening the Database Properties dialog for the disconnected database, the value of the database owner was not displayed. Fixed now.
  • SQL Script. At saving the script was scrolled up to the beginning. Fixed now.
  • A lot of other small improvements and bug fixes.

New in SQL Manager for SQL Server 4.0.0 (Mar 27, 2015)

  • 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.
  • Added the Database Comparer tool which allows getting a script to synchronize the database structure.
  • Added support of new SQL Server 2014 features:
  • Support of memory-optimized tables.
  • Support of backup encryption.
  • Support of backup to Windows Azure.
  • 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.
  • Added the ability to create SELECT/INSERT/UPDATE/DELETE procedures from tables and views easily.
  • Visual Database Designer:
  • 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.
  • DB Explorer:
  • 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.
  • HTML Report:
  • 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.
  • Added the Instance Manager tool which allows checking statuses of SQL Server services and starting/stopping them.
  • Added the Database Registration Manager which allows adding and deleting database registrations quickly.
  • 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.
  • Environment Options:
  • 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.
  • Dependency Tree:
  • 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.
  • Windows panel:
  • 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.
  • Table Editor. Data tab:
  • 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.
  • Object names in DDL are not quoted now, if it is not necessary.
  • Export/Import Data. Now in most cases exported data is not re-requested from server.
  • Procedure and Function Editors. It is possible to set use of default parameter values when executing procedures/functions.
  • SQL Formatter now allows formatting DDL statements.
  • SQL Editor. Now the query execution time is displayed more accurately with no additional cost in the program itself.
  • Indices Management, Update Statistics, Shrink Database and Check Database wizards are non-modal now; operation is executed in a thread.
  • Visual Options. Added the possibility to set Slants Kind property value for page controls.
  • 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.
  • Some of the forms were not scaled in Control Panel\Display | Size of All Items - Medium mode. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager for SQL Server 3.9.0.1 (Aug 27, 2013)

  • 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 catalog, 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 Editor tab the wrong Help page was opened. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager for SQL Server 3.7.0.2 (Nov 30, 2011)

  • 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 '..', 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.

New in SQL Manager for SQL Server 3.6.0.1 (Nov 30, 2011)

  • 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

New in SQL Manager for SQL Server 3.5.0.5 (Jun 23, 2010)

  • Added the possibility to extract system objects, a lot of different improvements and enhancements

New in SQL Manager for SQL Server 3.4.0.2 (Jun 2, 2009)

  • SQL Server 2008 features are now supported
  • The possibility to reorder hosts using drag-and-drop is implemented
  • The ability to edit the result of a query containing JOIN statements is implemented and much more

New in SQL Manager for SQL Server 3.4.0.1 (Jun 2, 2009)

  • 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

New in SQL Manager for SQL Server 3.2.0.2 (Aug 16, 2008)

  • Service Broker support. Now all Service Broker objects are supported: message types, contracts, queues, services, routes, remote service bindings.
  • SQL Server 2008 support.
  • Support of new data types: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography.
  • Support of table types is implemented. Table types are displayed at the UDTs branch within the DB Explorer tree.
  • Backup Database wizard now supports new backup parameters such as compression, buffer count, max transfer size.
  • Support of logon triggers is 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 to 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 quicker 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 a database the compatibility level is checked; and the prompt for changing it is displayed, 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 fixes
  • Dependency tab fixes
  • Location of toolbars within the program main window have been fixed
  • 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.
  • Data Export. 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 occurred on attempt to connect to a database using the password which contained punctuation marks.
  • Many other small improvements and bugfixes.

New in SQL Manager for SQL Server 3.0.0.1 (Nov 28, 2007)

  • Server Log Viewer
  • Activity Monitor
  • Shrink Database
  • Check Database
  • Update Statistics
  • Unicode support
  • support of symmetric keys and asymmetric keys
  • certificates
  • full-text catalogs and indices
  • endpoints, database snapshots
  • improved SQL Editor

New in SQL Manager for SQL Server 2.2 (Apr 25, 2006)

  • SQL Formatter is implemented, Query execution plan is now displayed as a graphical diagram, other improvements and bugfixes...