SQL Prompt 11.0 release notes
Published 04 December 2024
11.0.9.18131 - Released on 03 September 2025
Fixes
- Fixed formatting issues when BEGIN and THROW statements are used repeatedly within a single block.
- Fixed an issue preventing users from logging into the Redgate Platform via the SSMS menu bar dropdown.
- Fixed table script for an Azure SQL database that includes a Full-Text Index column.
11.0.8.17849 - Released on 19 August 2025
Fixes
- 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.
11.0.7.17604 - Released on 07 August 2025
Features
- 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. - Learn more
Fixes
- 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.
11.0.6.17341 - Released on 07 July 2025
Fixes
- 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 autocompletion of stored procedures that contain the "WITH EXEC AS" clause.
- Added suggestion support for 'IDENTITYPROPERTY'.
- Fixed an issue where OBJECT DEFINITION scripts for views and stored procedures on Azure Dedicated Pools resulted in errors.
11.0.5.17209 - Released on 30 June 2025
Features
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. Learn more
Fixes
- Fixed performance issue caused by stored procedure parameters loading.
Fixed an issue where SQL scripts containing JSON_ARRAY or JSON_OBJECT would incorrectly auto-capitalize SQL reserved keywords (e.g. , AS INPUT), preserving the original casing as intended.
11.0.4.17149 - Released on 26 June 2025
Fixes
- 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.
11.0.3.17058 - Released on 17 June 2025
Authentication to Azure SQL Database using Entra ID now uses a Redgate Entra ID application. If your environment requires Azure Entra multi-factor authentication (MFA), you must upgrade to this build for SQL Prompt to continue working.
The permissions requested are limited to those required to access the database as your user, and your data remains within your infrastructure at all times. Redgate do not have any access to your databases, and SQL Prompt does not have access to any other services beyond Azure SQL Database.
Depending on your organization's Microsoft Entra ID policies, you may require approval from your Microsoft Entra ID administrator to grant SQL Prompt access when you first connect to an Azure SQL Database. They can review and approve this request by visiting Enterprise Applications, then Admin Consent Requests, in the Microsoft Azure portal.
Fixes
- Entra ID authentication to Azure SQL Database now uses the Redgate public client application - Learn more
- Fixed the formatting issue for OPENJSON
- Fixed formatting for WITHIN GROUP clause.
11.0.2.16884 - Released on 10 June 2025
Fixes
- Fixed issue while connecting with master database for Azure Dedicated Pools.
11.0.1.16766 - Released on 03 June 2025
Fixes
- Fixed an issue where user settings were not correctly migrated after prompt upgrade.
11.0.0.16715 - Released on 28th May 2025
Features
- Added support for SQL Server Management Studio 21 (Known Issue).
- Added support for Synapse Dedicated SQL Pools.
