ApexSQL Analyze release notes

Fixes:

• 211654: "Could not load file or assembly 'Microsoft.Identity.Client'" error is encountered when trying to connect to the Azure server with Active Directory - Universal with MFA type of authentication
• 211716: Couldn't connect to the targeted database in the case when using Azure Active Directory - Password authentication type while database name is typed in connection controls
• 211717: Couldn't connect to the targeted database in the case when using Azure Active Directory - Integrated authentication type while database name is typed in connection controls

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions

Known issues:

• "The 'ApexSOLAnalyzeJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started
• "Failed to authenticate the user in Active Directory (Authentication=ActiveDirectoryInteractive). Error code 0xno_client_id No ClientId was specified." Error is encountered when the Show dependencies feature is initiated and the user is connected to a remote server using Azure Active Directory - Universal with MFA authentication

ApexSQL Complete release notes

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions

Known issues:

• "The 'ApexSOLCompleteJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started

ApexSQL Decrypt release notes

Enhancements:

• Application telemetry now collects anonymous data on the use and performance of applications and application components

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions
• Trust server certificate option is added under the Connection options dialog

Known issues:

• "The 'ApexSOLDecryptJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started

ApexSQL Propagate release notes

Changes:

• The activation model is switched to Subscription
• Trust server certificate option is added under the Connection options dialog

ApexSQL Refactor release notes

Fixes:

• 105670: Excessive space is added in the SQL insert statement when the Smart indent option under the Formatting tab of the Options dialog is used
• 141333: ApexSQL Refactor add-in intermits Outline Statements functionalities within the application host query editor
• 146253: Columns name in the Encapsulate code window – Parameters grid inadvertently change upon Preview action
• 149177: Always use BEGIN and END in IF statements option for ELSE IF statements creates needless nesting and statements which compromise code cleanliness and visuals
• 149178: The Indent condition body statement option under the Flow control tab of the Options dialog does not work correctly
• 149179: The Indent code within BEGIN and END blocks options under the Flow control of the Options dialog does not work correctly
• 155332: The CASE statement will always be in a separate line even when all options are turned off
• 156920: Insert empty line before each statement option under the Formatting tab of the Options dialog does not work for the SET statement
• 157146: The formatting profile does not format SQL code correct if the Year functions is used within the last query line
• 159490: Logical operations options under the Logical tab of the Options dialog have unnecessary vertical and horizontal scrollbars on high DPI and 4K resolution
• 160381: Needless semicolon and identation occur before ELSE statement of the IF-ELSE block
• 161819: Missing two carriage returns in the info message that appears when formatting the SQL script that already exists on the drive via the Format SQL scripts feature
• 163291: This operation requires a SQL file or query editor to be opened info message appears when using the Format SQL command over a solution
• 195537: The Format SQL objects command loads only the objects from the default database
• 195538: "Selected object cannot be found in Object explorer" error is encountered when the Safe rename feature is used on the non-default database
• 198444: SQL Server Management Studio stops working when formatting is called on highlighted code from the query editor
• 198746: "Error occurred in Formatting SQL objects functionality" error is encountered when using the Format SQL objects feature over a database that contains an apostrophe in the name
• 199488: The Remove unnecessary brackets option under the Formatting tab of the Options dialog removes brackets around the SQL status keyword

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions

Known issues:

• "The 'ApexSOLRefactorJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started

ApexSQL Script release notes

Fixes:

• 190810: "Length cannot be less than zero" error is encountered when deleting the default destination path for saving scripts in the Script folder options step of the Script wizard
• 193565: "Parse error: [Incorrect syntax near 'IF']" error is encountered when using the If exists statement for constraint or column in the Alter table or Drop statement
• 202226: "Parse error: [Incorrect syntax near 'ORDER']" error is encountered when trying to generate a script that contains the Order operation with a click on the Script button in the Home tab
• 203169: "Parse error: [Incorrect syntax near 'UNION']" error is encountered when trying to generate a script that contains the Union operation with a click on the Script button in the Home tab
• 203468: Exclude [/exc] switch in the CLI does not work when multiple object types are combined
• 205738: A single executable file is generated when multiple databases are selected for a scripting process

Changes:

• The activation model is switched to Subscription
• Trust server certificate option is added under the Connection options dialog

ApexSQL Search release notes

Fixes:

• 162811: A selected database from Object Explorer is not automatically targeted within Object search controls when a search is initiated from the toolbar
• 165044: Application default shortcuts under the Options dialog cannot be modified and saved
• 165047: SQL Server Management Studio stops working when the ellipsis button is clicked from the result grid under the Column value of the Text search pane and the user is connected to a remote server using Azure Active Directory - Integrated authentication
• 165725: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project. You must save the unsaved document(s) before cutting or copying them." error message appears when either Ctrl+C or Ctrl+X command is used from the Search text box of the Text search panel
• 165732: The Text search feature does not find any results when the search string has either leading or trailing whitespace characters in the search phrase
• 165734: Initiated text search is not cancelled when the Text search pane is closed
• 172022: Text search feature does not work when invoked against an Azure SQL database and the user does not have access to the master database
• 186418: Unable to determine which connection is being used to perform either an object or data search from the drop-down list of distinct server names under the Database section
• 194476: Objects search and Text search features do not work when clicked from the toolbar if no server is previously selected from either SQL Server Object Explorer or Server Explorer in Visual Studio
• 199489: "Insufficient permissions to access master database" info message is shown when either Object search or Text search is initiated and the user is connected to a remote server using Azure Active Directory - Integrated authentication
• 200245: Text search feature does not return any results if the search scope has a table with a column of either money or smallmoney data types

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions
• Ignore whitespaces option is added for the Text search feature for easier control of the search scope

Known issues:

• "The 'ApexSOLSearchJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started