How can we help you today? How can we help you today?

SQL Prompt v4 Beta is out!

Hello all,

The beta version of SQL Prompt 4 can now be downloaded from:
http://downloads.red-gate.com/beta/SQLP ... .0.1.2.exe

Installation:

Note that SQL Prompt v4 does not work in parallel with v3, so installing SQL Prompt v4 will disable v3.

To re-enable v3, uninstall v4.

For users who have installed SQL Prompt v4 early access program, beta installation will work as an upgrade.

What has changed from Early Access release?

We’ve added support for:
• Temporary tables
• Capitalisation of text as you type
• Automatic insertion of closing characters

We’ve fixed some bugs, including:
• Drop database connections
• No more red underlines
• SQL Prompt affecting keystroke behaviour in SQL editors
• Columns are now listed after the WHERE clause in a DELETE statement
• Exception caused by using CREATE Statistics statement
• No more annoying error dialogs when user does not have permission to decrypt objects
• Selecting columns from column picker inserts a space when aliases are present
• Out of Memory exception reported by some evaluators
• Issues with ambiguous columns

What’s not yet in the beta:
• Linked server support
• CTE support
• Detailed script view of objects in the object definition panel

These features will be in the final release, which we’re aiming to have ready by the end of July.

I hope you all enjoy using the new v4 beta build.

Please submit any feedback, bug reports, or other suggestions you have in this forum.

Thanks,
Tanya
Project Manager
Red Gate Software Ltd
tanya
0

Comments

5 comments

Sort by
  • sam88jeep
    An installation of SQL Prompt affects the double-click behavior in SSMS. Would really like the behavior to be unaffected since I copy/paste more than I type it seems.

    Thanks!
    sam88jeep
    0
  • George Palacean
    Are table variables going to be supported in the final version ? (currently I see that they aren't)
    George Palacean
    0
  • deman2k
    Hi,

    Whenever I uninstall SQLPrompt 4, it's not cleanly uninstall.
    I can still see SQL Prompt menu in my SSMS.

    I'm using SQL Server 2005.

    Update: I found this at http://www.red-gate.com/supportcenter/C ... TA/toc.htm
    Uninstalling SQL Prompt

    To uninstall SQL Prompt:

    1. Use the Windows® Add or Remove Programs tool to remove SQL Prompt 4.
    2. In SQL Server Management Studio, to remove the SQL Prompt 4 menu from the toolbar, do the following:
    * On the Tools menu, click Customize.
    * Drag the SQL Prompt menu from the menu bar, or right-click the SQL Prompt 4 menu and click Delete.
    3. Close the Customize dialog box.

    So it's not an issue with SQL Prompt uninstallation per se. However, can't this steps taken care automatically by during uninstallation?
    deman2k
    0
  • paschott
    I had the same problem with the uninstall. Had to customize my menus to get SQL Prompt 3.9 back. Glad that it worked, but the sudden expiration of the earlier 4.0 beta surprised me and it hurt not having an upgrade when it did expire.

    Looking forward to trying out the new version to see what happens. From everything I can tell so far, SQL Prompt 4 seems to be better about temporary files and seems to be quite a bit faster. The new changes/features announced should improve my coding experience.
    paschott
    0
  • deman2k
    Is there anyway I can speed-up the column selection. Currently I need to complete the SQL statement, for example, select * from tablename, then jump back to * and invoke the intellisense for column picker. Currently I found that so many steps needed to complete statement until I got the columns that I want (hint: refer how SQL Assistant manage to reduce the steps)

    Is there anyway I can choose the column while selecting the table?

    Second, is there any way I can jump back to * quickly after selecting the table? For example, key that can be used to navigate quickly to any token in the statement?

    Thank you.
    deman2k
    0

Add comment

Please sign in to leave a comment.