Released: Aug 7, 2025

11.0.7.17604 での更新項目

機能

• Added options to disable the SQL Prompt+ AI selection icon and empty window text.
• Added support for authenticating with Microsoft Entra ID using custom Client ID, Redirect URI, and Scopes.

不具合の修正

• Fixed formatting issue occurring when THROW is used inside a BEGIN…END block.
• Fixed an issue that occurred while formatting SQL scripts generated for the 'ALTER VIEW' operation.

Released: Jul 7, 2025

11.0.6.17341 での更新項目

機能

• Added suggestion support for 'IDENTITYPROPERTY'.

不具合の修正

• Fixed an issue preventing SQL Prompt installation when SSMS 21 was located on a drive other than the C: drive.
• Fixed an issue causing incorrect auto-completion of stored procedures that contain the "WITH EXEC AS" clause.
• Fixed an issue where OBJECT DEFINITION scripts for views and stored procedures on Azure Dedicated Pools resulted in errors.

Released: Jun 30, 2025

11.0.5.17209 での更新項目

機能

• Added Analyze Query Indexes feature to help understand the impact of indexes on query performance. Simply right click on a SELECT query that has a JOIN or WHERE clause and select Analyze Query Indexes. Please note, you may need to log out of your Redgate license and log back in again from the Help\Manage License menu to enable this feature.

不具合の修正

• Fixed performance issue caused by stored procedure parameters loading.
• Fixed an issue where SQL scripts containing JSON_ARRAY or JSON_OBJECT would...

Released: Jun 26, 2025

11.0.4.17149 での更新項目

不具合の修正

• Fixed an issue related to user permissions in Azure Synapse Dedicated SQL Pool Integration.
• Fixed an issue in SQL history where search text containing the equals sign (=) did not return the expected results.

Released: Jun 17, 2025

11.0.3.17058 での更新項目

機能

• Entra ID authentication to Azure SQL Database now uses the Redgate public client application.

不具合の修正

• Fixed the formatting issue for OPENJSON.
• Fixed formatting for WITHIN GROUP clause.

Released: Jun 10, 2025

11.0.2.16884 での更新項目

不具合の修正

• Fixed issue while connecting with master database for Azure Dedicated Pools.

Released: Jun 3, 2025

11.0.1.16766 での更新項目

不具合の修正

• Fixed an issue where user settings were not correctly migrated after prompt upgrade.

Released: May 28, 2025

11.0.0.16715 での更新項目

機能

• Added support for SQL Server Management Studio 21.
• Added support for Synapse Dedicated SQL Pools.

Released: Dec 18, 2024

10.16.1.14063 での更新項目

機能

• Added distinct count functionality in aggregate results.

不具合の修正

• Fixed an issue where SQL Prompt was displaying inaccurate SQL Warning.

Released: Dec 4, 2024

10.16.0.13262 での更新項目

不具合の修正

• Fixed incorrect left alignment formatting issue for ALTER PROC.
• Fixed an issue impacting performance during parameter loading.
• Fixed an issue where spaces were removed after functions' close parenthesis in case statements.
• Fixed the lag in loading the SQL History window when opening it in SSMS.