dbForge SQL Complete Standard full changelog

Improvements:
Added an AI Assistant
Added support for SSMS 22
Added support for Visual Studio 2026
Added camelCase formatting for identifiers
User-reported bug fixes:
Fixed an issue with auto-formatting the LEFT keyword (#167567, #193621)
Improved logging performance (#213789)
Fixed an error that occurred when opening a document (#226279)
Fixed an issue where Visual Studio could hang when importing a database into a project (#171327)
Fixed an issue where SSMS could hang when running queries against a server group (#200747)
Fixed an issue that could trigger the parser error "Index was outside the bounds of the array" (#217648)

Resolved issues with queries used to retrieve descriptions of tables, indexes, and constraints (#221795)
Improved filtering of string literal suggestions in the completion list (#222546)

Fixed a "Retrieving metadata" freeze when opening a SQL document (#221224)
Fixed a critical error that caused SSMS to terminate when re-executing a query in a document (#222420, #222538, #222519, #222298, #222470)

Fixed an issue where column values for the INSERT statement were incorrectly assembled when they were nested SELECT queries (#165574)
Fixed an issue where the Code Completion window closed when the entered text matched a shortcut snippet (#170898)
Fixed the display of data in the Data Viewer (#167482)
Fixed the filtering of time zones in the completion list (#170893)
Fixed the behavior of the Include default schema in object names option in JOIN condition suggestions (#214503)

User-reported bug fixes:
Fixed an issue that occurred when a connection to Azure Blob Storage was present in Object Explorer (#190663)
Fixed column alias suggestions in INSERT ... SELECT expressions (#191837)

Connectivity:
Added support for dedicated and serverless SQL pools in Azure Synapse Analytics
T-SQL Analyzer:
Expanded the set of rules
User-reported bug fixes:
Resolved an issue with reading foreign keys across schemas, enabling correct suggestions in Code Lookup (CL) (#176246)
Restored the assignment of aliases to columns in SELECT statements generated using dbForge SQL Complete (#193439)
Corrected the behavior of the Commit Selection on Whitespace option — pressing the spacebar no longer triggers selection in the Column Picker (#178655)
Improved the text replacement logic when inserting items for quoted unfinished identifiers (#169524)
Fixed an issue where the tab color was lost when switching users (#164931)
Fixed a hang that occurred after pressing Execute. It is now possible to set focus in the result grid of the Registered Server dialog. (#200747)
Added support for the CREATE USER FOR EXTERNAL PROVIDER syntax in code completion and SQL formatting (#199473)
Fixed an issue where file path separators in paths to script files executed by sqlcmd were incorrectly surrounded by spaces during SQL document formatting (#203956)
Resolved code completion glitches that occurred when typing quickly (#165191, #166191, #203202, #200132)
Fixed freeze in SQL Server Management Studio when opening the Database Explorer menu immediately after startup with the Devart extensions installed (#176935, #166428)

User-reported bug fixes:
Fixed the hierarchy update issue when adding a snippet (#177915)
Fixed an issue with the cursor movement after inserting a snippet (#167836)
Removed the error message with code 15003 from the Output window (#164962)
Fixed an issue where renaming an alias caused the process to be unexpectedly canceled (#171108)
Fixed an issue where an error window frequently appeared when a physical file included in the project was missing (#170283)
Fixed a rare issue that occurred when selecting data in the data grid (#165935, #166203)
Fixed a rare issue that occurred when using the Insert semicolons command (#178796)
Resolved a rare issue with inserting items from the completion list (#164582, #166081, #171328, #185579, #189328, #189431, #189638)
Fixed an issue where suggestions were missing in the document when connected with a login that had a default database other than the master database (#179781)
Optimized the retrieval of synonyms for document suggestions (#167972)

Fixed an issue where the editor lost selection after inserting a snippet (D164311, D165305)
Fixed an issue with database selection when opening a document by selecting the Script Object as CREATE/ALTER option (D127840)
Fixed an issue that occurred when describing server declarations (D164811)
Fixed an issue that occurred during quick text editing with tooltips displayed (D164461, D164486, D165122, D165669, D165644, D165738, D165742, D165242, D165886, D165761, D166965, D167215, D167082, D166869, D165977, D167773)
Fixed a connection retrieval issue in earlier versions of SSMS (D164434, D165441, D165973, D165985, D166187, D166080, D166181)
Improved the behavior of the CTRL K+X shortcut so that snippets now only open in comments (D165944)
Updated the format for DATE and TIME literals in Snippet Manager to comply with the ISO 8601 standard (D164767)
Added the Generate Script As BULK INSERT command to the Results window of Query Editor (D164594)
Fixed an issue that occurred after closing the document in Query Editor (D165158)
Improved the Copy Data As > HTML functionality by resolving issues with data extraction from SSMS results and adding HTML styles for the Copy Data As > HTML > To Clipboard format (D164141, D166268)
Fixed the "Index and length must refer to a location within the string" error (D164540)
Implemented handling for system errors that occur during file system operations (D164284)
Improved the display of object lists in text tooltips (D164659, D164686, D164700, D166219, D167566, D167865, D167927, D167930, D168422, D168653)
Fixed an issue that occurred when working with projects (D165200, D165588, D164891, D165715, D167304)

Improvements:
Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer
Added integration support for Microsoft Visual Studio 2022
Added integration support for Microsoft SQL Server Management Studio 20.2
Added support for non-aggregated columns in GROUP BY statements
Added support for viewing the MSDescription property for databases
Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
Added support for the COLUMN MASTER KEY server object
Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
Added support for the TERTIARY_WEIGHTS function
Extended support for the AVAILABILITY GROUP constructs
Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History
Added CLI automation for Find Invalid Objects
Added Save Command Line for Find Invalid Objects
Added Save Command Line for SQL Formatter Wizard
Support for Implicit Procedure Execution
User-reported bug fixes:
Resolved issues that arose when selecting the case for automatic formatting of identifiers (T252989, T257652, T269036, T270192, T276488, T270192, D76531, D125424, p162685, T307930, T309179, u33847234, p188493, D89127)
Resolved the issue where invoking FORMAT SELECTION caused the query to become invalid (D123102)
Fixed the issue where the Convert EXEC to SQL functionality failed to function on queries without named parameters (D135198)
Fixed the behavior of CTE aliases in subqueries (D135239)
Fixed the behavior of object hints in the FROM clause within table-valued functions (D143009)
Resolved the issue where formatting scripts containing regions caused the query to become invalid (D145046)
Added the capability to set the QUOTED_IDENTIFIER and ANSI_NULL