9.2.9.6459 - September 13th 2018

Fixes

• SP-7140 : Fixed a problem with the initialisation of the List of Code Analysis Issues.

9.2.8.6358 - September 5th 2018

Fixes

• SP-7207 : Fix of SSMS crash when activating suggestions.
• SP-6813 : Fixed DEP026 incorrectly flagging geography types as deprecated.

9.2.7.6282 - August 30th 2018

Fixes

• SP-7026 : Formatting lowercasing column names incorrectly.
• SP-7133 : False positive in code analysis issue IE028 (Adding NOT NULL column without default value) when adding a PERSISTED computed column.
• SP-7173 : False positive in code analysis issue EI003 (Non-scalar subquery in place of a scalar) when using "FOR JSON".
• SP-6841 : PE018 now supports READ ONLY in ISO syntax.

9.2.6.6145 - August 21st 2018

Fixes

• SP-6763 : No longer adds square brackets around CONCAT_WS, TRIM and STRING_AGG when connected to an Azure database.

• SP-6924 : Don't qualify names in rowsetfunctions during refactoring.

• SP-7141, SP-7142 : Prompt was improperly dealing with graph match predicates.

• SP-7150 : Fixed alignment of default parameter values when formatting stored procedures.

• SP-7168 : Fixed loading of SQL Prompt in Visual Studio 2017 15.8.

9.2.5.6073 - August 10th 2018

Fixes

• SP-7166 : Fixed crash 'Could not find loaded version of SqlWorkbench.Interfaces' when loading Prompt in Visual Studio.

9.2.4.6028 - August 2nd 2018

Enhancement

• The list of issues UI is now fully accessible, regardless of it's width.

Fixes

• SP-7147 : Incorrect indentation of collapsed expressions.

9.2.3.5933 - July 25th 2018

Fixes

• SP-7056 : Prompt improperly formatting CAST functions.
• SP-7058 : Added support for module classes (OBJECT and ASSEMBLY) in ADD SIGNATURE statements.

9.2.2.5855 - July 18th 2018

Enhancement

• Double-clicking a row in the list of issues now automatically updates the issue details pane to the currently highlighted issue.
• Save list of issues pane UI settings (e.g. sorting direction, column order) between sessions.
• Fixed a problem affecting the background colour and alignment text of some combo boxes.

Fixes

• SP-7098 : Fixed a bug where re-sorting the list of code analysis issues caused all expanders to collapse (when grouping by issue type).
• SP-7131 : Fix crashes that occur when using a new licence.

9.2.1.5713 - July 4th 2018

Enhancement

• SP-7088 : Export in list of issues in code analysis contains column headers.

Fixes

• SP-6663/SP-6907 : Prevent qualify object names refactoring from throwing error on scripts containing procedure bodies.
• SP-6997/SP-7023/SP-7109 : Fix regression of suggestions in subqueries.

9.2.0.5601 - June 27th 2018

Features

• In addition to "as you type" code analysis, you can now also display a dockable list of all the issues in your currently selected script window (click here to find out more).
  • This is accessible via the Prompt menu : SQL Prompt > Show List of Code Analysis Issues....
  • 

Fixes

• SP-7033 : Collapsed alignment layout options could cause formatting to fail when dealing with optional parentheses.
• Improved performance of background code analysis.