SQL Prompt 10

SQL Prompt 10.16 release notes

10.16.13.17064 - Released on 18 June 2025

Authentication to Azure SQL Database using Entra ID now utilizes the Redgate public client application. If your environment requires Azure Entra multifactor authentication (MFA), you must upgrade to this build for Prompt to continue working. 

Fixes

  • Entra ID authentication to Azure SQL Database now uses the Redgate public client application - Learn more

10.16.12.16519 - Released on 08 May 2025

Fixes

  • Fixed broken autocomplete of procedures involving string parameters.
  • Fixed incorrect square bracket refactoring issue for system functions.
  • Fixed formatting for COMMIT TRAN within IF statement.

10.16.11.16409 - Released on 24 April 2025

Fixes

  • Fixed formatting of OPENROWSET to make it consistent with other built in functions.
  • Fixed an issue where SQL Prompt does not provide suggestions when IS DISTINCT FROM is used.
  • Fixed an issue where "WAIT_AT_LOW_PRIORITY" is not a valid index option in 'CREATE INDEX'.
  • Fixed an issue where TYPE was being formatted incorrectly.
  • Fixed login issue in SSMS for Azure managed instance using Entra ID MFA.

10.16.10.16350 - Released on 21 April 2025

Fixes

  • Fixed ST010 rule to avoid incorrect table alias suggestions within WAITFOR RECEIVE statements.
  • Fixed SQL Prompt installation related issue for SSMS21.
  • Fixed an issue where F12/Go to definition was not working on SSMS 21 (Preview 6).
  • Fixed issue to handle SSMS crash when smart rename is performed on a memory-optimized table.

10.16.9.16203 - Released on 01 April 2025

Fixes

  • Fixed an issue where SQL History failed to search starred, opened and closed queries.

  • Fixed nested comments impacting parameter suggestions.

10.16.8.16147 - Released on 25 March 2025

Features

  • Added remove aggregate results functionality.

Fixes

  • Fixed SQL Prompt not loading automatically on start of SSMS 21.
  • Fixed error when offering parameter suggestions on Exec statement.
  • Fixed formatting error when using AT TIMEZONE.
  • Added missing suggestions for SERVERPROPERTY.

10.16.7.15960 - Released on 05 March 2025

Fixes

  • Fixed issues in SQL History for SSMS 21 Preview
  • Fixed formatting inconsistencies for SELECT with FOR XML
  • Added fix for suggestions not loading for TRIM.
  • Fix accuracy of average for grid aggregate results.
  • Fixed suggestions for built in XML functions in cross apply
  • Fixed SQL History search highlighting incorrect keyword.

10.16.6.15646 - Released on 17 February 2025

Features

  • Added support for SSMS 21 Preview. (Preview Feature) Refer Documentation.

10.16.5.15563 - Released on 07 February 2025

Fixes

  • Fixed formatting of the SELECT statement nested within the CASE statements.

10.16.4.15307 - Released on 05 February 2025

Fixes

  • Fixed issue where Formatting and Suggestions Stop Working with STRING_SPLIT() in Functions.
  • Fixed issue where loading suggestions for Azure Synapse Serverless database was not working as expected.

10.16.3.14709 - Released on 16 January 2025

Features

  • Added option to configure retention period and delete SQL history query versions based on set days.

Fixes

  • Fixed a bug where SQL Prompt+ would show an error when logging in.
  • Fix table option formatting for Azure dedicated pool.
  • Fixed wrong formatting for CTE in TRY..CATCH block.
  • Fixed wrong formatting for AS keyword in function.

10.16.2.14461 - Released on 02 January 2025

Fixes

  • Fixed wrong auto completion issue for stored procedure parameter's default value.

10.16.1.14063 - Released on 18 December 2024

Features

  • Added distinct count functionality in aggregate results.

Fixes

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

10.16.0.13262 - Released on 04 December 2024

Fixes

  • 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.

Didn't find what you were looking for?