SQL Prompt 8.0 release notes
Published 09 May 2017
Version 8.0.11.2296 - September 6th, 2017
Bug fixes
- SP-6580 : Fix Azure active directory universal authentication not working in SSMS 17.2.
- SP-6590 : Prevent SQL Prompt Pro being shown as SQL Prompt Core in Visual Studio.
Version 8.0.10.2247 - August 30th, 2017
Bug fixes
- Fix :Crash reporting no longer causes hard crashes on IDE.
Version 8.0.9.2226 - August 23rd, 2017
Bug fixes
- Improve error popup to ask users for their email address when an error occurs.
- SP-6454 :No longer convert columns in OUTPUT clauses to the 'alias = column' style.
- SP-6562 :Add support for CREATElogontrigger statements.
- SP-6565 :Fix ALTER COLUMN ENCRYPTION KEY statements having semicolons inserted in the incorrect position.
- SP-6564 :Fix formatting failing when a SEND ON CONVERSATION statement has no message type.
- SP-6571 :Fix format of MERGE statements when used as a table reference
- Fix :The 'Place FROM table on new line' option now affects tables in DELETE statements.
- Fix :"Trust Server Certificate" being required when connecting with SQL Server Authentication inSSMS2016 and higher.
- Fix :Possibility to block for 10 seconds when closing due to usage reporting.
Version 8.0.8.2086 - August 09th, 2017
Bug fixes
- SP-6082 :Fix High DPI issues when editing formatting styles.
- SP-6088 :Snippet editor now detects the new TRY_CAST syntax as a command.
- SP-6452 :Multiple constraints in the same CREATE or ALTER TABLE statements now break correctly.
- Fix:Fixed Prompt keyboard bindings assignment onfirstrun ofSSMS2012 andSSMS2014.
Version 8.0.7.1917 - July 26th, 2017
Bug fixes
- SP-6449 :Fix alternate alias change to AS alias when usedfunctionwithout space between FROM keyword.
Fix out of memory exception caused by repeatedly checking licensing information on system time change.
Version 8.0.6.1890 - July 19th, 2017
Bug fixes
- SP-6438 :Fix documentation links being incorrectly available forin-builtCLR functions.
- SP-6440 :Fix 'Find unused variables' not detecting assignment in UPDATE statements.
- SP-6441 :Fixstackoverflowcrashfor parse issue with a CREATE PROCEDURE script using an unknown function.
- SP-6444 :Improved word boundary matching used in suggestions and action lists.
- SP-6446 :Fix default values for T-SQL date and time data types in auto completion.
- SP-6447 :Fix formatting alter database statements with CURRENT keyword.
- SP-6456 :Hotfix for schema tooltips not showing.
Version 8.0.5.1758 - July 05th, 2017
Bug fixes
- SP-6358 :Fix FETCH .. INTO statements not right aligning to FETCH token.
- SP-6382 :Add new option to not place the JOIN keywords on a new line.
- SP-6397 :The 'Align Aliases' option now applies to table aliases in JOIN statements.
- SP-6414 :Align subsequent sub-clauses in an OVER clause to the PARTITION token.
SP-6423 :Fixsubqueriesin JOIN statements aligning toincorrecttoken.
SP-6428 :Fix failure when formatting ALTER TABLE .. REBUILD.
SP-6430 :Fix inline EXEC in SSMS2016.
SP-6432 :Fixinsertsemicolonin AlterDatabaseStatement with QUERY_STORE ALL parameter.
SP-6433 :Prevents a potential crash duringSSMSshutdown(tabcoloringdeactivation).
SP-6436 :Fix 'Collapse short DDL statements' not applying to CREATE and ALTER INDEX statements.
SP-6437 :Fix bug removing space between CASE and WHEN keywords inspecificcase.
Version 8.0.4.1638 - June 21st, 2017
Bug fixes
- SP-6424 :Fix failure on firstautocomplete.
- SP-6379 :Fix error with BETWEEN in an IIF call.
- SP-6370 :Fix rename alias not working withfunctioncall in create procedure statement.
- SP-6377 :Fix spaces around BETWEEN.
- SP-6425 :Fix random failure atstartofinstallationprocess.
Requirements
- SQL Prompt now requires .Net Framework 4.6.1 or later. You can download it from:https://www.microsoft.com/net/download/framework.
Version 8.0.3.1587 - June 14th, 2017
Bug fixes
- SP-6366 :Fix for error with backwards compatible CREATE INDEX options.
- SP-6368 :Fix IN statement opening parenthesis option not working with subqueries.
- SP-6371 :Several performance improvements to stylefilenameI/O operations.
- SP-6372 : Add support for inbuilt aggregate function GROUPING_ID().
Version 8.0.2.1508 - June 7th, 2017
Bug fixes
- SP-6321 : Fix for 'Invalid name character in Workstation ID' issue.
- SP-6345 : Fixed DB population of a SQL2005+ linked server when running in a SQL 2000 environment.
- SP-6348 : Indent body of create view.
- SP-6352 : 'Collapse short DML statements' option not working with some WHERE breaking combinations.
- SP-6356 : Column list indent and 'Align items across clauses' not working always.
- SP-6361 : Add support for 'ALTER DATABASE SCOPED CONFIGURATION'.
- SP-6362 : Format 'CREATE VIEW' columns correctly.
- SP-6365 : Nested clause indent support (Insert/select statement).
- Fix : Prevent crash when user attempts to rename to same style name.
- Fix : Prevent file overwrites when using invalid path characters in style names during style renames.
Version 8.0.1.1383 - May 24th, 2017
Features
- Added basic support for connecting to SQL Server 2017.
- Allow renaming styles in edit mode.
Bug fixes
- SP-6213 : Format exec parameters as insert source.
- SP-6250 : Fix Active Directory Universal authentication.
- SP-6253 : Type column overlayed.
- SP-6268 : New option to insert table on new line.
- SP-6330 : INLINE EXEC chops off END when sproc body is wrapped in BEGIN/END.
- SP 6334 : SQL Prompt 8 have issues formatting options HAVING BETWEEN.
- SP-6335 : Fix right align where exists.
- SP-6338 : Fix where condition in parenthesis not breaking.
- SP-6340 : Formatting/multiple collapse interaction.
- SP-6342 : Comments swapping on same line.
Version 8.0.0.1241 - May 11th, 2017
Features
- Improved Formatting options (UserVoice)
The formatting styles are now much more customizable. We've added many new options based on your feedback. Some of the new features include:- Add options for CASE WHEN ELSE END (UserVoice)
- Disable SQL Prompt on certain blocks of code (UserVoice)
- Quick switching between styles (UserVoice)
- Indent comments consistent with code (UserVoice)
- Support a common intending option for SELECT (UserVoice)
- Expose all formatting options in the UI (UserVoice)
- Format common table expressions (CTEs) (UserVoice)
- Simple, but toggle indenting of else if statements (UserVoice)
- Column aliases alignment (UserVoice)
- Moving commas from "end" to "start" is always buggy when comments exist (UserVoice)
- Remove extra space between statements option is needed (UserVoice)
- Line up type declarations (UserVoice)
- Place semicolon on new line (UserVoice)
- Option to place Table names on the same line as the keyword (UserVoice)
- Do not indent FROM and WHERE clauses (UserVoice)
- Merge command formatting options (UserVoice)
- Support for SSMS 2017 and Visual Studio 2017.
Please note that this release no longer supports SSMS 2008 R2 or earlier versions.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
