Released: Oct 7, 2025

11.1.3.18786 での更新項目

機能

• Added a scroll bar to the explain window of Prompt AI, making it easier to look through longer explanations.

不具合の修正

• Fixed refactoring issue for built-in functions like JSON_ARRAY and JSON_OBJECT on Azure SQL Server.
• Fixed null reference exception that could trigger when a SSMS/VS query window would gain/lose focus rapidly.
• Fixed null reference exception that could trigger when SSMS/VS did not have focus.

Released: Sep 25, 2025

11.1.2.18525 での更新項目

機能

• Improvements to error handling for different kinds of AI responses.

不具合の修正

• Fixed an issue where closing the Welcome to SQL Prompt AI! screen would cause the keyboard controls to become locked for the whole editor.
• Fixed formatting issue when the query has nested "AND" and "OR" inside parentheses.

Released: Sep 19, 2025

11.1.1.18395 での更新項目

機能

• You can now select (e.g. mouse/CTRL+A) and copy (e.g. context menu/CTRL+C) content from SQL Prompt AI's Explain SQL text box.
• A give feedback link has been added to the Prompt AI window to make it easier to share your thoughts with us.
• You can now use Prompt AI with databases of unlimited size. In previous versions Prompt AI had a limit on the number of database objects and their size.

Released: Sep 9, 2025

11.1.0.18267 での更新項目

機能

• Prompt+ has been promoted to General Availability (GA) with a new name Prompt AI.
• Prompt AI is now available to all subscription users without any additional registration or participation in the EAP program required.
• EULA has been updated.
• AI history is now stored in a separate tab instead of a collapsible region in the Prompt AI window.
• Stopped Prompt AI window moving erratically on certain actions.
• Added scrollbar for long AI prompts.
• Follow up suggestions are now limited to 1 to provide...

Released: Aug 19, 2025

11.0.8.17849 での更新項目

不具合の修正

• Fixed incorrect formatting for AS keyword.
• Fixed an issue in SSMS 18 that caused SQL Prompt to throw an error when used with the latest release of SQL Source control.
• Fixed an issue causing SSMS to crash when connecting to SQL Server with mandatory encryption.
• Fixed an issue that allowed multiple simultaneous requests in the Prompt AI window.
• Fixed formatting issue for JSON_ARRAY and JSON_OBJECT Functions.
• Fixed incorrect formatting for BEGIN and THROW statement.

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.