Options
SQL Prompt 3.9 has been released
![[Deleted User]](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
[Deleted User]
Posts: 0
We are very pleased to announce the release of SQL Prompt v3.9. You can get it from
http://www.red-gate.com/products/SQL_Prompt/index.htm
This is a recommended upgrade for all current SQL Prompt users who would like to use SQL Prompt on SQL 2008 client.
Layout will work on the new SQL 2008 syntax.
Bug Fixes:
• We have attempted to fix a layout exception reported by quite a few customers. (We cannot completely guarantee the fix as we have not been able to replicate the issue to test for the specific issue.)
• Fixed an exception caused in Visual Studio
• Fixed the issue wherein SQL Prompt blocks the installation of SQL Server 2008
Please bear in mind the following tips when installing the new version:
• SQL Prompt 3.9 should seamlessly upgrade your options files and snippets; however you may wish to make a backup of these files prior to upgrading. Generally they are stored in “C:\Documents and settings\{Your username}\Local Settings\Application Data\Red Gate\SQL Prompt 3â€.
• If you also use SQL Prompt 2 you do not need to uninstall it, however when working with version 3.8 you should disable it to avoid having two sets of code completion pop up.
• Please note that if you are upgrading to SQL Prompt v3.9 from some older instances you will have to delete your old CompletionConfiguration.xml file to ensure you get the new SQL 2008 updated keyword list. This file is located in (default setting) “C:\Documents and settings\{Your username}\Local Settings\Application Data\Red Gate\SQL Prompt 3â€. All prompt instances(including SQL Prompt tray app.exe will have to be shut down during this process and the CompletionConfiguration.xml file will automatically get regenerated when you restart SQL Prompt)
Kind regards,
Tanya Joseph
SQL Prompt 3.8 Project Manager
Red Gate Software Ltd
http://www.red-gate.com/products/SQL_Prompt/index.htm
This is a recommended upgrade for all current SQL Prompt users who would like to use SQL Prompt on SQL 2008 client.
Layout will work on the new SQL 2008 syntax.
Bug Fixes:
• We have attempted to fix a layout exception reported by quite a few customers. (We cannot completely guarantee the fix as we have not been able to replicate the issue to test for the specific issue.)
• Fixed an exception caused in Visual Studio
• Fixed the issue wherein SQL Prompt blocks the installation of SQL Server 2008
Please bear in mind the following tips when installing the new version:
• SQL Prompt 3.9 should seamlessly upgrade your options files and snippets; however you may wish to make a backup of these files prior to upgrading. Generally they are stored in “C:\Documents and settings\{Your username}\Local Settings\Application Data\Red Gate\SQL Prompt 3â€.
• If you also use SQL Prompt 2 you do not need to uninstall it, however when working with version 3.8 you should disable it to avoid having two sets of code completion pop up.
• Please note that if you are upgrading to SQL Prompt v3.9 from some older instances you will have to delete your old CompletionConfiguration.xml file to ensure you get the new SQL 2008 updated keyword list. This file is located in (default setting) “C:\Documents and settings\{Your username}\Local Settings\Application Data\Red Gate\SQL Prompt 3â€. All prompt instances(including SQL Prompt tray app.exe will have to be shut down during this process and the CompletionConfiguration.xml file will automatically get regenerated when you restart SQL Prompt)
Kind regards,
Tanya Joseph
SQL Prompt 3.8 Project Manager
Red Gate Software Ltd
This discussion has been closed.
Comments
Version 3.8 minor release -- 23 April, 2008
_________________________________
Changes:
- Object definition hints
- Function parameter hints
- Layout (Pro edition feature)
- Summarized object view in Schema Panel
- VS 2008 support
- Basic SQL 2008 client support
Bug fixes:Version 3.7 private release -- 14 January, 2008
_________________________________
Changes:
- Installer support for VS 2008.
- Logging enhancements to help us capture logs to rectify hard to replicate issues.
Bug fixes:- Invalid object name exception - a check has been introduced where the name is null before trying to resolve any candidates
- Fix for an InvalidCastException
- Fix for ‘Unable to refresh or cache database. Item has already been added’ exception
- Exception in SSMS when closing windows with alt f4
- Exception when ctrl-tab between query windows in Query Analyzer
- Unhandled Exception dragging View to Query Analyser
- Does not learn aliases in QA when opening a file
- SQL Prompt hangs for several seconds after typing a '.' when qualifying an object name
Version 3.6 Minor release -- 17 September, 2007_________________________________
- Improved Visual Studio 2005 support – edit any SQL file regardless of whether or not it is associated with a project
- Microsoft® Visual Studio Team Edition for Database Professionals (Data Dude) support
- Scripted object support. Tables, temporary tables, views, stored procedures and functions created in your scripts with CREATE XXX statements now appear in the completion list.
- CTEs
- Added or significantly improved support for the following SQL statements:
- Further improved performance. Notably, users who experienced hangs of up to several seconds in 3.5 after entering a ‘.’ with cross-database support enabled, will find that this problem is fixed
- Fixed crash that occurred when files were opened with line endings consisting of only carriage returns
Version 3.5 Major release -- 26 July, 2007- GRANT, REVOKE, DENY
- Control flow statements (IF, WHILE etc)
- Transaction control statements (BEGIN, COMMIT, ROLLBACK)
- ENABLE and DISABLE TRIGGER
_________________________________
- Visual Studio 2005 database project support
- Cross database queries
- Distributed queries across linked SQL Server instances
- Correlated subqueries
- 3 – 5 times faster metadata retrieval
- Large script support
- 40 – 95% decrease in memory footprint
Version 3.1 Minor release -- 23 March, 2007_________________________________
- Fixed various glitches when running on Windows Vista,
- Fixed bug causing lock-up when an apostrophe is entered whilst editing in a split window in Management Studio,
- Now prefers exact matches for the current filter string by bringing them to the top of the candidate list,
- Keywords etc no longer auto-upper/lower-cased in comments and strings,
- Auto-closing character behaviour improved: insertion made less intrusive, auto-deletes when opening character is removed, can now overtype closing characters,
- Fixed case-sensitive owner/schema filtering bug,
- Empty object name no longer causes exception,
- Fixed exceptions when using "Run As..." to run Query Analyzer and/or Management Studio
- Fixed inappropriate connection attempts by SQL Prompt; fixes VPN related issues,
- A number of other small fixes and improvements to handle uncommon situations, e.g. attempting to connect to SQL Server 6.5.
Version 3.0 Major release -- January 22, 2007