#Red gate software ltd sql prompt 5 update#

Smart Rename and Split Table refactorings are now no longer supported for SQL Server 2000/2005. SP-7830 : Fixed issue that caused formatting to fail in Visual Studio 2019 16.3.1 and above.SP-7827 : Fixed an issue where scripts containing HISTORY_RETENTION_PERIOD syntax would sometimes fail to format.

#Red gate software ltd sql prompt 5 update#

SP-7826 : Fixed an issue which would sometimes cause formatting to fail when applied to a script containing a PIVOT clause within an UPDATE statement.

SP-7754 : Fixed scenario that could lead to corruption of Prompt Options during export to a zip archive.

Added suggestions for COMPATIBILITY LEVEL values for all supported versions of SQL Server.

Added suggestions support for ADD/DROP SENSITIVITY CLASSIFICATION syntax introduced in SQL Server 2019.

We would love to hear your feedback on this new feature.

Added a new ranked ordering option for suggestions.

SP-7616 : To avoid confusion, disabling Tab History in the options menu now disables the Tab History toolbar button.

Added support for the index options RESUMABLE and MAX_DURATION in CREATE INDEX statements, introduced in SQL Server 2019.

Added support for the APPROX_COUNT_DISTINCT aggregate function, introduced in SQL Server 2019.

Tabs are now shown in time buckets, making them easier to search through.

You can now star the tabs you use most often, so they're easier to find and restore when you need them.SP-7847 : Fixed an issue which would sometimes cause the Tab History/Code Analysis UI to fail to load.