Fix for incorrectly qualifying a column using the xml 'modify' method (Forum post).

Fix for execute current statement not selecting the whole ALTER TABLE statement (Forum post).

Fix for square brackets being incorrectly added around NO_INFOMSGS (Forum post).

Fix for an undocked query window losing focus in SSMS2016 and VS2015 (Forum post).Find Invalid Objects now reports objects as invalid if a connection to a linked server fails (Forum post).Experimental feature added to refresh the SSMS IntelliSense (UserVoice).Script as INSERT now outputs rowversion/timestamp columns as varbinary.

DBCC SHOW_STATISTICS now displays options when passing in string arguments (UserVoice).Column names in temp tables using quoted identifiers are now suggested.OLE DB provider names are now suggested for OPENROWSET and OPENQUERY.Improved suggestions when using GRANT with schemas (Forum post).The scale and precision of a data type are now shown in tooltips and summary windows (UserVoice):.Support for Azure Active Directory Integrated authentication and Azure Active Directory Password authentication (UserVoice).User account licensing - SQL Prompt now uses Redgate user account licensing, which makes it easier to keep track of the tools you own and move them between different machines.SQL Server 2016 syntax support - SQL Prompt now suggests and formats the following new SQL Server 2016 SP1 syntax:.OUTPUT parameter variables - Variables are now declared automatically for OUTPUT parameters when generating an EXEC statement (UserVoice).Add/remove AS keyword on alias definition for tables and views (UserVoice).Format actions for aliases - includes two new format actions:.Scripts that create or alter a procedure or trigger (UserVoice).Statements with an INNER JOIN (UserVoice).This replaces the dynamic SQL with static SQL. Also added inline EXEC sp_executesql (UserVoice).Added ability to inline EXEC stored procedures and scalar functions in a query window (UserVoice).

Disable SQL Prompt formatting for certain blocks of code.

Create multiple formatting styles and switch between them.

Share your formatting styles with other SQL Prompt users by storing them in a shared folder.

Create your own style by using one of the new built-in Redgate styles as a starting point.

Added more options for formatting CASE statements, JOINs, CTEs, CREATE TABLE statements, IN values, and more.

Improved SQL formatting - includes a new experimental version of the Format SQL feature, the formatting styles are now much more customizable.

Redgate sql prompt formatter batch