SQL Prompt 10.10 release notes
Published 30 November 2021
10.10.4.26165 - Released on 18th January 2022
Features
- Added better detection for when the Replace Select Into With Create Table (PE003) autofix is available.
- Added the ability to open SQL Dependency Tracker from the object definition window when viewing an object's dependencies. (SQL Toolbelt Essentials license required)
Added suggestions for existing resource pools for ALTER and DROP statements.
Fixes
- Fixed an error with the autofix for Add Columns To Insert Statement (BP004) where it would fail for certain syntax.
Fixed an issue where BEGIN END blocks could be incorrectly indented within IF ELSE statements.
10.10.3.25844 - Released on 4th January 2022
Features
- Added support for multiple file encodings to bulk formatter.
Fixes
- Fixed an error where tab history sometimes crashes after executing a query.
- Fixed an issue where non-ranked suggestions would not be shown in alphabetical order.
- Fixed a missing tab coloring menu in the registered servers view.
- Fixed an issue where tabs could appear multiple times in the tab history window.
10.10.2.25539 - Released on 9th December 2021
Fixes
- Fixed an issue where partition schemes would not show in the script preview for Azure SQL Database.
- Fixed a crash that could occur in the tab history window.
- Fixed an issue when auto-fixing ST008 on synonyms.
10.10.1.25407 - Released on 2nd December 2021
Fixes
- Fixed a crash when opening the formatting styles dialog without having an active query window open.
- Fixed an issue where database triggers were not being suggested when schema filtering is turned on.
10.10.0.25384 - Released on 30th November 2021
Features
Added the ability to share snippets with other users via the Redgate Platform. (SQL Toolbelt Essentials subscription license required)
Added suggestions for existing functions when altering partition functions.
Added suggestions for existing schemes when altering partition schemes.
Fixes
- Fixed an issue where including a column definition IDENTITY property could cause issues with suggestions for Azure SQL Database.
- Fixed an issue where Tab History entries sometimes couldn't be renamed.
- Fixed an issue where suggestions would not be given for column aliases in some UPDATE or DELETE queries.