UpgradingPlease upgrade by selecting the SQL Prompt 5 > Help > Check for Updates... menu item (or SQL Prompt 5 > Check for Updates... in version 5.0). If this doesn't work for you, then you can download the update directly.SQL Prompt 5.3 replaces earlier releases of SQL Prompt. The installer will automatically uninstall earlier versions of SQL Prompt if present.

Upgrading from SQL Prompt 5.x: the upgrade should be seamless and all customizations will remain intact.

Upgrading from SQL Prompt 3.x: none of your customized options settings or snippets from SQL Prompt 3 will be imported into SQL Prompt 5. You may wish to take screenshots before upgrading for your reference.

SQL Refactor: SQL Prompt 5 replaces SQL Refactor. The installer will automatically uninstall SQL Refactor if it is present on the system. Saved layouts from SQL Refactor will not be automatically migrated: the Lay Out SQL feature is superseded by SQL Prompt's Format SQL feature.

Existing users of SQL Prompt 4 and below without the Support and Upgrades package: You will have a trial license when you install SQL Prompt 5.3. To continue using SQL Prompt 5 after the trial period, you will need to purchase a new license.

Existing users of SQL Prompt 4 and below with the Support and Upgrades package: If you already have a valid license number for version 4 or below of SQL Prompt, purchased with the Support and Upgrades package, then you can use the same license to activate SQL Prompt 5 manually.

Existing SQL Refactor users with the Support and Upgrades package: If you already have a SQL Refactor valid license number purchased with the Support and Upgrades package then you are entitled to a free upgrade to SQL Prompt 5 Professional Edition. Please contact sales@red-gate.com for details.

RequirementsSQL Prompt 5 is primarily designed to work with SQL Server Management Studio 2005, 2008 and 2012. Reduced functionality is also available in Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010. Please note that SQL Prompt 5 no longer supports Query Analyzer; if you need to work with Query Analyzer then please continue to use SQL Prompt 4.

Basic support for most synonym types, so SQL Prompt notices when the base object is a table, stored procedure, view, function, etc.

CREATE SYNONYM script is now shown in the object definition box for synonyms.

Fixed problem caching when base object for synonym is inaccessible (e.g. due to offline database or inadequate permissions).

Other Changes

Suggestions box will now pop up after inserting a snippet (if it's appropriate to do so)

On installation, a link to SQL Prompt's Getting Started page is put into the Start Menu

Added a MaxSupportedColumns parameter in [color=darkred]RedGate_SqlPrompt_Engine_EngineOptions.xml

, which will prevent SQL Prompt from trying to cache databases with a total number of columns exceeding this number. The default is -1, which allows all databases to be cached (related to SP-1207)Bug Fixes

Script As ALTER will now always fetch the up-to-date script directly from the database, rather than using SQL Prompt's cached version

Suggestions box no longer jumps around when the schema name is displayed (by using the little arrow at the bottom-left of the suggestions list)

Fixed problem decrypting encrypted objects in SQL Server 2012 RC0

Snippets are now listed in alphabetical order on first creation

Connection colouring experimental feature now saves servers.xml in the settings directory, not the current working directory (i.e. in many cases, on the desktop). If you use this experimental feature then you will need to reconfigure whether your servers are Production, Development, etc.

Changed method for loading Labs experimental features, which should prevent the Could not load file or assembly 'RedGate.SharedSSMS' errors that are being encountered by some Visual Studio users.

SQL Prompt 5.2.6 - February 2012(version 5.2.6.1)The following is a summary of the changes in version 5.2.6.

Synonym suggestions (partial support)

New SQL Prompt Labs feature in development.

Display all synonyms in the db as table candidates.

DROP SYNONYM lists synonyms as candidates.

Synonym base object names are displayed in the candidate list.

Note: column names from the base object are not yet suggested. This is expected in a future release.

Bug fixes

Fixed format SQL with a selection so that selection is not lost and errors outside of the selection are ignored (SP-4280)

Ensure that completions are not inserted during an undo/redo operation to avoid breaking the redo stack (also fixes failure to format/refactor immediately after undo) (SP-3339)

SQL Tab Magic – better SSMS session management with a large number of open query tabs.

SQL Test – unit test add-in for SSMS.

Experimental features are subject to change or removal in future versions. Eventually they may become part of SQL Prompt or, in some cases, a separate Red Gate product. We rely on user feedback to make these decisions, so please take a moment to tell us what you think of the experimental features by following the Provide Feedback links on the Labs page.

Find Invalid ObjectsSQL 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 windowIf 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 dependenciesSQL Prompt 5 enables you to view a list of objects that reference a column.

SQL Refactor functionalitySQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including the following: