SQL Prompt 11.0 release notes
Published 04 December 2024
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.
