Released: Aug 18, 2015

Updates in this release

Updates in 7.0

Environment support
You can now use SQL Prompt in:

• Management Studio 2016 CTP2
• Visual Studio 2015

The following features are now available in Visual Studio 2012 or later:

• Find invalid objects
• Script as ALTER
• Execute current statement
• Rename variables/aliases
• Encapsulate as new stored procedure
• Split table

Red Gate removed support for Visual Studio 2005 and 2008.

Snippet manager improvements
You can now create your own placeholders in snippets.

Actions list
When you select some text in a query window, SQL Prompt now shows an actions button in the margin. Press Ctrl or click the button to open the actions list.

The actions list includes the following:

• Add quotes and commas
• Remove comments
• Comment/uncomment
• Unformat
• Snippets containing the new $SELECTEDTEXT$ placeholder 
• Other existing text actions (eg Format SQL)

Tab coloring improvements
You can now color a server group separately from the servers in the group. The lower status bar is now also colored.

Find invalid objects improvements
You now script invalid objects as DROP. The line containing the error is now highlighted.

Suggestions improvements

• Filegroups are now suggested and casing options are applied to them when you format
• Support for new FOR JSON clause
• Global variables are no longer suggested for assignment
• Indexes are now suggested for table hints
• MERGE statement suggestions improved
• Full suggestions for cross-database queries are disabled if a schema exists with the same name as the database
• Windows users and groups are now suggested for GRANT statements