Release notes - version 5.xx

Version 5.2 - November 3, 2011

Improvements
SQL Prompt 5.2 includes many improvements:
- All SQL Prompt features are now enabled in Denali CTP3 SQL Server Management Studio.
- SQL Prompt now works with Denali servers, with improved support for new keywords and built-in functions.
- More of SQL Prompt's script refactoring features are now available inside Visual Studio for the first time.
- You can now turn code auto-completion on/off using a new SQL Prompt menu option, or a keyboard shortcut (Ctrl + Shift + P).
- You can now press Shift + Tab when editing the code for a snippet to get back to the Description field.
Fixes
A number of issues have been fixed, including:
- A SQL Azure connection issue has been fixed.
- Expand Wildcards now works for system tables.
- Uppercase Keywords could sometimes change whitespace inadvertently. It now doesn't.
- Some resource leaks have been fixed, which should prevent some crashes in extreme cases.

Version 5.1 - April 12, 2011

Find Invalid Objects improvements
SQL Prompt 5.1 includes many usability improvements to the Find Invalid Objects feature:
- you can do more with the list of invalid objects, including locating objects in the Object Explorer, copying the list of invalid objects, and scripting multiple invalid objects as ALTER
  For full details, see: Finding invalid objects: Tips
- the number of invalid objects that have been found is displayed
- a progress bar is displayed when finding invalid objects
- you can change the server or database you want to find invalid objects in
Timeout errors are also much reduced or eliminated.
SQL Refactor favorites
The following has been included from SQL Refactor:
- Uppercase Keywords, as a separate feature from Format SQL
  For more information, see: Uppercasing keywords
- Ctrl+B Ctrl+L as a keyboard shortcut for Format SQL in SQL Server Management Studio (Ctrl+K Ctrl+Y is the primary shortcut)
Fixes
A number of bugs have been fixed, including:
- SQL Prompt 5.1 now works on SQL Server 2005 Express
- Fixed extreme slowdown with Common Table Expressions (CTEs)
- Prevented misleading Thread was being aborted message from being added to log
- Fixed a number of the most common crashes that cause a Notify Red Gate of this error dialog

Version 5.0 - December 15, 2010

Find Invalid Objects
SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.
Script Object as ALTER from a query window
If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.
View column dependencies
SQL Prompt 5 enables you to view a list of objects that reference a column.
SQL Refactor functionality
SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Pro Edition; including:
- Smart Rename
- Qualify Object Names
- Expand Wildcards
- Split Table
- Encapsulate as New Stored Procedure
- Find Unused Variables and Parameters
- Summarize Script