SQL Prompt 10

SQL Prompt 10.10 release notes

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.



Didn't find what you were looking for?