Softpedia >Windows >Internet >Servers >Database Utils >dbForge SQL Complete Standard >  Changelog

dbForge SQL Complete Standard Changelog

What's new in dbForge SQL Complete Standard 6.16.4

Apr 12, 2024
  • Improvement:
  • Integration support for SSMS 20.x
  • User-reported bug fixes:
  • Several user reported minor bugs are fixed

New in dbForge SQL Complete Standard 6.15.20 (Dec 28, 2023)

  • Code Completion improvements:
  • Added support for the CREATE TABLE AS SELECT statement in Azure Synapse
  • User-reported and internal bug fixes:
  • Fixed SSMS crash when generating quick info for typed objects like variables and functions (D134058, D130869)
  • Fixed the unnecessary addition of parentheses when inserting a synonym for a table from the dropdown list (D133432)
  • Fixed the Snippet Manager's behavior when changing the folder path for snippets (D131496)
  • Fixed a leak of open sessions that occurred when working with Azure SQL and Azure Synapse cloud servers (D128255)
  • Fixed an error that occurred when attempting to insert a snippet by pressing Tab (D127387)
  • Fixed the redundant enclosing of values in quotes when copying data in JSON format (D126998)
  • Improved the performance of hint generation when working with scripts containing a large number of aliases (D107724)
  • Fixed the Snippet Manager window display on high-DPI monitors (D130698, D133040)

New in dbForge SQL Complete Standard 6.15.5 (Jul 12, 2023)

  • Code Completion improvements:
  • Added support for the GENERATE_SERIES and OPENQUERY relational operators
  • Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT
  • Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions
  • Added support for the DATETRUNC function
  • User-reported and internal bug fixes:
  • Improved memory utilization during the processing of suggestions (D107724)
  • Fixed issues with SQL document closing or losing focus (D109291, D109290)
  • Resolved an error that occurred when analyzing invalid objects (D119419)
  • Fixed an issue with generating CRUD operations for tables (D113761, D116787)
  • Resolved an issue where Completion List suggestions were not working properly after selecting a different Azure database in the SQL document connection field (D119532)
  • Optimized the search functionality for the Go To Definition feature (D119530)
  • Fixed handling of user literals when editing a snippet (D119126)

New in dbForge SQL Complete Standard 6.14.26 (Jun 15, 2023)

  • Fixed an issue causing the Completion List window size to reset to default (D106489, D120657)
  • Fixed an issue with the debugger starting (D120432)
  • Resolved an issue where the Continue, Step Over, and Step Into buttons were occasionally disabled when breaking execution (D120864)
  • Fixed an issue with the restoration of the latest active document session when launching SSMS 18 after a previous SQL Complete update (D121214)

New in dbForge SQL Complete Standard 6.14.18 (May 12, 2023)

  • Optimized the RAM usage
  • Fixed an issue with the incomplete loading of the extension in SSMS
  • Fixed an error that could occur when integrating the application into SSMS 19.0.1
  • Fixed an error that could occur when displaying the completion list
  • Fixed a column hint for the table CTE
  • Fixed an issue with hints got missing in the completion list if the server and database had the same name
  • Fixed a logging file initialization error that occurred when launching the application
  • Fixed an issue with the auto-formatting of input words

New in dbForge SQL Complete Standard 6.14.7 (Dec 30, 2022)

  • New features and improvements:
  • Support for SSMS 19 Preview 4
  • Columns suggestion in the ORDER clause for the CREATE CLUSTERED INDEX statement
  • Added the suggestion of filegroups after the SELECT INTO ON statement (D101295)
  • Improved memory handling (D97173)
  • Improved performance of hints processing (D107724)
  • Improved formatting of SQL statements (D95432)
  • User-reported and internal bug fixes:
  • Fixed issues with Azure Active Directory - Universal with MFA authentication (D99277, D100349)
  • Fixed errors that occurred when working with synonyms when searching for invalid objects (D95074)
  • Fixed issues with the Outlining functionality in SQL Editor (D96566)
  • Fixed an error that occurred when closing the SQL document (D105404)
  • Fixed the logic for handling column aliases (D96213)
  • Fixed an error that occurred when working with statements containing the PIVOT/UNPIVOT clause (D103799)
  • Fixed an issue with formatting scripts from the command line when the QUOTED_IDENTIFIER setting is enabled (D94062,D103891, D104515, D104704, D104839, D107033, D107736, D108703)
  • Fixed a bug that occurred when renaming files in the SSDT project
  • Fixed an error that occurred when getting database objects metadata (D94077, D96694, D106956)
  • Fixed a bug that occurred when working with documents in Visual Studio 2015 (D95326)
  • Fixed an error that occurred when using Convert EXEC to script (D95992, D103255)

New in dbForge SQL Complete Standard 6.12.8 (Oct 5, 2022)

  • User-reported and internal bug fixes:
  • Fixed an error that occurred when determining the JOIN clause for the completion list
  • Fixed a bug that occurred when opening multiple SSMS instances (D98986, D98987, D98988, D98989, D99063, D99048,D99113,D99112,D99125,D99149,D99180,D99218,D99309,D99318,D99341,D99331,D99407,D99502,D99501)

New in dbForge SQL Complete Standard 6.12.6 (Sep 12, 2022)

  • New features and improvements:
  • Added support for CREATE INDEX and ALTER INDEX for SQL Server 2022
  • Added support for CREATE CLUSTERED INDEX for SQL Server 2022
  • Added support for CREATE TABLE and ALTER TABLE for SQL Server 2022
  • Added support for ALTER DATABASE SCOPED CONFIGURATION for SQL Server 2022
  • Added query hints for the DELETE, INSERT, SELECT, UPDATE, and MERGE statements
  • Added support the BACKUP SYMMETRIC KEY syntax construct
  • Added support the RESTORE SYMMETRIC KEY syntax construct
  • Added support for the DATE_BUCKET function in the Completion List, Quick Info, and Parameter Information
  • User-reported and internal bug fixes:
  • Fixed an error that occurred when starting the application (D91581, D91540, D91539, D91538, D91534, D91476, D91455, D91621, D91632, D91744, D91758, D91794, D91880, D91944, D92111, D92336, D92333, D92365, D92608, D92739, D94477, D94480, D94479, D94491, D94478, D94491, D94565, D94496, D94452, D94590, D94755, D95092, D95147, D95283)
  • Fixed an error that occurred at the end of the debugging process

New in dbForge SQL Complete Standard 6.11.5 (Jul 20, 2022)

  • Fixed an error that might occur when a computer entered sleep mode (D86220)
  • Fixed an issue with switching the active window in VS to the Debug window and vice versa (D84789, D85060, D85059, D85870, D86220, D86996, D89262, D89720, D89769, D89770, D89768, D90910, D90949, D91678, D9208)

New in dbForge SQL Complete Standard 6.11.3 (Jun 25, 2022)

  • New features and improvements:
  • SSMS v19 Preview 2 integration is added
  • User-reported and internal bug fixes:
  • Fixed an application error that occurred when starting SSMS 2014
  • Fixed the display of data in Data Viewer when changing the order of columns in the Editor
  • Fixed an error that might occur when opening documents
  • Fixed an issue with displaying Quick Info on an incomplete script
  • Fixed an issue with missing hints for Linked Server objects
  • Added temporary table hints that do not depend on the selected database
  • Fixed the problem with incorrect formatting of procedure parameter names
  • Fixed an unexpected exception that might occur when copying data to the clipboard (D89130)
  • Fixed the reset of tabs color settings after closing SSMS with SQL Complete activated (D85351)
  • Fixed an issue with setting the database name in the Query Editor window when starting SSMS using the -d argument ** (D81862)
  • Fixed the disappearance of the Document Outline window (D81156)
  • Fixed an error that occurred when starting SSMS (D87321, D89325, D90091, D90192, D90396, D90381, D90374, D90368)
  • Fixed memory leak issue that occurred when executing large scripts (D89598, D90100)

New in dbForge SQL Complete Standard 6.10.5 (Apr 4, 2022)

  • New features and improvements:
  • Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
  • Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function
  • User-reported and internal bug fixes:
  • Fixed an unexpected exception that occurred when renaming a table in a project (D71664)
  • Fixed an issue caused by SQL Complete catching a Data Pump exception (D73031)
  • Fixed an issue that occurred when applying tab caption changes in new files (D72179)
  • Fixed an issue that occurred during image rendering (D70859)
  • Fixed an issue with the access to the docsessions.db file (D76130, D79522, D79628, D79672, D79797, D80034)
  • Fixed the behavior of collapsing a BEGIN statement that contains a comment (D76438)
  • Fixed an issue that occurred when running the Execute Current Statement command
  • Fixed an issue that occurred when running SQL Complete on machines with the FIPS mode enabled (D57615, D58569, D74254, D74257, D74255, D74256, D75140, D75179, D75709, D75926, D76060, D77975)
  • Fixed an issue that occurred during script execution
  • Fixed a document restoration issue that occurred when running SQL Complete (D69818)
  • Fixed an issue that occurred when scrolling a script in a document (D71747)
  • Fixed issues with suggestions in SSDT projects (D72730, D73026, D77631)
  • Fixed an issue that occurred when filling the server object cache (D74580)
  • Fixed an issue with the simultaneous launch of multiple SSMS instances with SQL Complete installed (D77606)
  • Fixed an issue with the simultaneous script processing in background threads (D79411)
  • Fixed a quoting issue that occurred when pasting collation names from a list (D79549)
  • Fixed a reactivation issue on Windows 11 (D73474, D76566)

New in dbForge SQL Complete Standard 6.9.34 (Jan 31, 2022)

  • Fixed an issue that occurred when navigating to the document from the execution notification window
  • Fixed an issue that occurred when retrieving machine configuration details for an error report
  • Fixed an issue that occurred when formatting single-line queries
  • Fixed an issue that occurred when loading an assembly
  • Fixed an unexpected exception that occurred when working with the Document History
  • Fixed an issue that occurred when closing the application
  • Fixed an issue that occurred when closing documents
  • Optimized the retrieval of object information from the server, removed unnecessary sorting

New in dbForge SQL Complete Standard 6.9.28 (Nov 15, 2021)

  • Fixed an issue with opening a SQL document from a Microsoft Visual Studio project (Z67752, Z67753)
  • Fixed an issue that occurred when working with SQL documents related to Visual Studio projects
  • Fixed an issue with loading the SQL Complete assembly after launching SSMS (Z67302)
  • Fixed an issue that occurred when working with variables in the SQLCMD mode (Z69913)
  • Fixed an issue that occurred when working with the CREATE SCHEMA statement in the SQL editor (Z70235)
  • Fixed an application launch issue (Z67651)
  • Fixed a document session restoration error (Z68594, Z68627, Z68638)

New in dbForge SQL Complete Standard 6.9.16 (Oct 5, 2021)

  • New features and improvements:
  • CONSTRAINT suggestion support for ALTER TABLE statement
  • Suggestion of UPDATETEXT
  • DISTRIBUTED_AGG support for SELECT — GROUP BY
  • ALTER/DROP DATABASE SCOPED CREDENTIAL support
  • Support of Configuration Options for Query Store feature for ALTER DATABASE
  • WAIT_AT_LOW_PRIORITY support for ALTER TABLE … SWITCH PARTITION
  • New keywords support for ALTER DATABASE SCOPED CONFIGURATION
  • Support of CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE (for Azure SQL)
  • ALTER SERVER CONFIGURATION support for MEMORY_OPTIMIZED options
  • User-reported and internal bug fixes:
  • Bug when working with the Output window (Z65144, Z67117)
  • Bug when closing SSMS with an active debugging session
  • Bug when parsing scripts in the project (p195696, Z58854)
  • Bug with SSMS that is not responding when working with multiple instances running simultaneously (Z62848)
  • Bug with showing the Manual Activation button (Z48827)
  • Error when loading dependent assembly for execution history
  • Error while loading the application cache file (Z65159)
  • Incorrect processing of an exception when connecting to the server with an already unloaded module of SQL Complete (Z62505)
  • Incorrect processing of an exception in execution history when the module of SQL Complete has already been unloaded
  • Integration error when starting SQL Complete (Z63459)
  • Inserting an empty line between ELSE and IF when formatting with the Add empty lines around IF statement option (Z65694)
  • Tooltip of the view columns, the DDL of which can be located above in the current script or project (T291005)
  • Work of the Code Outlining functionality in SSMS v18 (Z60089)

New in dbForge SQL Complete Standard 6.8.20 (Aug 13, 2021)

  • Issue with opening a new document in SSMS (Z58493)
  • Issue with writing execution history (Z58635, p195748, Z62563, u43772238)
  • Issue with formatting GRANT EXEC (Z59763)
  • Error with deleting the application because of the absence of access to the document folder of the current user (T316649)
  • Issue with non-working 'Add parentheses when inserting functions' option in Standard edition (p195628)

New in dbForge SQL Complete Standard 6.7.13 (Mar 11, 2021)

  • Copy HTML to clipboard did not format the clipboard as HTML (Z49495)
  • Possible add-in failure when displaying loads of query execution result
  • The objects just created within an SQL document were missing from completion list after opening a new query window (T318722)

New in dbForge SQL Complete Standard 6.7.5 (Feb 8, 2021)

  • New features:
  • Suggestion of COLUMN MASTER KEY
  • Suggestion of COLUMN MASTER KEY in CREATE COLUMN ENCRYPTION KEY
  • Suggestion of ALGORITHM in CREATE COLUMN ENCRYPTION KEY
  • Support for the "Go To Definition" feature for COLUMN MASTER KEY
  • Support for the "Script Object as CREATE/ALTER" feature for COLUMN MASTER KEY
  • Suggestion of PERSISTENT_LOG_BUFFER=ON ( DIRECTORY_NAME='' ) in CREATE DATABASE
  • Suggestion of DBCC SHOW_STATISTICS
  • CRUD generation is wrapped to the regions
  • User-reported and internal bug fixes:
  • When describing database objects, SQL Complete blocked some other queries from being executed on a server (T323445)
  • Incorrect formatting for the nested BEGIN/END blocks (T320336)
  • The NOEXPAND table hint was not recognized by the syntax checker (T321765)
  • Possible failure when trying to display images within Data Viewer (T319013)
  • Incorrect conversion of editor screen coordinates to text position in specific circumstances led to critical errors (T319950)
  • The INSERT statement was expanded incorrectly for tables defined in a scope of a script (T322202)
  • Incorrect behavior of the Document Outline window in specific cases (T323758)
  • Variables were missing from the completion list after the FETCH NEXT clause
  • The "File not found" errors when renaming scripts within Visual Studio projects after switching between projects (T320072)
  • Possible critical errors when calculating parameter info, quick info, and code completion items

New in dbForge SQL Complete Standard 6.6.12 (Sep 16, 2020)

  • User-reported and internal bug fixes:
  • SSMS was hanging when navigating through scripts with lots of temporary tables (T313440)
  • Columns that had multiple description properties specified were duplicated within the completion list (T316667)
  • SSMS was hanging when trying to rename an alias (T316057)
  • Incorrect quotations when exporting data to CSV format (T316919)
  • The 'OBJECT_ID' was present in the completion list twice
  • A CSV file with exported data was created as UTF-8 regardless of the state of the 'Use Unicode' option
  • Function parameters information hint could be displayed in a wrong position and/or with inaccurate contents
  • It was impossible to cancel formatting via the wizard

New in dbForge SQL Complete Standard 6.6.7 (Sep 1, 2020)

  • New features:
  • Column sensitivity classification information is available in the completion list and quick info. The statements to add and drop such classifications are asso suggested in the completion list.
  • The export settings for CSV file format is added
  • An option to tune the accuracy of decimals for Grid Aggregate is added
  • An export Execution History to CSV file format is added
  • Converting stored routines execution into a script for procedures with incomplete parameters or with no parameters specified is implemented
  • User-reported and internal bug fixes:
  • An autosuggestion will not start listing the code snippets instead of the table names in the SELECT statement if a table is more suitable (T314629)
  • SSMS was hanging when scrolling through large scripts (T314167)
  • The invalid script was generated by the 'Convert Exec to Script' action in case the procedure parameters contained flag attributes
  • The keyboard navigation within the completion list stopped working after disabling and then re-enabling code completionn
  • The 'Script Object as CREATE/ALTER' action fails with a critical error on specific database triggers
  • The 'Script Object as CREATE/ALTER' did not work with the user-defined aggregate functions
  • The completion list was not displayed for disconnected SQL documents in specific cases
  • Quick info will not been displayed for inactive IDE

New in dbForge SQL Complete Standard 6.5.48 (Aug 18, 2020)

  • User-reported and internal bug fixes:
  • The most recently used connections list was broken after restoring a disconnected document. (T315664)

New in dbForge SQL Complete Standard 6.5.38 (Aug 3, 2020)

  • Issue with restoring connection for cached documents in add-in due to the error when running SSMS 18.6 (T315034, T315036)
  • Missing hard brackets on object schema name when generating ALTER scripts for procedures and functions under the caret (T309129)
  • Improper work of code completion for SELECT queries without alias in the Express edition of the add-in (T314328)
  • Absence of a table declared in an SQL file in completion list in case if the document is not currently connected to a server
  • Critical failure of the add-in when trying to format SQL files larger than 200 MB
  • Unavailable regions outlining when the code completion functionality is disabled
  • Duplicate listing of the 'dbo' schema in the completion list in a newly created SQL document
  • Possible display of confirmation message boxes in the installation setup launched in the 'verisilent' mode during update in specific circumstances

New in dbForge SQL Complete Standard 6.5.27 (Jul 10, 2020)

  • Other User-reported bugs are fixed

New in dbForge SQL Complete Standard 6.5.23 (Jun 10, 2020)

  • New features:
  • Full support for SQL Server 2019
  • SQL Complete Standard Edition is introduced
  • Properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.) suggestion
  • Temporary tables suggestion is introduced
  • OPENJSON objects suggestion is introduced
  • Support for the following functions is added:NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT and PWDCOMPARE
  • Support for the following SQL statements: GRANT ALTER ANY SECURITY POLICY, GRANT ALTER ANY SENSITIVITY CLASSIFICATION, GRANT ALTER ANY DATABASE SCOPED CONFIGURATION, GRANT ALTER ANY COLUMN MASTER KEY, GRANT ALTER ANY COLUMN ENCRYPTION KEY, GRANT EXECUTE ANY EXTERNAL SCRIPT, GRANT ALTER ANY EXTERNAL DATA SOURCE, GRANT ALTER ANY EXTERNAL FILE FORMAT, GRANT ALTER ANY EXTERNAL LANGUAGE, GRANT ALTER ANY EXTERNAL LIBRARY, GRANT ADMINISTER DATABASE BULK OPERATIONS
  • Expanded support for the function PREDICT for SQL Server 2019 is added
  • Expanded support for the following statements is added: CREATE USER for Azure SQL Database, CREATE INDEX for SQL Server 2019, CREATE EXTERNAL LIBRARY for SQL Server 2019, ALTER DATABASE for SQL Server 2019, ALTER TABLE for SQL server 2019, ALTER EXTERNAL LIBRARY for SQL Server 2019, ALTER AVAILABILITY GROUP for SQL server 2019, DROP EXTERNAL RESOURCE POOL for SQL Server 2019, DROP EXTERNAL LIBRARY for SQL Server 2019, ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
  • SSMS v18.5 integration is added
  • User-reported bug fixes:
  • Other User-reported bugs are fixed (T308215, T307877, T306055)

New in dbForge SQL Complete Standard 6.4.28 (Mar 18, 2020)

  • User reported bug fixes:
  • Problem with formatting is fixed (T303611)
  • Problem with installation is fixed (T305633)
  • Problem with splitter in SQL document is fixed (T305719, T305967, T306248, T306276, T306801, T306914, T306914)
  • Problem with reactivation is fixed (T305847)
  • Other user reported bugs are fixed (T305831,T306061,T306842)

New in dbForge SQL Complete Standard 6.4.15 (Feb 20, 2020)

  • New features:
  • Code Debugger
  • Copying results from the Aggregate Panel
  • Modified HELP for Command Line
  • User reported bug fixes:
  • Problem with start SSMS is fixed (T284066)
  • Other user reported bugs are fixed (T303611, T303611, T304090, T302930)

New in dbForge SQL Complete Standard 6.3.16 (Dec 19, 2019)

  • New feature:
  • New formatting profiles added (Collapsed, Commas before, Indented, Right aligned, Compact, Extended, and MSDN SQL)
  • User reported bug fixes:
  • Problem with rename alias is fixed (T292967)
  • Problems with incorrect the registry key editing is fixed (T293877, T294018)
  • Other user reported bugs are fixed (T284510, T284651, T284717, T284861, T284912, T285155, T285200, T285567, T285902, T286441, T289183, T289637, T289997, T290886, T292531)

New in dbForge SQL Complete Standard 6.2.37 (Oct 31, 2019)

  • Problems with SSMS crash are fixed (T293381, T293220)
  • Problem with sending Trace Log is fixed (T292916)
  • Problems with incorrect formatting IsNull() are fixed (T294456, T297203, T297196)

New in dbForge SQL Complete Standard 6.2.23 (Oct 1, 2019)

  • New features:
  • Support for the MIN_ACTIVE_ROWVERSION function
  • The Extend Insert Highlight Occurrences feature to show a popup with a column name in the values area
  • Displaying MS_Description for the Azure objects
  • Suggesting properties for the built-in metadata functions (SERVERPROPERTY, FILE PROPERTY, DATABASEPROPERTYEX, etc)
  • Prompting times zones in AT TIME ZONE
  • Prompting hints for option(use hint(->
  • Prompting objects in the context of DBCC SHOW_STATISTICS
  • Prompting indexes in WITH(INDEX(->
  • GENERATED ALWAYS AS ROW START in CL
  • Displaying propertynames for the SERVERPROPERTY functions
  • Support for the DBCC CHECKIDENT construct
  • Exclusion of IDENTITYCOL, $IDENTITY when unfolding asterisk
  • Jumping between BEGIN TRY/END TRY и BEGIN CATCH/END CATCH
  • Jumping between CASE и END
  • User reported bug fixes:
  • Problem after SQL Complete turning off is fixed (T288899)
  • Problem with alias and column name is fixed (T286335)
  • Problem with incorrect code formatting is fixed (T284847)
  • Other user reported bugs are fixed (T251508, T197848, T251458, T289149, T285628, T281971, T284642, T281815, T284722, T285768, T289616, T292368, T284493, T284510, T284963, T285414, T285848, T286328, T290183)

New in dbForge SQL Complete Standard 6.1.72 (Jun 10, 2019)

  • User reported bug fixes:
  • Problems with SSMS crash are fixed (T280148, T283680)
  • Problems with Documents Restore functionality are fixed (T283543, T283573, T283605, T283638, T283882, T283916, T283982)

New in dbForge SQL Complete Standard 6.1.59 (May 21, 2019)

  • User reported bug fixes:
  • Problems with 'SQL Complete Package' extension loading are fixed (T270142, T270203
  • Problem with text editor freezing is fixed (T264017
  • Problems compatibility with VS2019 are fixed (T277927, T277060
  • Auto complete problem with CASE statement is fixed (T264017

New in dbForge SQL Complete Standard 6.1.13 (Mar 26, 2019)

  • New features:
  • Visual Studio 2019 Support
  • SQL Format Command Line
  • Summary Panel Visibility
  • User reported bug fixes:
  • Problem with aggregate panel is fixed (T276755)
  • Problem with formatting UPDATE statement is fixed (T275246)
  • Problem with formatting case-sensitive object names is fixed (T274277)
  • Other user reported bugs are fixed (T274915, T270005)

New in dbForge SQL Complete Standard 6.0.136 (Feb 12, 2019)

  • Problems with SSMS launching after SQL Complete installed are fixed (T272455, T273089, T274274, T274284, T272455, T274630, T274985)
  • Problem with establishing a connection to Azure SQL is fixed (T270260)
  • Problem with a completion list is fixed (T273175)
  • Problem with renaming a formatting profile is fixed (T273099)

New in dbForge SQL Complete Standard 6.0.101 (Dec 27, 2018)

  • User reported bug fixes:
  • New option "Automatically hide when a single cell is selected" is added (T271378, T271436)
  • Error during Snippet Manager opening is fixed (T270543)
  • Wizard installation issue is fixed (T270173)
  • Shortcuts issue is fixed (T268682)

New in dbForge SQL Complete Standard 6.0.69 (Nov 26, 2018)

  • SQL Server support:
  • Connectivity Support for SQL Server 2019
  • The latest SQL Server Management Studio v18.0 Public Preview 5 integration support
  • Find in Results Grid:
  • Invoke Search panel instantly with a new shortcut
  • Execution Notification:
  • Days are displayed in execution notification
  • SQL Formatter:
  • Description for disabling formatting is added in the 'Options' window
  • Code Snippets:
  • Sort snippets in Snippets Manager
  • Grid Aggregates:
  • Multiple Columns Grid Selection for Grid Aggregates Panel
  • Option to make Grid Aggregates row permanently visible
  • Support for the date/time and string data types MIN/MAX
  • Separation with Space is added for the results of the aggregate functions in the status bar
  • Execution Warning:
  • Analyze DROP statement
  • Analyze USE statement
  • No warnings for part of the Script
  • Tabs Color:
  • Status bar coloring in addition to tabs color
  • Objects Explorer coloring in addition to tabs color
  • Ability to assign different tab colors for the databases belonging to the same connection
  • SQL Document:
  • Items are rearranged in the popup menu for better usability
  • Proportional tab widths and the ability to control what was displayed in the tab name
  • Other Improvements:
  • The Express Edition will be activated after Standard Edition trial expires
  • User reported bug fixes:
  • Problems with opening big files are fixed (T266832, T266833)
  • Navigation issue is fixed (T247158)
  • Command "Convert EXE to Script" issues are fixed (T266066, T266355)
  • Quick Info issues in Express Edition are fixed (T262357, T266349, T266838)
  • Tab Colors issue is fixed (T247550)
  • Formatting issue is fixed (T264783)
  • Problem with positioning on root element in Document Outline is fixed (T253216)
  • Other user reported bugs are fixed (T266804, T231498, T252989, T246607, T247548, T259302, T252989, T248336, T248616, T265332, T267173, T263194, T258632, T263802, T262268, T248148, T250961, T258294, T268341)

New in dbForge SQL Complete Standard 5.9.66 (Jul 19, 2018)

  • User reported bug fixes:
  • Issue with Documentation links is fixed (T259701)
  • Some problems with activation are fixed (T246023,T257072)
  • Assembly loading issue is fixed (T259851)
  • Invalid objects finding issues are fixed (T256421,T255710)
  • Problem with Convert Exec to Script is fixed (T256047)
  • Problems with NRE after freezes are fixed (T250738, T251702)
  • Other issues are fixed (T257787,T256958)

New in dbForge SQL Complete Standard 5.9.60 (May 16, 2018)

  • Connectivity feature:
  • Active Directory - Universal with MFA support
  • Code Completion features:
  • Suggestion TEMPORAL_HISTORY_RETENTION supported
  • Suggestion HISTORY_RETENTION_PERIOD supported
  • Suggestion IDENTITY_CACHE
  • Suggestion Automatic database tuning supported
  • Code Refactoring features:
  • Rename variables in UPDATETEXT supported
  • Rename variables in WRITETEXT supported
  • Rename variables in READTEXT supported
  • Rename variables in REVERT supported
  • Productivity features:
  • Results Grid Data Visualizers
  • Copy Data As from SSMS grid to XML, CSV, HTML, JSON
  • Copy Data As from SSMS grid to Clipboard
  • Copy Data As from SSMS grid to File
  • Shortcuts to SSMS grid popup menu assigned
  • User reported bug fixes:
  • Formatting issues are fixed (T220855, T251389, T251508, T255373, T252500, Т253851)
  • Script generation issue is fixed (T237590)
  • Problem with function parameters description is fixed (T247627)
  • Some issues with NRE are fixed (T251681, T251695, T252145, T252453, T253644, T254698)
  • Problems with requesting UI from the thread different from main are fixed (T247478, T248825, T250271, T251116, T251682, T252146, T252494, T254072, T254050, T254538, T254633, T256425, T248118, T248954, T250058, T250200, T247527, T248464, T252229, T254015)
  • Problem with finding invalid objects is fixed (T253855)
  • Other issues are fixed (T246508, T246674, T248305, T251429)

New in dbForge SQL Complete Standard 5.8.188 (Apr 3, 2018)

  • User reported bug fixes:
  • Numeric columns aggregation issues are fixed (T251798, T251464)
  • Others issues with NRE are fixed (T247743, T251337, T247158, T251240, T251722, T251867, T251883, T251917, T252116, T252196, T252207, T252286, T252352, T252484, T252412, T252665, T252676, T252809, T252826)

New in dbForge SQL Complete Standard 5.8.187 (Mar 16, 2018)

  • Issue with SQL Complete and SharePoint Online is fixed (T243740)
  • Issue with assembly Devart.Shell.Common.r1 is fixed (T246483,T249112)
  • Issues with formatting SQL statements are fixed (T247454, T248337)
  • Issue with creating local temp table is fixed (T246674)
  • Issue with navigating to definition is fixed (T247158)
  • Issue with opening file from WEBDAV location is fixed (T249458)
  • Issue with message "Keyword not supported: 'authtype'" is fixed (T249624, T249985)
  • Issue with license file is fixed (T248620)
  • Issue with temp table is fixed (T249623)
  • Issue with closing Visual Studio is fixed (T250533)
  • Others issues are fixed (T246552, T247367, T248266, T248140, T250155, T250281)

New in dbForge SQL Complete Standard 5.8.178 (Feb 15, 2018)

  • User reported bug fixes:
  • The operation was canceled (T247103, T247160, T247547)
  • Collection was modified; enumeration operation may not execute (T246640,T246822)
  • Issue with invalid procedures is fixed (T246490)
  • Issues with editing SQL Document are fixed (T246482, T246691, T246903, T246908, T246965, T246967, T247062, T247122, T247349, T247322, T247314, T247347, T247424, T247626, T247756, T247744, T247947, T248080, T248130, T248210, T248252)

New in dbForge SQL Complete Standard 5.8.173 (Jan 31, 2018)

  • Code Completion features:
  • Prompt extension in SQLCMD Mode
  • Display a list of CHECK and DEFAULT constraints
  • Unwrap sp_executesql
  • OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
  • XML methods suggestion XQuery
  • Support of the following statements:
  • ALTER MESSAGE TYPE
  • DROP MESSAGE TYPE
  • CREATE TYPE .. AS TABLE
  • CREATE TYPE .. FROM
  • SET DATEFORMAT
  • SEND ON CONVERSATION
  • CREATE QUEUE
  • CREATE AGGREGATE
  • CREATE ASSEMBLY FROM
  • DBCC CLONEDATABASE
  • New productivity features have been implemented:
  • Jump between BEGIN/END allows navigation through the whole block on matching keywords of the BEGIN/END statements
  • Jump between COLUMNS and VALUES in INSERT statement helps you easily find a corresponding value of the specified column in INSERT statements
  • Execution Warnings shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE
  • CRUD Generator generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document
  • Run script on multiple databases to execute a script to a new SQL document on the selected database on the connection you choose
  • Execution Notifications displays name of the document and duration when the query execution is completed
  • Transaction Reminder alerts users that a transaction has not been completed if you execute a script by clicking F5 in SSMS
  • Find in Results Grid searches the required data by highlighting all the matches either by case, or whole words, or regular expressions in the results grid
  • Copy Results Grid Headers makes a copy of the selected column names and/or types to CSV, XML, HTML, and JSON data formats
  • Grid Aggregates: selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar
  • Named Regions allows users to parse named and unnamed regions automatically, as well as wrap and unwrap regions
  • Find Invalid Objects allows users to search invalid objects in the selected database
  • Formatting Profile Quick Select allows users to quickly switch between active formatting profiles, as well as edit profiles by opening the Formatting Profiles window
  • Several fixes and improvements on Documents Sessions
  • User reported bug fixes:
  • Code Completion issues are fixed (T245079, T240827, T237465, T197850, T243299)
  • Installation and Integration issues are fixed (T157183, T243437, T244064, T244079, T244081, T244795, T237433)
  • SSMS 2014 becomes completely un-responsive issue is fixed (T233514, T234843, T235413, T235331, T235341, T238014, T240544, T241625, T242939, T244938)
  • Close All Unmodified Tabs issue is fixed (T231527, T237490, T237535)
  • Other user reported issues are fixed (T245029, T243765, Т239491, T241366, T230844, T239173, Т239166, T239841, T241228, Т241526, T239210)

New in dbForge SQL Complete Standard 5.7.210 (Nov 23, 2017)

  • Issue causing VS and SSMS restart is fixed (T235996, T236212, T236537, T237185, T237245, T237956, T235616, T238292, T238662, T238738, T238746, T238806)
  • Issue with PIVOT and UNPIVOT statements is fixed (T233205, T233336, T234152, T234538, T234706, T234711, T234823, T234837, T234873, T235854, T236216, T236775, T238127, T238218, T238347, T238500)
  • Performance issues with SSMS 2012 are fixed (T234530)
  • 'Failed to compare two elements in the array' error message fixed (T235821, T237181)
  • Issues with editing and saving some snippets are fixed (T233116)
  • Other user reported bugs are fixed (T235129, T233778)

New in dbForge SQL Complete Standard 5.7.206 (Oct 14, 2017)

  • 'Cannot access a closed Stream' error message is fixed (T233062)
  • 'Item has already been added. Key in dictionary: '-1284069302' Key being added: '-1284069302'' error message is fixed (T232607, T232867, T232923, T233058, T233221, T233231, T233311, T233472, T234424, T234422, T234191, T234540, T234569)
  • 'Begin' snippet issue is fixed (T233116)
  • Known SSMS 2014 issues are fixed (T233514, T234843)
  • Fixed issue with some sessions are not shown in Document sessions window (T234345)

New in dbForge SQL Complete Standard 5.7.200 (Sep 19, 2017)

  • Issue with disconnect connection functionality is fixed (T232398, T232451)

New in dbForge SQL Complete Standard 5.7.199 (Sep 16, 2017)

  • Integration issues are fixed (T231026, T231552, T231961, T232161, T232162)
  • Pivot issues are fixed (T232069, T232151)
  • Other fixes and improvements (T231269, T232190)

New in dbForge SQL Complete Standard 5.7.195 (Sep 6, 2017)

  • Issue with running several instances of SSMS 2012 and SSMS 2014 is fixed (T230787, T231080, T231137, T231143, T231185, T231218, T231220, T231232, T231238, T231243, T231266)
  • Issue for users with limited access to Program Data folder is fixed (T229996)
  • Other minor fixes and improvements

New in dbForge SQL Complete Standard 5.7.194 (Sep 1, 2017)

  • SQL Server support:
  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax support
  • Azure SQL Data Warehouse connectivity support
  • The latest SQL Server Management Studio v17.2 integration support
  • Code Completion:
  • Column match highlighting in the INSERT statement
  • Database element dropping from the prompt in Completion List
  • Possibility to exclude a scheme in the ON condition of the JOIN statement
  • Possibility to connect/disconnect when describing/pre-describing objects of the same database
  • Query navigation
  • CASE END pairs highlighting
  • Extended suggestion in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • CREATE OR ALTER statement support
  • Support of the following statements:
  • DROP ROUTE
  • ALTER ROUTE
  • ALTER SERVICE
  • ALTER QUEUE
  • DROP SERVICE
  • DROP CONTRACT
  • ALTER EXTERNAL RESOURCE POOL
  • CREATE PARTITION FUNCTION
  • CREATE EXTERNAL TABLE AS SELECT
  • ALTER EXTERNAL DATA SOURCE
  • CREATE REMOTE TABLE AS SELECT
  • ALTER EXTERNAL DATA SOURCE
  • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS at CREATE USER
  • CREATE (ALTER, DROP) COLUMN ENCRYPTION KEY
  • STRING_AGG
  • CONCAT_WS
  • TRANSLATE
  • TRIM
  • BULK INSERT and OPENROWSET (BULK...)
  • BLOB_STORAGE option of EXTERNAL DATA SOURCE
  • DBCC CLONEDATABASE
  • ALTER ANY MASK
  • BACKUP (RESTORE) DATABASE TO URL
  • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS
  • SQL Document:
  • New query execution history feature saves information about SQL statement you run
  • Other new features:
  • Generate Script As from SSMS grid
  • Work with Azure Data Warehouse
  • Tab Coloring
  • Get Row Count in Quick Info Window
  • User reported bug fixes:
  • Code Completion issues are fixed (T174928, T188896, T139538, T219741, T205775, T209951, T116500, T116500)
  • Visual Studio 2013/2015 Shell is supported (T214197)
  • SQL Formatter issues are fixed (T224697, T220514, T225119)
  • Tabs Management issues are fixed (T219960)
  • Other user reported issues are fixed (T227635, T229651, T229401, T228528, T221227, T229404, T218100, T228469, T228576, T228851, T224476, T226054, T227213, T227596, T226417, T219628, T212055)

New in dbForge SQL Complete Standard 5.6.169 (Jun 20, 2017)

  • Several user reported issues are fixed

New in dbForge SQL Complete Standard 5.6.163 (Jun 9, 2017)

  • "Timeout. Database is locked for more than 00:00:00" error message is fixed (T217894, T219675, T220063, T220334, T221408, T221529, T221533, T221569, T221612)

New in dbForge SQL Complete Standard 5.6.162 (Jun 7, 2017)

  • Known activation issues are fixed (T216827, T217718, T215738, T219629, T219791, T220005, T220017, T220184, T219970, T220671, T219576, T220302, T220650, T220473, T220777, T220784, T220808, T220813, T220670, T220819, T220874, T220518, T221062)
  • User reported debugging issue is fixed (T217666)
  • "Access to path 'C:usersusernameAppDataRoamingDevartdbforge SQL Completedocsessions-journal.db' is denied" error message reported by some users is fixed (T220474, T220695, T221041, T221158, T221109)
  • Several new reports with document sessions are fixed (T220338, T220647, T220513, T220917, T220942, T221030, T221104, T221089, T221179, T220337, T220475)

New in dbForge SQL Complete Standard 5.6.158 (Jun 2, 2017)

  • Failed to instantiate SqlCompleteIntegrationModule using default ctor or cast to IIntegrationModule error message reported by some users is fixed (T215756, T217003, T215679, T218233, T218746, T219029, T220766)

New in dbForge SQL Complete Standard 5.6.155 (May 29, 2017)

  • Unable to cast object of type 'LiteDB.EmptyPage' to type 'LiteDB.HeaderPage' error message when using session history is fixed (T217011, T217557, T217809, T217853, T217965, T218138, T218225, T218242, T218357, T218682, T219231, T219602, T219775, T219670, T219792, T219835)
  • Several user reported NRE are fixed (T219116, T219946, T219338, T219978)

New in dbForge SQL Complete Standard 5.6.152 (May 12, 2017)

  • Several Document Sessions issues are fixed (T215744, T217125, T217653, T218042, T218210, T215713, T215840, T216544, T217740, T217800, T217807)
  • Some objects are ignored in document outline issue is fixed (T214010)
  • User reported issues in completion list are fixed (T216164, T218058)
  • Issues with stored procedure debugging are fixed (T215835, T216125, T217076, T217135, T217893, T218184)
  • User reported issues with VS integration are fixed (T216291, T216333)

New in dbForge SQL Complete Standard 5.6.146 (Apr 21, 2017)

  • NRE when opening C# projects in VS2015 is fixed (T215527, T215543, T215554, T215565, T215573, T215580, T215549, T215619, T215623, T215576, T215633)

New in dbForge SQL Complete Standard 5.6.145 (Apr 20, 2017)

  • Compliance with the Federal Information Processing Standard (FIPS)
  • Trial product activation implemented
  • Greatly improved visual style of the application with high DPI support
  • Product now integrates into VS 2017 and SSMS 17.0 RC3
  • Restoring last closed tab is implemented
  • Restoring document sessions is implemented
  • Abilitty to close unmodified tabs is implemented
  • Ability to set custom SSMS main window title and caption for sql document tabs
  • Support of the following statements:
  • BULK INSERT
  • ALTER APPLICATION ROLE
  • DROP APPLICATION ROLE
  • DROP DATABASE
  • DROP DEFAULT
  • DROP QUEUE
  • CREATE LOGIN, ALTER LOGIN, DROP LOGIN
  • CREATE APPLICATION ROLE
  • RECEIVE
  • DROP STATISTICS
  • CREATE FULLTEXT STOPLIST
  • CREATE DEFAULT
  • CREATE XML SCHEMA COLLECTION
  • Suggestion improvements:
  • Filegroups suggestion
  • System versioning
  • Transactions Suggestions
  • Stretch tables
  • Always encrypted
  • Dynamic data masking
  • Row-level security
  • Fully qualifying a table with the server name is supported
  • Suggestion of databases created in script is supported
  • Column suggestion for CTE is improved
  • JOIN synonym suggestion is implemented

New in dbForge SQL Complete Standard 5.5.218 (Dec 13, 2016)

  • SQL Complete now integrates into VS 2017 RC and SSMS 17.0 RC1
  • Error report during parsing and editing text is fixed (T192703, T193151, T193396, T193472, T193744, T193599, T194022, T194491, T194908, T195244, T195841, T195970, T196024, T196027, T196723, T196951, T197140, T197532, T197640, T197856, T197872, T197907)

New in dbForge SQL Complete Standard 5.5.215 (Oct 10, 2016)

  • SQL Compete will not catch exceptions of 3rd party installed modules anymore (T190902, T190767, T190762, T190753, T190749, T190697, T190672, T190893, T190785, T190632, T190195)

New in dbForge SQL Complete Standard 5.5.214 (Oct 10, 2016)

  • Issue with Refresh Local Cache shortcut is fixed (T188265)
  • User reported issue with specific script is fixed (T187560)
  • Issue with code suggestion context is fixed (T189328, T181959, T189329, T189689)
  • Issue with ability to view error reports is fixed

New in dbForge SQL Complete Standard 5.5.205 (Oct 10, 2016)

  • NRE when opening project is fixed (T187173)
  • User reported error messages are fixed (T184815, T181808, T184803, T183887, T184019, T185535, T186496, T186614, T187033, T186955, T186809, T185023, T186070, T186446, T186803, T187211, T182330, T182725, T182966, T183196, T183385, T183447, T183522, T183954, T184028, T184084, T184261, T184260, T184629, T185066, T185061, T185097, T185519, T185708, T185675, T185773, T185814, T186114, T186133, T186056, T186058, T186113, T186261, T186352, T186540, T186899, T186900, T187154, T187069, T187085, T187212)
  • Issue when opening Database diagram is fixed (T185156)
  • Code completion issues are fixed (T181928, T185094, T185141, T185522, T185051, T182082, T181963, T184616, T184865, T185092)
  • Formatting issues are fixed (T183698, T184715, T184840, T187215, T184859, T182953, T183368, T182400, T184281, T185476)
  • Fusion and CodeRush compatibility issues are fixed (T182800, T185801, T186196, T181201)
  • Performance issues are fixed (T181959)

New in dbForge SQL Complete Standard 5.5.166 (Oct 10, 2016)

  • Issue with Quick Info is fixed (T182503, T182668, T182729, T182737)
  • Snippet issue is fixed (T181204)
  • User reported NRE is fixed (T182487)

New in dbForge SQL Complete Standard 5.5.159 (Oct 10, 2016)

  • 'startIndex cannot be larger than length of string' error message is fixed (T179987, T180148, T180263, T180323, T180473, T181179)
  • 'The code of your SQL script will be used only for debugging and fixing your problem' error message is fixed (T181925, T182077, T181906, T181960)
  • 'Invalid offset: 105' error message is fixed (T181227, T181373, T181855, T182069)
  • Formatting issue in Express edition is fixed (T181207)
  • Issue with expanding column names from * is fixed (T181858)
  • Other user reported bugs are fixed (T181779, T181379, T181954, T181770, T182054, T180595)

New in dbForge SQL Complete Standard 5.5.145 (Aug 2, 2016)

  • Integration issues into newer build of SSMS 2016 are fixed (T180130, T180149, T178876, T180215, T180241, T180409, T180414, T180416, T180458, T180347)
  • Issue with functions suggestion is fixed (T178014, T180163)
  • NRE are fixed (T180147, T179991)
  • Installation issues are fixed (T179973, T180155, T180571)

New in dbForge SQL Complete Standard 5.1.136 (Aug 2, 2016)

  • New SQL Server 2016 syntax supported
  • SQL Complete now integrates into SSMS 2016
  • Objects suggestions in CROSS/OUTER APPLY statement
  • Suggestion of compound phrases
  • Greatly improved suggestion performance
  • Several new formatter options and profiles
  • Both objects and schemas suggestions in Completion List when writing cross-database queries

New in dbForge SQL Complete Standard 5.1.46 (Aug 2, 2016)

  • Visual Studio 2015 integration issue for non-admin account is fixed (T155536)
  • Go to Definition issue is fixed (T154906)
  • User reported exception is fixed (T152392)
  • DBCC IND command is supported
  • Some known Install and Uninstall issues are fixed

New in dbForge SQL Complete Standard 5.1.42 (Aug 2, 2016)

  • SSMS integration issues are fixed (T148834, T149496, T149283, T149546, T151495, T151593, T152940, T153914)
  • Geospatial functions support improved (T148176)
  • User reported exceptions are fixed (T153546, T146511, T150036, T145874, T145498, T145770)
  • Better formatting and suggestions support (T138756, T143135, T146178, T147295, T149991, T146962)
  • Debugging in SQL Management Studio issue is fixed (T150174)
  • Ability to select ngen options during installation process (T150688)

New in dbForge SQL Complete Standard 5.1.14 (Aug 2, 2016)

  • Integration to Microsoft Visual Studio 2015 is supported:
  • SQL Complete features are now available in VS 2015
  • User reported bug fixes:
  • Bug fix and stability improvements (T142282, T142262, T143710, T142262, T143137, T143672, T142300, T142549)

New in dbForge SQL Complete Standard 5.0.34 (Aug 2, 2016)

  • MSSMS 2005 and MSSMS 2008R2 crashes are fixed (T141481, T141727, T141699, T141756, T141725, T141718, T142163, T142208, T142067)
  • Snippet issues are fixed (T141233, T141153, T140749, T141237, T127361, T142075)
  • Issue when renaming variables is fixed (T140745)
  • Other bugs fixed (T140743)
  • Snippets and SQL Refactoring highlight color settings are improved

New in dbForge SQL Complete Standard 5.0.28.0 (Aug 2, 2016)

  • Statement Expansion:
  • UPDATE statement support added
  • Code Snippets:
  • TRANSACTION and ROLLBACK TRANSACTION code templates are now available
  • Custom Alias Mapping:
  • Assigning of custom aliases to a table, view, table-valued function, or synonym referenced to in an SQL document
  • Code Highlighting:
  • Highlight of both the opening and closing code elements to visually define separate code blocks and determine mismatched or misspelled paired code elements
  • Code Refactoring:
  • Changing all occurrences of variable names and object names to new ones, automatically finds and corrects all references to them
  • Semicolon Insertion:
  • Inserting missing semicolons after each statement in a query
  • SSDT Project Support:
  • SQL Complete is now available in SSDT SQL Server projects

New in dbForge SQL Complete Standard 4.8.43 (Feb 20, 2015)

  • Performance decrease issue in files with lots of code is fixed
  • 'Object reference not set to an instance of an object' issue is fixed
  • Issue with completion list in comments is fixed
  • Other completion list fixes and improvements
  • Dark theme colors issue is fixed
  • 'The EXECUTE permession was denied' error message is fixed

New in dbForge SQL Complete Standard 4.8.34 (Dec 29, 2014)

  • Object reference not set to an instance of an object exception is fixed
  • Some functionality improvements are implemented
  • Issue with [Security].Users table columns autocompletion is fixed
  • Issue with functions suggestions is fixed
  • Pasting text for literal name issue is fixed
  • Issue with Go To Definition is fixed
  • Autoformat not working on SQL Server 2008R2 is fixed
  • OutOfMemoryException for large scripts is fixed
  • Useless implicit code completion blocks are removed

New in dbForge SQL Complete Standard 4.8.33 (Dec 29, 2014)

  • ArgumentOutOfRangeException is fixed
  • Operation of the autocompletion functionality is fixed
  • Error with connecting to server is fixed
  • Error with suggesting keywords is fixed
  • Error with displaying the native IntelliSense in SQL Server2008 is fixed

New in dbForge SQL Complete Standard 4.8.17 (Dec 29, 2014)

  • Code formatter:
  • MERGE statement support
  • Code completion:
  • Support of the following statements
  • MERGE
  • CREATE DATABASE
  • ALTER DATABASE
  • DROP DATABASE
  • BACKUP DATABASE
  • EXEC sp_attach_db
  • EXEC sp_detach_db
  • CREATE STATISTICS
  • UPDATE STATISTICS
  • DROP STATISTICS
  • CREATE INDEX
  • ALTER INDEX
  • DROP INDEX
  • ENABLE TRIGGER
  • DISABLE TRIGGER
  • Phrase completion:
  • SQL Complete suggests not only separate keywords and object names, but entire code phrases

New in dbForge SQL Complete Standard 4.7.233 (Dec 29, 2014)

  • Issue with VS 2012 Color Theme Editor
  • Issue with MSSMS 2005 integration is fixed
  • Issues with snippets usage are fixed
  • Issue with UPDATE statement formatting is fixed
  • Aggregate function suggestions are improved
  • XML method suggestions are fixed

New in dbForge SQL Complete Standard 4.7.226 (Dec 29, 2014)

  • User reported bug fixes with black skins
  • Issue with Convert EXEC to script is fixed

New in dbForge SQL Complete Standard 4.7.212 Beta (Jun 10, 2014)

  • The new version contains a host of new features, including:
  • Alias refactoring
  • User defined table type suggestion
  • Tables suggestion while creating indexes
  • Support for new keywords introduced in SQL Server 2014

New in dbForge SQL Complete Standard 4.6.192 (May 16, 2014)

  • Integration to Microsoft SQL Server Management Studio 2014 is supported:
  • SQL Complete features are now available in SSMS 2014
  • User reported bug fixes:
  • Exception when using MERGE statement is fixed (T101062, T101253)
  • Issue with disappearing suggestions is fixed (T102373)
  • Application updated with lots of minor bug fixes

New in dbForge SQL Complete Standard 4.5.178 (Jan 20, 2014)

  • A problem occuring while using a SSMS project is fixed (T95888, T95887, T95982)

New in dbForge SQL Complete Standard 4.5.177 (Jan 20, 2014)

  • An error occuring while installing SQL Complete on a computer with Microsoft Visual Studio 2013 is fixed (T95606)

New in dbForge SQL Complete Standard 4.5.167 Beta (Dec 27, 2013)

  • Integration to Visual Studio 2013 is supported:
  • SQL Complete features are now available in Microsoft Visual Studio 2013.
  • New code formatter features:
  • New Option: Add empty line after GO
  • New Option: Enclose identifiers within square brackets []
  • New Option: Add parentheses when inserting functions
  • New Option: Enable autoformat words while typing
  • New Option: Alias Text Case - As in declaration
  • Code formatter functionality is available even if SQL Complete is disabled
  • Do not format tag is implemented. Now it is possible to format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.
  • Refresh suggestions cache:
  • Automatic refresh suggestions cache by specified time is added
  • New option: Refresh suggestions cache on detecting changes on a server
  • Code completion support is expanded:
  • SET IDENTITY INSERT tables suggestion
  • XML variables suggestion in the FROM statement
  • Minor improvements:
  • Formatting CASE options are redesigned
  • Objects describe performance is improved
  • New snippets are added

New in dbForge SQL Complete Standard 4.0.140 (Dec 2, 2013)

  • A problem occurred while using connections for Azure databases is fixed
  • An error occurred while closing SSMS is fixed
  • An exception occurred on closing an SQL document is fixed

New in dbForge SQL Complete Standard 4.0.137 (Dec 2, 2013)

  • An error, occurring while formatting a statement that contains row_number is fixed
  • Error report on renaming C# identifiers is fixed
  • A problem related to the incorrect default schema definition is fixed
  • Exception on closing an SQL document is fixed
  • Error on detecting font is fixed
  • New code formatting functionality for selected files and for all files in specified directories, based on files extension, is added

New in dbForge SQL Complete Standard 4.0.128 (Sep 18, 2013)

  • The error on formatting the FOR XML PATH construction is fixed
  • The ability to multi-select and drag'n'drop snippets in Snippets Manager is added
  • The problem with indenting the stack for the WHERE condition is fixed
  • The bug with saving the status of the active profile when exporting/importing SQL Complete settings is fixed
  • The bug with the keyword NOLOCK in the suggestion list is fixed
  • The bug with using user literals in Snipper Manager is fixed
  • The bug with formatting the MAX specifier for the nvarchar data type is fixed
  • The issue with changing the connection from SSMS 2012 to 2012 HADR availability group is fixed
  • The problem with formatting the INSERT statement is fixed
  • NullReferenceException on working with the SQL documents containing large XML content is fixed

New in dbForge SQL Complete Standard 4.0.120 (Aug 23, 2013)

  • New SQL Server connection string parameters are supported

New in dbForge SQL Complete Standard 4.0.119 (Aug 21, 2013)

  • Formatting of built-in functions is fixed
  • NullReferenceException on inserting a script in the Edit Profile window is fixed
  • FIRST_VALUE() and LAST_VALUE() functions are supported
  • NullReferenceException on convert exec to script is fixed
  • Problem on formatting block comments is fixed
  • Problem on displaying hints when working with script objects is fixed
  • Problem on F12 (Go to Definition) is fixed
  • Problem with schema objects suggestion on using system role as schema object is fixed
  • Problem with suggesting keywords in the OVER clause is fixed
  • Problem with displaying context menu in Microsoft Visual Studio 2008 is fixed
  • Problem on displaying user name on using LOGIN literal in Snippets Manager is fixed
  • Inner query performance is optimized
  • Problem with disabling SQL Complete in one environment after an error was encountered when loading it in another environment is fixed

New in dbForge SQL Complete Standard 4.0.109 (Aug 5, 2013)

  • The cursor variable formatting error in the UPDATE statement is fixed
  • The WITH statement formatting error is fixed
  • Comments indention formatting error is fixed
  • An error occurs when attempting to update using the Update Manager is fixed
  • Columns Sorting error in CTE (while expanding) is fixed
  • The THROW statement formatting error is fixed
  • In the INSERT statement an additional stack is added, for the output clause columns
  • An error occurs when attempting to use "Value" in the column name is fixed
  • An error occurs when attempting to Convert EXEC to script is fixed
  • A NullReferenceException while starting MSSMS 2008 is fixed
  • A NullReferenceException while creating an SQL document is fixed
  • The xml_schema_namespace function is added to the Member List
  • The "As in declaration" option for variables is added
  • The Parameter Info displaying error is fixed
  • The statements to receiving the external indexes and foreign keys are optimized

New in dbForge SQL Complete Standard 4.0.89 (Jun 21, 2013)

  • 'As in the declaration' formatting option is added
  • Problem with formatting of comments is fixed
  • NullReferenceException on changing a caret position is fixed
  • Problem on importing the settings of previous product builds is fixed
  • Problem with automatic formatting is fixed
  • Problem with absence of the xml_schema_namespace function in the suggestion list is fixed

New in dbForge SQL Complete Standard 4.0.78 (May 30, 2013)

  • Error report when SQL Complete is resuming after hibernate is fixed
  • Error message occurring on working after a current database was dropped is fixed
  • Error report when opening a project that contains .sql files is fixed
  • Error report when loading SQL Complete with IDE using corrupted commands cache (.prf file) is replaced with a resolve suggestion message
  • Problem when typing = form of select list item is fixed. Now SQL Complete doesn't commit items from Members List by typing the '=' character
  • Error during install SQL Complete is fixed
  • Problem with using SQL Complete with SSMS 2005 Express is fixed
  • Problem with wrong formatting of the columns having the 'value' name is fixed
  • Syntax check errors when formatting some SQL statements is fixed
  • Problem with adding table aliases when committing a column from Members List in the SET clause of the UPDATE statement is fixed
  • Problem on the formatting that removes a line break before comments is fixed
  • Wrong expanding columns list is fixed
  • Wrong formatting of CTE clause is fixed
  • Wrong expanding of the ALTER PROCEDURE statement is fixed
  • Problem on generating the AS keyword before a table alias with the corresponding option being checked is fixed

New in dbForge SQL Complete Standard 4.0.72 (Apr 2, 2013)

  • Error report when working with large T-SQL scripts is fixed

New in dbForge SQL Complete Standard 4.0.71 (Mar 20, 2013)

  • IDE crash on formatting is fixed

New in dbForge SQL Complete Standard 4.0.70 (Mar 19, 2013)

  • Error report on typing the CREATE VIEW statement is fixed

New in dbForge SQL Complete Standard 4.0.69 (Mar 19, 2013)

  • Problem with generating aliases is fixed
  • Problem with navigating to objects through connections like (local)server_name is fixed
  • Wrong formatting of CASE statement is fixed
  • Problem with showing semi-transparent hints is fixed
  • More accurate description of MIN/MAX aggregate functions is provided
  • Wrong formatting of JOIN chains in subqueries is fixed
  • Problem with highlighting identifiers that started with '_' symbol is fixed
  • Error report when working with T-SQL documents is fixed
  • Error report on closing VS 2010 is fixed
  • Error report on closing a T-SQL document using VsVim command is fixed
  • Wrong formatting of statements that contain syntax errors is fixed
  • Problems with using SQL Complete hints in positions after subqueries is fixed
  • Autocomplete words from incomplete Member List is disabled

New in dbForge SQL Complete Standard 4.0.68 (Mar 19, 2013)

  • Problem with a CTE statement formatting is fixed
  • Error report when opening CodeSmith Generator templates is fixed
  • Error report when pasting code into the script with disabled SQL Complete is fixed
  • Incorrect formatting of built-in data types is fixed
  • Error report when working with non T-SQL documents is fixed

New in dbForge SQL Complete Standard 4.0.67 (Mar 1, 2013)

  • SSMS 2012 crash after executing query when 'Disconnect after the query executes' option is turned on is fixed
  • Error report on typing query in procedure body is fixed

New in dbForge SQL Complete Standard 4.0.65 (Feb 20, 2013)

  • Problem with the 'Refresh Local Cache' command is fixed
  • Problem with saving shortcuts for SQL Complete commands is fixed
  • GDI objects leak leading to SSMS 2005 crash is fixed
  • Error report on saving a document is fixed

New in dbForge SQL Complete Standard 4.0.61 (Feb 20, 2013)

  • Error report when showing popup menu in text editor is fixed
  • Error report on adding cursor declaration to routine body is fixed
  • Error report when opening .sql file in Visual Studio 2012 is fixed
  • Error report on expanding routine call is fixed

New in dbForge SQL Complete Standard 4.0.58 (Jan 19, 2013)

  • Error when starting IDE with SQL Complete being installed using the "Run As .." command is fixed
  • Problem with formatting column list when expanding a statement to a full template by pressing the Tab key is fixed (
  • Formatting of the CASE statement is improved
  • Error message on formatting a script is fixed
  • Problem with using SQL Complete in statements like 'select db..' is fixed
  • Wrong snippet highlighting is fixed

New in dbForge SQL Complete Standard 4.0.57 (Jan 10, 2013)

  • Error report when loading VS 2008 is fixed
  • Error report when loading VS 2010 is fixed
  • Error report on renaming C# identifiers is fixed
  • Wrong formatting IF blocks is fixed
  • Wrong indenting FROM clause is fixed

New in dbForge SQL Complete Standard 4.0.55 (Jan 10, 2013)

  • Error report during loading VS 2008 is fixed
  • Error report during opening query is fixed
  • Problem with saving custom shorcuts for SQL Complete commands is fixed

New in dbForge SQL Complete Standard 4.0.54 (Jan 10, 2013)

  • 'Do not change' identifier case formatting option added

New in dbForge SQL Complete Standard 4.0.53 (Jan 10, 2013)

  • Formatting profile introduced:
  • Individual file for storing formatting preferences
  • Multiple formatting profiles and profile import are supported
  • Single-profile can be used for multiple workstations
  • New formatting options editor:
  • Option quick search filter is added
  • Sample code formatting displayed according to current formatting settings
  • Editable sample code formatting preview is added
  • Enhanced formatting settings:
  • Independent and precise adjustment for SQL-statements is added
  • Formatting settings for sub-queries are added
  • Word recognition for UPPER, lower and CamelCase formatting in identifiers is supported
  • Independent built-in datatype case formatting settings are supported
  • New SQL code refactoring features:
  • Code and database identifier case synchronization is added
  • Stored procedure call expansion is supported
  • New code completion features:
  • Table order in ON condition of suggested JOIN clause can now be reversed. Behavior can be toggled in the options menu
  • Inserted columns in SELECTs are now automatically qualified with a table alias. Behavior can be toggled in the options menu
  • Functions are now inserted from suggestion list with braces
  • 'Refresh Local Cache' and 'Refresh Suggestions' commands now use the same shortcut
  • ALTER TABLE statement now has context-sensitive identifier suggestion
  • 'Run Current Statement' command usability slightly improved
  • Code completion for temporary tables has been added to the Express edition
  • Integration with SSDT in Visual Studio 2010/2012 is supported:
  • SQL Complete features are now available in the SSDT 2010/2012 SQL Editor.

New in dbForge SQL Complete Standard 3.5.83 (Sep 12, 2012)

  • Error report during expanding routine body is fixed
  • Formatting "modify" function with wrong case is fixed
  • Problem with Visual Studio freezing during opening vb.net project properties is fixed
  • Error report during expanding routine body with datetime parameters is fixed
  • Memory leak is fixed
  • Error report during opening query to default database is fixed
  • Error report during editing or formatting FROM list with braced items is fixed
  • Error report during formatting ALTER VIEW statement is fixed
  • Error report during adding Entity Developer model to solution is fixed

New in dbForge SQL Complete Standard 3.5.79 (Jul 27, 2012)

  • Support of Microsoft Visual Studio 2011 is added
  • Error "Object reference not set to an instance of an object" is fixed
  • Error report when opening SQL file from project is fixed
  • Problem with installation repair is fixed
  • Error report when creating new project is fixed
  • Error report during describing database is fixed
  • Error report during re-executing query is fixed
  • Error " Internal connection fatal error" is fixed
  • User's snippet is added
  • Error report during saving SQL file to the project is fixed
  • Problem when using connections with lagre databases is fixed

New in dbForge SQL Complete Standard 3.5.72 (Jul 20, 2012)

  • Added integration into Visual Studio 2012
  • Error Report on performing the Execute Current Statement command is fixed Bug on using the $DB$ literal in the snippet is fixed
  • NullReferenceException on code comparing
  • Warning on incorrect credentials entering or expired subscription is added in the Product Update Manager

New in dbForge SQL Complete Standard 3.5.61 (May 23, 2012)

  • Error report on snippet insertion with predefined literal is fixed
  • Error report on script modifying is fixed
  • Problem with valid script formatting is fixed
  • Right Margin formatting option limitation is changed to maximum possible Problem with formatting is fixed, 3 white spaces are replaced with a TAB symbol

New in dbForge SQL Complete Standard 3.5.60 (May 3, 2012)

  • Error report on product update is fixed
  • Error report on changing a connection during metadata retrieving is fixed
  • Error report on *.sql file opening in VS2010 is fixed
  • Problem with incorrect formatting within the BEGIN...END block is fixed
  • Problem with formatting comments is fixed
  • Problem with smart tag expanding for linked server is fixed
  • Problem with formatting DDL statement without delimiter is fixed
  • Problem with smart tag appearance after fully typed identifier is fixed
  • Problem with saving snippets after uninstalling the express edition is fixed

New in dbForge SQL Complete Standard 3.5.56 (May 3, 2012)

  • Problem with suggesting user table types is fixed
  • Error report on editing large scripts is fixed
  • Error report on updating commands status is fixed
  • Error report on typing characters in virtual space is fixed

New in dbForge SQL Complete Standard 3.5.54 (Mar 2, 2012)

  • Error report on suggesting cursors is fixed
  • Error report on saving incorrect snippet shortcut is fixed
  • Error report on shown Quick Info hint is fixed
  • Error report on starting add-in is fixed
  • Error report on using Member List is fixed
  • Wrong formattting of words case is fixed
  • Problem with columns suggestion is fixed
  • Problem with the conflict with SQL Treeo is fixed

New in dbForge SQL Complete Standard 3.5.51 (Feb 4, 2012)

  • Support of SQL Server 2012 and SQL Server Compact Edition:
  • As support for the new version of SQL Server was introduced together with full support for Compact Edition, developers got an opportunity to use the advanced SQL Intellisense functionality with any server version and edition, starting with SQL Server 2000 and up to SQL Azure.
  • Column picker feature:
  • New functionality will make it possible to create SELECT and INSERT queries, as it allows defining column lists for selecting, grouping, sorting and inserting without typing any code at all. The suggestion list appearance was changed now it supports hierarchical view for table columns and shows information about data type.
  • Intellisense in SQLCMD mode:
  • Scripts that are executed with the help of the command line utility, are usually parametrized. But often it is the reason of the fact that ability to show correct suggestions for objects is lost, because database or schema name can be a variable. Now SQL Complete solves this problem. Values of variables are taken from the text of the document and object suggestions work as with an ordinary SQL script.
  • Automatic formatting of keywords on typing:
  • Keywords are formatted according to the option settings. This will help to avoid appearance of keywords written in different registry, when part of them was inserted from the suggestion list and part was typed manually.
  • Extended and revised SQL Snippets:
  • We've revised existing code templates, added new ones, and changed the behaviour of the suggestion list on selecting a template. This will allow choosing the needed template as quickly as possible and reducing time needed for typing recurring code constructions. Also keep in mind that users can create their own SQL snippets with the help of the special editor.
  • Extended T-SQL syntax support:
  • Context-sensitive prompt of objects in the MERGE statement and a number of SQL Server 2012 T-SQL construction is supported.
  • SQL formatting improved:
  • Formatting of procedure and function code, CASE statements, comments, and column list inserted on wildcard expansion is improved.

New in dbForge SQL Complete Standard 3.1.28 (Dec 16, 2011)

  • Error report on unloading SQL Complete commands is fixed (T34664, T34941, T35105)
  • Error report on updating SQL Complete commands is fixed (T35167)
  • Error report on opening Document Outline window on Visual Studio 2010 is fixed (T34828)
  • Wrong syntax error on formatting a script is fixed (T35030)
  • Problem with refreshing the list of databases when refreshing suggestions is fixed (T34777)

New in dbForge SQL Complete Standard 3.1.25 (Dec 6, 2011)

  • Error report on unloading add-in is fixed
  • Error report on unloading SQL Complete commands is fixed
  • Application suspension on parsing chains of nested function calls is fixed Wrong syntax error on formatting a script is fixed
  • Memory leak on working with documents is fixed

New in dbForge SQL Complete Standard 3.1.21 (Nov 10, 2011)

  • Error report on suggesting parameters is fixed
  • Bug with resetting toolbars layout between working sessions is fixed
  • Error report on describing metadata is fixed
  • Application suspension on parsing long expressions is fixed

New in dbForge SQL Complete Standard 3.1.10 (Nov 8, 2011)

  • Error report on describing metadata fixed (T32713, T33025, T33063, T33081, T33083)
  • Error report on formatting code in Express Edition fixed (T32978)
  • Error report on Quick Info fixed (T33170, T33185)
  • Application suspension on large database fixed

New in dbForge SQL Complete Standard 3.1.5 (Nov 8, 2011)

  • Error report on describing metadata fixed (T32005, T32902, T32924, T32934, T32936, T32942)
  • Error report on turning off SQL Complete fixed (T32941)

New in dbForge SQL Complete Standard 3.1.3 (Nov 8, 2011)

  • New Features:
  • Linked servers support
  • SQL statements support extended. The Standard Edition provides support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements
  • Highlight Occurrences on/off option is added
  • Improvements:
  • Usability of code completion improvement
  • Installation process customization with the ability to integrate SQL Complete to different development environments is supported
  • Tracing support
  • Express Edition Extension:
  • SQL statements support extended. Support for DROP, EXEC, and SET statements was added.
  • Variables and parameters support

New in dbForge SQL Complete Standard 3.0.24 (Nov 8, 2011)

  • Error report on suggesting tables to join is fixed (T31980)

New in dbForge SQL Complete Standard 3.0.23 (Nov 8, 2011)

  • StackOverflowException that was leading to crashing SSMS has been fixed (T31980, T32005)
  • A few other bugs were fixed as well

New in dbForge SQL Complete Standard 2.50.92 (Jun 4, 2011)

  • Critical bug with showing Quick Info is fixed
  • Problem with checking updates is fixed

New in dbForge SQL Complete Standard 2.50.91 (May 30, 2011)

  • SSMS freezing when user scrolls a document to the end is fixed
  • Problem with SQL Complete keeping database connection open even if document was closed is fixed
  • NRE that occurs on collapsing and expanding regions is fixed
  • CTE queries formatting is fixed

New in dbForge SQL Complete Standard 2.50.90 (May 24, 2011)

  • SSMS freezing when user is working with script that contains collapsed regions is fixed

New in dbForge SQL Complete Standard 2.50.89 (May 13, 2011)

  • NRE on typing TRUNCATE keyword is fixed
  • NRE on parsing script scope declarations is fixed
  • Bug with column name insertion into column list in INSERT statement is fixed
  • Problem with changing local list separator to comma is fixed
  • NRE on editing MERGE statement is fixed
  • NRE on editing script when metadata from server is still being described is fixed
  • Bug on typing left parenthesis is fixed
  • Bug with formatting statements that contains quoted identifiers is fixed \Bug with suggestion of ELSE keyword is fixed
  • Problems with parsing large chains of nested method calls are fixed

New in dbForge SQL Complete Standard 2.50.86 (Apr 6, 2011)

  • Fixed problem with formatting comments in BEGIN...END block
  • Fixed problem with freezing on a large number of UNION in subqueries
  • Fixed problem with formatting of ON condition in JOIN statement
  • Fixed the NullReferenceException exception in Quick Info for aliases

New in dbForge SQL Complete Standard 2.50.84 (Mar 19, 2011)

  • Fixed exception after typing the "]" symbol
  • Fixed ArgumentOutOfRangeException in several cases
  • Fixed freezing SSMS if Google Chrome is in background

New in dbForge SQL Complete Standard 2.50.83 (Mar 4, 2011)

  • Fixed NRE on INSERT formatting in stored procedures
  • Fixed application hanging on IF... ELSE ... IF parsing

New in dbForge SQL Complete Standard 2.50.80 (Mar 3, 2011)

  • Fixed error on Quick Info displaying when some regions are collapsed in editor

New in dbForge SQL Complete Standard 2.50.79 (Feb 28, 2011)

  • Quick object info added
  • Expand INSERT statement feature added
  • Export/Import settings wizard added
  • Fixed SSMS crashing on JOIN clause suggestion
  • Context-sensitive code completion for common table expressions (CTE) supported
  • Improved logic for JOIN clause suggestions
  • Put commas at the beginning of lines in lists option added
  • Additional options to format CASE expressions and logical operands added
  • Add/remove a space between a function name and an opening bracket of the argument list option added
  • Reset Page Defaults button added
  • Enabling native IntelliSense when SQL Complete disabled

New in dbForge SQL Complete Standard 2.0.51 (Feb 14, 2011)

  • Changed behavior of suggestion commit on Tab
  • Fixed error in parameter info for functions of user-defined types
  • Fixed IndexOutOfRangeException while editing procedure text

New in dbForge SQL Complete Standard 2.0.49 (Jan 31, 2011)

  • Fixed critical bug with SSMS hanging
  • Fixed bug with replacing the caret to line end after a member list element commited
  • Fixed error at opening the SQL document with other editor

New in dbForge SQL Complete Standard 2.0.48 (Jan 28, 2011)

  • Fixed critical bug with describing metadata from SQL Server 2000
  • Fixed bug with formatting selection
  • Closing connection after document closed

New in dbForge SQL Complete Standard 2.0.46 (Jan 28, 2011)

  • Fixed bug of formatting T-SQL statements with GOTO labels

New in dbForge SQL Complete Standard 2.0.45 (Jan 28, 2011)

  • Express (free) and Standard editions of the product available
  • Possibility of working with large scripts
  • Expanded support for Transact-SQL statements
  • Suggesting conditions for JOIN statements
  • Extended support for statements
  • Suggesting methods for columns and variables
  • Context-sensitive suggesting of collations, data types, XML schema collections, and languages
  • Sorting keywords by relevance
  • Qualifying a column name on completion
  • Expanding a list of columns in SELECT statement
  • Automatic alias generation in SELECT satatements
  • Performance improvements

New in dbForge SQL Complete Standard 1.0.62 (Jan 28, 2011)

  • Fixed error at startup
  • Parsing perfomance improved for UNION clause
  • Fixed bug with keyword FROM suggestion

New in dbForge SQL Complete Standard 1.0.61 (Jan 28, 2011)

  • Fixed critical error at drop down list showing on localized SSMS

New in dbForge SQL Complete Standard 1.0.60 (Jan 28, 2011)

  • Parsing perfomance improved
  • Custom color schemes supported
  • Fixed error report at unload
  • Fixed a few bugs with drop down list scrolling by mouse wheel
  • Fixed a few bugs with formatting of JOIN chains
  • Fixed bug with keyboard tracking in drop down list when parameter info is shown
  • Fixed bug with working in read only documents

New in dbForge SQL Complete Standard 1.0.57 (Jan 28, 2011)

  • Fixed bug with disabling embedded SSMS IntelliSense
  • Fixed bug with insufficient memory when working with large scripts
  • Fixed bug: Two undo actions required to rollback inserted suggestion from drop down list

New in dbForge SQL Complete Standard 1.0.54 (Jan 28, 2011)

  • Fixed error report at startup
  • Fixed bug with disabling embedded SSMS IntelliSense
  • Fixed bug with describing metadata from SQL Server Express edition
  • Fixed error report at unload