SQL Prompt 6.4 beta (Now closed)

Provides intelligent code completion for SQL Server editors.

SQL Prompt 6.4 beta (Now closed)

Postby Aaron Law » Wed Jun 04, 2014 9:42 am

The stable release announcement can be found here.

Beta closed - thanks to everyone who took part!

The SQL Prompt beta includes:
  • Insert semicolons (UserVoice)
  • Execute current statement (UserVoice)
  • BEGIN...END block highlighting (UserVoice)
  • Rename variables (UserVoice) and aliases (UserVoice)
  • Improved support for aliases in UPDATE (UserVoice)
  • Improved loading dialog box
  • Startup performance improvement
  • Single suggestion pop-up improvement
  • Qualify object names improvements
  • Suggestions for additional object types
  • Format SQL now matches object case (UserVoice)

Version history - 12th September
  • Fix for quotes being stripped after a format SQL (Forum post)
  • Fix for incorrect INSERT column highlighting with subqueries in values list - 10th September
  • More improvements to expand wildcards indentation
  • Support for connecting to Azure restricted accounts
  • The error dialog is suppressed for when login fails due to username/password
  • Fix for SP-4277 (\"textViewMonitor already attached to a TextLinesMonitor\")
  • A message box is now displayed if the user doesn't have permission to re-use the password from the query's connection in Prompt - 8th September
  • Improved handling of dot completion key with suggestions containing dots (Uservoice)
  • Improved indentation when expanding wildcards
  • Fix for qualify object names with semi-ambiguous columns (Forum post) - 8th September
  • Fix for connection details not being auto-populated in VS2010 (Forum post)
  • Fix for semicolon being inserted in the wrong position (Forum post)
  • Fix for temp table columns not being suggested (Forum post)
  • More object types are now suggested from create statements in script - 3rd September
  • Limit added for maximum script size that Prompt will cache suggestions for (the default is 5MB)
  • Datatypes are suggested if running in a disconnected query
  • Fix for suggestions box sometimes displaying a red X - 2nd September
  • Suggestions improved for longer scripts (UserVoice, UserVoice and UserVoice)
  • Nullability of columns now shown in tooltips, suggestions and object definition box (UserVoice and UserVoice)
  • Improved support for table-valued variables and parameters (UserVoice)
  • Now suggests stored procedures from script before they've been created in the database (UserVoice)
  • Fix for occasional wrong qualification if two tables in different schemas share the same name and column names
  • Fix for missing suggestions in CTE if an alias name clashes with CTE name - 26th August
  • Highlighting columns and data in INSERT statements (UserVoice)
  • Improvements to snippet suggestions after aliases (UserVoice)
  • Partial matching enabled for snippets (UserVoice)
  • Added Remove Square Brackets feature to remove unnecessary square brackets from a script
  • Fix for find invalid objects with table valued function (Forum post)
  • Fix for expanding wildcards with inserted/deleted tables in OUTPUT statement (Forum post)
  • Fix for tab not always expanding wildcards (Forum post)
  • Fix for object tooltips on hover not displaying in Visual Studio - 18th August
  • Added option for \"Indent BEGIN...END blocks\" (Forum post and UserVoice)
  • Grouped similar commands together in SQL Prompt menu
  • Both keywords are now highlighted for BEGIN TRY...END TRY matching
  • Query hint option IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX is now suggested - 15th August
  • Fix for snippet being expanded with tab while suggestions list is displayed (Forum post)
  • Fix for qualify object names with table valued variables (Forum post)
  • Suggestions added for FEDERATION related keywords on Azure
  • Synonym population won't request base types unless \"Load referenced databases\" is on (which could have been causing slow loading or timeouts) - 13th August
  • Tweaked the text highlighting for modified text - 13th August
  • Identifiers will now be recased to match the case used in the database with Apply Casing Options and Format SQL (UserVoice)
  • Text modified due to casing options is now highlighted
  • Added option to limit number of tabs that will be reopened on startup (the default is 20) (UserVoice)
  • No longer try to avoid alias name clashes with stored procedure names (UserVoice)
  • Fix for Insert Semicolons causing a duplicate semicolon in DECLARE CURSOR and SET CURSOR statements
  • Fix for occasional duplicate columns in wildcard expansion - 8th August
  • Fix for duplicate columns sometimes being suggested
  • Fix for selection changing after a format SQL - 7th August
  • Methods now suggested for geometry and geography clr types (UserVoice)
  • Native intellisense is now re-enabled when Prompt suggestions are disabled (UserVoice)
  • Tables and views suggested if CREATE statement in script
  • ON <owner_name> now auto completed for DISABLE/ENABLE TRIGGER and ALTER/DROP INDEX
  • Removed invalid keyword suggestions after a WAITFOR
  • Faster SSMS command initialization during startup
  • Fix for parameter suggestions missing after an EXEC statement (Forum post) - 1st August
  • Fix for bug introduced in's installer where Prompt might not install correctly to SSMS or Visual Studio.
    If you're missing Prompt from the previous build then installing the latest build should bring it back. Sorry for the inconvenience! - 1st August
  • Installer options to install to SSMS and/or Visual Studio (UserVoice)
  • Fix for Qualify Object Names adding in an alias qualification to an UPDATE statement incorrectly
  • Static method suggestions added to hierarchyid - 31st July
  • Triggers in ALTER TABLE suggestions are now filtered by the table (UserVoice)
  • Columns in CREATE TABLE statement are suggested for PRIMARY and FOREIGN keys
  • CLR methods suggested for hierarchyid
  • Fix for contained database users with windows authentication
  • Fix for formatting error with \"GO 10\"
  • Potential fix for double dot syntax (Forum post)
  • Minor performance (~20%) and memory (~10%) improvements for database suggestions
  • Suggestions for additional object types
    • Sequences (UserVoice)
    • Check constraints
    • Queues (Uservoice)
    • Services
    • Contracts
    • Message types
    • Routes
    • Xml schema collections - 18th July
  • Comments are now preserved when completing ALTERs (UserVoice and Forum post)
  • Support for connecting as a user on contained database (Used to display \"Login failed for user...\")
  • Execute to cursor added as Ctrl+Shift+F5 (Forum post) - 17th July
  • Fix for execute current statement not selecting the correct text (Forum post)
  • Execute current statement now works when connected to an Azure server
  • $USER$ snippet placeholder will now resolve to the connected user rather than the windows user
  • Caret stays in the same location after a Format SQL if positioned at start of line (Forum post) - 16th July
  • Scroll position is now maintained after applying Format SQL (Forum post)
  • Fix for ON being misaligned if table hints are used in a join clause (UserVoice) - 16th July
  • No longer freezes when disabling/enabling suggestions during a database load - 15th July
  • Generated aliases are now enclosed in square brackets if option set (UserVoice)
  • If enclose square brackets is off Prompt will avoid generating aliases that match keywords
  • Qualify object names and apply casing options are now only applied to the selected text (rather than entire line) - 14th July
  • Added an option to limit the maximum script size that tab history will save (defaults to 1MB)
  • Fixes for qualify object names with columns (Forum post) - 10th July
  • Added Alt+Shift+F5 to execute current batch (this is in addition to Shift+F5 to execute current statement)
  • Columns and datatypes in object definition box are now sortable (Forum post)
  • Fix for too many suggestions (Forum post) - 7th July
  • Snippet manager now keeps edited and created snippets in view after refreshing list
  • Database loading dialog now has a tooltip on hover to show database names when multiple databases are loading - 3rd July
  • Reduced locking on UI thread during database loading (hopefully fixing the forum post below) - 3rd July
  • Generated comments are placed on the same line as data in INSERT statements if \"Place commas at start\" has been set (UserVoice and UserVoice) - 2nd July
  • Minor fix for default schema syntax on system databases having too many suggestions
  • Character limit removed from create snippet text box
  • Qualify object names improvements:
    • New option for qualifying with aliases (UserVoice)
    • Changes are now highlighted
    • No longer displays errors if temporary tables are created in the script
    • Now uses the existing suggestion cache rather than recaching some objects
    • Will replace table qualification with its alias if table has been aliased - 23rd June
  • INSERT and SELECT formatting tweak is now optional (Forum post)
  • Column suggestions are now displayed for a table alias rather than a table of the same name (Forum post) - 20th June
  • Parameter info tooltip is now only displayed after typing (or with the shortcut ctrl+shift+space) and can be hidden with escape
  • Fix for columns suggestions not filtered by alias (Forum post)
  • Table keyword now cased as a datatype in declare statements and table valued functions (Forum post) - 9th June
  • Fix for some assemblies not being digitally signed correctly (causing false positives with anti-virus software) - 9th June
  • Rename alias improvements
  • Now hides green highlights after inserting semicolons if suggestions are disabled
  • Support for suggestions using default schema syntax (eg \"master..sp_help\")
  • System objects shown if fully qualified to system database
  • SSMS built in intellisense disabled on startup if prompt is enabled (Forum post)
  • INSERT and SELECT formatting tweak (Forum post) - 4th June
  • No longer throws exception with connection coloring in certain circumstances - 4th June
  • Initial release

If you have any problems with this release, please post them on this forum.

If you have any suggestions for improvements, please post them on our suggestions forum so other users can vote for them.
Last edited by Aaron Law on Tue Sep 16, 2014 3:07 pm, edited 75 times in total.
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby Aaron Law » Wed Jun 04, 2014 10:12 am

For users of the connection coloring feature: it's now possible to tweak the colors or add new categories by changing
Code: Select all
%localappdata%/Red Gate/SQL Prompt 6/ConnectionColoringCategories.xml

Editing xml files obviously isn't ideal and we are hoping to have a UI to edit these but the first step towards that is getting them loaded from a file which is in this build.
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby KevinGreiner » Thu Jun 19, 2014 6:41 pm

In this release, SQL Prompt doesn't scroll the suggestion popup list based on the table alias.

Given the following code, what would you expect the suggestion popup to contain?

select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID

I would expect the suggestion list to contain only b.* columns. But it doesn't. Instead, I am shown both a.* and b.* columns. At a minimum, the suggestion list should be scrolled to the first b.* column.

When working with SQL that contains many joins and table alias, this bug means that I need to lift my hands off the keyboard and scroll the list with the mouse. It's not very efficient.

Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby David Priddle » Fri Jun 20, 2014 12:07 pm

Hi Kevin,

Thanks for finding this for us!

We've fixed this in the latest beta build ( You can either download it from the download link in this post, or through Check for Updates.

Please let us know if this works for you, and if you find any more problems.

Best regards,

David Priddle
Posts: 216
Joined: Tue Jan 28, 2014 9:22 am
Location: Red Gate Software, Cambridge

Postby KevinGreiner » Fri Jun 20, 2014 12:28 pm

Thanks, David. The suggestion list is populated as expected with the 204 beta.
Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby KevinGreiner » Fri Jun 20, 2014 12:58 pm

OK, I found another problem. Using the same example,

select b.<cursor> from APP.TableA a join APP.TableB b on a.TableAID = b.TableAID

If a table named [b] exists in the current database, only the columns of that table will be suggested. The columns of the table alias "b" are not shown.
Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby Aaron Law » Fri Jun 20, 2014 1:43 pm

Hi Kevin,
I'm looking into recreating this now but I don’t think I'm seeing the same behaviour as you, in the example you've listed I get suggestions from TableB:


Can you think of anything else that might help us reproduce your issue here?

Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby KevinGreiner » Fri Jun 20, 2014 2:35 pm

Looks like the suggestions for the first field are fine. It's the second field that is wrong.

Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby Aaron Law » Fri Jun 20, 2014 2:42 pm

Thanks Kevin! I can recreate it fine here with the second field, I'll see what we can do about a fix for this.
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby Aaron Law » Mon Jun 23, 2014 2:09 pm

Hi Kevin,

This should be fixed in the latest beta build ( - thank you for the awesome repro steps!
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby KevinGreiner » Wed Jul 02, 2014 5:18 pm

I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.

I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for 2-3 seconds. This is a development db with several devs making changes.

Here are the counts of objects in the current database.

74 CHECK constraints
2405 Default or DEFAULT constraints
432 FOREIGN KEY constraints
3 Inlined table-functions
1925 PRIMARY KEY or UNIQUE constraints
69 Scalar functions
1399 Stored procedures
67 System tables
12 Table functions
17 Triggers
2124 User tables
Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby Aaron Law » Thu Jul 03, 2014 8:09 am

Hi Kevin,

I'm having difficulty recreating this here. Prompt should start up a thread for refreshing suggestions to avoid locking the UI, but it sounds like it's going wrong somewhere for you.
I'm think it's not solely related to database size since I've given it a go on one of our giant test databases (~180,000 procs and ~20,000 tables)
To help narrow it down:
1. Is this issue new in 6.4 (I'm wondering if it's related to the loading dialog changes we've made) or does it lock up in 6.3 too?
2. Is it only on that database/server or does it lock up even if connecting to a local instance?

Thank you!
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby KevinGreiner » Thu Jul 03, 2014 1:36 pm

I'm fairly certain this issue is new. I love the new loading dialog and that it's placed at a consistent place on the screen.

The UI freeze is before the dialog is shown. As soon as the small window appears, the UI is responsive again.

I'm unable to reproduce locally even with a large number of objects. Typically, I work remotely, using db servers remotely via VPN connections.
Posts: 36
Joined: Mon Mar 05, 2012 8:38 pm
Location: United States

Postby Aaron Law » Thu Jul 03, 2014 2:50 pm

It does sound like it's related to a slow connection, although I'm still struggling to recreate it here even over a slower connection.

I've had an attempt at reducing the amount of work we do on the UI thread with the progress dialog which might reduce the UI lock up - could you see if helps?
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Postby jmeyer » Fri Jul 11, 2014 2:17 pm

Control-B, Control-Q does not work if I try to format an INSERT INTO table() SELECT columns FROM table1 WHERE condition statement.
I'm also having problems qualifying object names when there are linked server in the query. This one predates SQL Prompt 6.4 beta.
Posts: 67
Joined: Fri Jun 05, 2009 2:07 pm


Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 0 guests