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

SQL Manager Lite for SQL Server Changelog

What's new in SQL Manager Lite 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 Lite for SQL Server 5.0.6 Build 55900 (Aug 22, 2022)

  • The ability to connect to the server without checking the server certificate, rebuilding views, correcting data import errors and many other fixes and improvements.

New in SQL Manager Lite 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 Lite 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 Lite 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 Lite 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 Lite 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 Lite for SQL Server 4.4.0 Build 48967 (Mar 13, 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 Lite 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 Lite 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 Lite 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 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 Editor tab the wrong Help page was opened. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager Lite for SQL Server 3.8.0.1 (Apr 18, 2012)

  • Added support of new SQL Server 2012 features:
  • Support of sequences.
  • Support of custom server roles.
  • Support of columnstore indexes.
  • Support of FileTables.
  • Support of contained databases.
  • Added support of spatial indexes (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 Option. 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 indexes, 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.

New in SQL Manager Lite 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 Lite for SQL Server 3.6 (Jun 28, 2010)

  • 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 minor improvements and bug-fixes.

New in SQL Manager Lite for SQL Server 3.5.0.5 (May 6, 2010)

  • 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 into the editor’s area.
  • The file encoding selected in the Open/Save file dialog is saved and then used when opening/saving files next time.
  • When using comments like /** ... **/, the text after the block was highlighted like comments. Fixed now.
  • SQL Editor:
  • If a file name and location were too long for the window title the utility used to cut the filename. Now it cuts the file location.
  • XML fields values were sometimes not displayed when connecting through the Native Client. Fixed now.
  • If the last line of the executed query contained comments, the query did not return record set. Fixed now.
  • The Ctrl+D shortcut is added for the Show Results on Edit Tab command.
  • With the certain option combination set, all queries resulted in “0 records fetched”. Fixed now.
  • SQL Script. If a file name and location were too long for the window title the utility used to cut the filename. Now it cuts the file location.
  • 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.
  • Certificates 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 the Windows Vista error 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 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. Fixed now.
  • 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 schema 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 the Job Editor if the connection to a database with the case sensitive collation was established. Fixed now.
  • Other minor improvements and bug-fixes

New in SQL Manager Lite for SQL Server 3.4.0.7 (May 6, 2010)

  • The following SQL Server 2008 feature is now supported:
  • Resource Governor.
  • Support of 'FOR XML' clause in queries used to return results as XML instead of standard rowsets.
  • Using macro is now possible in SQL Editor and SQL Script.
  • Data View | Blob View: the XML tab has been added allowing to view XML data as a tree.
  • The Unicode support is implemented in procedure/function bodies, views, triggers, check constraints, object description, field default values and in a number of other object properties.
  • Grant Manager:
  • Support of database permissions for SQL Server 2005 and higher has been added.
  • Users and roles are now separated in the 'Privileges for' list.
  • 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.
  • A possibility to select the OLE DB Provider: OLE DB Provider for SQL Server or SQL Native Client has been added.
  • Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
  • 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.
  • Several errors concerning syntax highlight have been fixed.
  • Several bugs concerning incorrect parsing of table aliases in queries have been fixed.
  • The Ctrl+Alt+C shortcut did not work for showing the list of fields of the table whose name was 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.
  • The possibility to execute procedures and user-defined functions directly from DB Explorer (through the context menu) has been added.
  • The program now 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 has been added to the Search Panel toolbar.
  • Double-clicking an object group node folds and unfolds its branch.
  • When adding a server object, only this new object was displayed in the tree if the branch had not been refreshed yet. 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. Fixed now.
  • Options: the ability to apply default settings (to all or just to a separate category of options) has been implemented for all option dialogs.
  • Windows List: the 'Close All Database Windows' command has been 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: support of the 'Write log to table' option and new subsystems of SQL Server 2008 have been added.
  • 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 overwriting the file or making the new file unique by adding the current date and time to the file name.
  • Environment Options | Tools | SQL Server Reference: an option for SQL Server 2008 Books Online has been added.
  • Full-Text Catalog Editor:
  • The data type value of a full-text index was not applied on saving the object. Fixed now.
  • When saving changes, pressing Cancel in the Changing Metadata window resulted in losing changes in the editor. Fixed now.
  • The DDL of user-defined functions did not contain field comments 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 Lite for SQL Server 3.3 (May 6, 2010)

  • 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 into a query, its foreign key connections 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 server object selection resulted in opening a single editor. Fixed now.
  • The warning that the database compatibility level is not maximized can be disabled now.
  • SQL Assistant. The Edit objects command didn’t work with server objects. Fixed now.
  • Database Registration Info. The “Schema-organized database tree” option is added; disabling this option makes SQL Manager create the object tree without schema division.
  • Database Properties. The information about the database owner 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 from the existing database when restoring it.
  • HTML Report. The possibility to change font size for the DDL section is added.
  • Changing metadata window can now be closed by pressing the ESC button.
  • The Access Violation error appeared sometimes when deleting 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 didn’t appear if the object name was put into square brackets. Fixed now.
  • Visual Database Designer. Some printers couldn’t print field and table icons. Fixed now.
  • Table Editor. The Property tab couldn’t be refreshed. Fixed now.
  • An attempt to connect to SQL Server 2005 database with compatibility level 8 led to an error; contacts 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 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. Fixed now.
  • Other small improvement and bugfixes.

New in SQL Manager Lite for SQL Server 3.2 (May 6, 2010)

  • 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. After refreshing the content, filtering options used to be reset. 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 reset. 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.
  • 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 Lite for SQL Server 3.1 (May 6, 2010)

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

New in SQL Manager Lite 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...