SQL Prompt Pro Releases
Released: Jun 26, 2019
Updates in 9.5.8
Updates in 9.5.8
- SP-7656 : Fixed a bug where necessary whitespace would sometimes be omitted within the migration script when using Smart Rename.
- SP-7679 : Fixed a bug which would sometimes cause formatting to fail when extra semi-colons were present in scripts.
Released: Jun 17, 2019
Updates in 9.5.7
Features
- The CamelCase navigation shortcut option has been moved out of the experimental features section to a new "Navigation" section.
- Added a "Welcome Window" to SQL Prompt that keeps you informed about new features in SQL Prompt and provides you with plenty of useful links.
Released: Jun 6, 2019
Updates in 9.5.6
Features
- Added an execution warning for DROP statements, which can be found in the options menu under Suggestions > Warnings & highlighting > Execution Warnings. This option is off by default.
- You can now access the latest release notes for SQL Prompt from the help sub-menu (SQL Prompt > Help > Release Notes).
Fixes
- SP-7618 : SQL Prompt now suggests server roles in the relevant scenarios.
Released: May 23, 2019
Updates in 9.5.5
Updates in 9.5.5
- SP-7626 : Fixed crash complaining about missing DLL that could occur when running Summarize Script, Encapsulate as a New Stored Procedure, Split Table, Smart Rename or Find Unused Variables and Parameters.
Released: May 22, 2019
Updates in 9.5.4
Updates in 9.5.4
- SP-6941 : Fixed an issue where formatting places ORDER BY clause on the next line when it is within WITHIN GROUP
- SP-7232 : Add suggestion support for some missing system functions: CONNECTIONPROPERTY, CURRENT_REQUEST_ID, CURRENT_TRANSACTION_ID and ORIGINAL_DB_NAME.
- SP-7583 : Fixed an issue where formatting ALTER INDEX within an ALTER TABLE statement would throw an error.
- SP-7596 : SQL Prompt now supports `TEMPORAL_HISTORY_RETENTION` and `HISTORY_RETENTION_PERIOD` keywords when...
Released: May 14, 2019
Updates in v9.5.3
Features
- Now promotes recently used suggestions to the top of the suggestions box. This feature is enabled by default and persists only for the current session. It can be disabled on the Suggestions > Behavior page, under Show code suggestions.
- Added the ability to download the installer instead of running it when SQL Prompt informs that there is a new version available.
Fixes
- SP-7558 : Find Invalid Objects now reports triggers that are on non-existent tables.
Released: May 3, 2019
Updates in 9.5.2
Features
- Added a `Show all issues` link to the autofix popup window.
Fixes
- Fixed an issue which was preventing SQL Prompt from launching when upgrading from a previous version.
- Fixed an issue which would sometimes cause unwanted newlines to be inserted into scripts generated from `Script Object as ALTER`.
- Fixed an issue which caused the `Smart Rename`, `Encapsulate Object as Stored Procedure` and `Split Table` features to not work for some users.
Released: Apr 25, 2019
Updates in 9.5.0
Features
- Adds support for SQL Server Management Studio 18.
- Adds support for Visual Studio 2019.
- Now requires .Net Framework 4.7.2 or later.
Fixes
- SP-7522 : Fixed an issue of incorrect wildcard expansion from a nested SELECT containing CASE.
- SP-7545 : Fixed an issue where aliases were not being suggested within nested scopes.
Released: Apr 8, 2019
Updates in 9.4.16
Features
- Optimized start-up time when a large number of tabs are being restored.
Released: Mar 28, 2019
Updates in 9.4.15
Features
- You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases.
Fixes
- Qualify Object Names no longer unqualifies parameters of rowset functions.
- EI028 no longer fires on IDENTITY columns.
- Format SQL no longer throws an error when trying to format TRIM statements that specify which characters to trim.
