SQL Prompt Pro

What's New in SQL Prompt Pro V5.0
SQL Prompt 5 includes a number of significant new features:

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 Professional Edition, including the following:

• Smart Rename
• Qualify Object Names
• Expand Wildcards
• Split Table
• Encapsulate as New Stored Procedure
• Find Unused Variables and Parameters
• Summarize Script

SQL Prompt 4 Release notes

• Enhanced user interface
  The user interface for intellisense suggestions and object definitions has been redesigned to be less intrusive and to make SQL Prompt's features more easily discoverable.
  The Options dialog box has also been completely reinvented, with better navigation and a rationalised set of options.
• Improved SQL Grammar support
  Enhanced T-SQL grammar support for SQL 2000, SQL 2005 and SQL 2008 SQL server editions. Suggestions are more accurate and reliable, and cover a more extensive scope of T-SQL.
• Performance improvements
  SQL Prompt 4 caches database objects dramatically faster than SQL Prompt 3, and does so much more quickly across high latency networks. 
• Snippet enhancements
  Snippets are now stored as separate files, and so can be easily shared among other SQL Prompt users.
  There is a new, separate interface for creating and managing your snippets, including an option to go to the folder where snippets are stored.
• Column picker
  The column picker has been radically improved, so that it is simpler to find and use, for example it is now clearly labelled, and shows the number of columns currently selected.
• Options
  Many SQL Prompt 3 options have been removed and replaced with sensible defaults, to simplify the configuration and make more intuitive behavior. The Options dialog box itself has been drastically re-engineered so that it is much quicker to find the option you want, understand its purpose, and preview its effect.
• Right-click context menus
  Right-click context menus have been implemented inside your query editor for creating SQL Prompt snippets and applying your preferred formatting to code.
• Temporary storage only of database objects on disk
  Database objects are only cached during your current session. When closing down your query editor, the SQL Prompt object cache is emptied, to save disk space. Offline mode working is therefore no longer supported.
• Format styles (Pro feature)
  Styles allow you to save and share your format options with other SQL Prompt users.
• Decrypts encrypted objects: (Pro feature)
  SQL Prompt 4 can now decrypt encrypted objects from SQL 2000, SQL 2005 and SQL 2008 to allow you to view their creation script.
• Importing snippets and aliases
  As a major new installation, existing user-created snippets and aliases or your old configuration options will not automatically be imported into v4. Red Gate offers two free tools that help migrate snippets and aliases from v3.9, Snippet migrator and Alias importer.

Installing SQL Prompt 4 will disable SQL Prompt 3 and start a new trial period. If you wish to re-enable SQL Prompt 3 you will need to uninstall SQL Prompt 4. If you have user-defined aliases or snippets in SQL Prompt 3 which you wish to retain, we have a migration tool available.

SQL Prompt

• Write SQL fast and accurately with code completion
• Understand code more easily with script layout
• Continue to use your current editor – SQL Prompt works within SSMS, Query Analyzer, and Visual Studio
• Keyword formatting, join completion, code snippets, and many more powerful features

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press CTRL+SPACEBAR or when you type "." after a table/view/alias name.

SQL Prompt Pro - Intelligent code completion for SQL Server plus layout for easy code readability.
SQL Prompt Standard - Intelligent code completion for SQL Server.

SQL Prompt works with Visual Studio 2005 and 2008, Query Analyzer, SQL Server Management Studio 2005 and 2008, and SSMS Express Edition.

Feature list

• Table/View/Column/Sproc name completion
• Layout makes scripts easy to read
• JOIN/JOIN ON syntax completion
• Expand wildcard to column names list
• Object creation-SQL viewing pane
• Mouse-over tool tips that give object definitions including a useful summary
• Parameter hinting for user-defined functions
• Cross-database queries
• Distributed queries with linked SQL Server instances
• Scripted objects included in candidate list
• Cursors, cursor variables, and related statements
• Auto-uppercasing of keywords and pop-up after keywords
• Column selector screen, plus qualify object/column names option

Purchasing a support contract provides you with free upgrades as well as support.

• Upgrades - For the duration of the support contract you will not need to pay for upgrades.
• Support - For the duration of the support contract, you will receive support on the use of the products by email and, if necessary, by telephone or video conference.