SQL Prompt 6

SQL Prompt 6.0 release notes

September 4th, 2013

SQL Prompt Standard edition has been retired with the release of SQL Prompt 6.0. All SQL Prompt features are now available in a single edition.

If you are using SQL Prompt Standard, please email sqldev.info@red-gate.com to discuss your upgrade options.

SQL Prompt 6.0 includes the following:

Tab history

SQL Prompt now keeps a history of query tabs you open in SQL Server Management Studio:

For more information, see Tab history.

Synonym support

Synonyms (including columns from a synonym’s base object) are now suggested.

CLR support

CLR functions and CLR stored procedures are now suggested.

XML functions support

XML functions are now suggested.

SQL Azure support

SQL Azure databases are now supported.

Custom snippets folder

You can now share snippets with other SQL Prompt users by using a shared snippets folder:

For more information, see Sharing snippets.

More snippet placeholders

You can now use $PASTE$, $DBNAME$ and $SERVER$ in SQL Prompt snippets. You can also specify a custom $DATE$ and $TIME$ format, eg $TIME(HH:mm:ss)$.

For more information, see Using placeholders.

Indent using tab characters

You can now customize SQL Prompt formatting to indent text using tab characters:


JOIN clause improvements

 All relevant tables are now suggested in a join clause, and we’ve added an option to swap the order of columns in the clause:


Copy from object definition box

You can now press CTRL + C to copy the contents of the object definition box.

Bug fixes

We've fixed the following bugs that were reported by users:

SP-1057 Select from table WH does not suggest WHERE 
SP-1170 XML value predicate doesn't work
SP-1329, SP-1871, SP-3060, SP-3090, SP-3612 Use tabs instead of spaces while laying out
SP-2129 Ctrl + C does not copy in hover prompt expanded schema panel
SP-2381 SM#78 FOR XML statement squigglied
SP-2571, SP-2731 Ctrl + A doesn't work in the snippet editor
SP-2804 Once trial has expired, it says you still have an 'unlicensed trial'
SP-2914 (XML) value statement is autom. converted to uppercase
SP-2947 Code of a procedure is shown twice when using the copy code for a stored procedure
SP-3136 SET @xml_variable.modify(...) is not recognized
SP-3928 No candidates in the list for FETCH NEXT ... INTO
SP-4236 Middle-click closes the in focus tab, not the tab that the mouse cursor is over
SP-4454 Find invalid objects fails with an incorrect error on this attached DB
SP-4495 SQL Prompt doesn't install into Visual Studio when SSMS is also installed
SP-4546 Native intellisense is not suppressed in SSMS 2012
SP-4547 {SA} TypeLoadException @ UnusedVariableMarker.FromAnalysisResult(…)
SP-4576 Suggestions stop in query window after XML query
SP-4577 Attempting to format a query with a question mark hangs SSMS
SP-4628 Prompting and tooltips offset when using a non standard dpi (Medium or High settings) in SSMS 2012 (F0069016) 
SP-4711 Support try_cast 2012 function in format SQL
SP-4745

Support continuous connection to server in VS 2012

We've also fixed the following bugs that were send to us as error reports from SQL Prompt:

SP-3412

{SA} NullReferenceException @ PromptEngineEmulator.ApplyCompletionFor(...)

SP-3912

{SA} InvalidOperationException @ DatabaseCandidateBase.GetConnectionSource(…)

SP-4001

{SA} NullReferenceException @ UpdateUtils.StartupUpdate(…)

SP-4124

{SA} InvalidProgramException @ EditorWindowBase.OnSqlPromptEnabledChanged(…)

SP-4127

{SA} InvalidProgramException @ VSScriptProvider.NotifyScriptChange(…)

SP-4257

{SA} FileNotFoundException @ ColumnDependenciesCalculator.RegisterDabase(…)

SP-4267

{SA} NullReferenceException @ ObjectExplorer.UnHookEvents(…)

SP-4269

{SA} ArgumentOutOfRangeException @ PrefixRadixTreeDictionary`1/TrieNode/<FindPartial>d__2e.MoveNext(…) - Calculating suggestions during database load

SP-4293

{SA} ArgumentNullException @ ServerTools.GetServerName(…)

SP-4346

{SA} NullReferenceException @ ServerTools.CreateTabNameToServerNameDictionary(…)

SP-4359

{SA} ArgumentNullException @ AddinServices.GetServiceForSite(…)

SP-4413

{SA} NullReferenceException @ PromptEngineEmulator.get_FilterStartIndex(…)

SP-4547

{SA} TypeLoadException @ UnusedVariableMarker.FromAnalysisResult(…)

SP-4561

{SA} NullReferenceException @ DatabaseCandidateBase.GetAllColumns(…)

SP-4568

{SA} NullReferenceException @ PromptEngineEmulator.get_FilterStartIndex(…)

SP-4703

Exception occurs when using middle click on the mouse to close a tab that was not active when Coloured Tabs active

SP-4704

{SA} NullReferenceException @ Connect2010.Dispose(…)

SP-4706

{SA} NullReferenceException @ UnhandledExceptionHandler.UnhandledExceptionHandler(…)

SP-4735

{SA} ArgumentOutOfRangeException @ StrongName.StrongName(…)

SP-4779

{SA} InvalidProgramException @ Options.ToString(…)

SP-4785

{SA} InvalidProgramException @ StandardEditionCommonControl.set_Label(…)

SP-4792

{SA} SqlException @ SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)(…)

SP-4802

{SA} FileNotFoundException @ TableSplitWizard.BWRegisterDabase(…)

We’ve also fixed some stability issues on Windows 8 and 8.1.


Didn't find what you were looking for?