SQL Prompt 7

SQL Prompt 6.2 release notes

Version 6.2.0.366 - 20th January, 2014

Fixes

Version 6.2.0.361 - 14th January, 2014

Fixes

Version 6.2.0.241 - 18th December, 2013

Features

  • SQL Server Management Studio 2014 support
  • SQL Server 2014 CTP2 support
    SQL Prompt now connects to SQL Server 2014 and suggests new syntax.

    SQL Server 2014 CTP2 support is in beta, see the list of known issues.

  • Phrase completion
    SQL Prompt now completes entire SQL phrases, for example PRIMARY KEY instead of just the first keyword PRIMARY:

  • You can now insert suggestions by pressing the semicolon (;) key:
     
  • Tabs opened by SQL Prompt are no longer marked as unsaved
  • Options dialog box is now resizable
  • Improved formatting for MERGE statements

Known issues

  • Formatting for new syntax isn't supported 
  • Object definition box doesn't show memory optimized tables 
  • Refactoring features (eg Smart Rename) aren't supported for memory optimized tables

Fixes

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

SP-1320

New syntax extended events

SP-1511

Could certain keywords be combined in the suggestions list?

SP-2640

No suggestions for some DBCC statements

SP-2675

With SQL Prompt switched off a cache is still performed on connection to a database

SP-2735

Pairs of keywords should be inserted together

SP-2992

Intellisense stops after "BACKUP DATABASE AdventureWorks TO TAPE WITH "

SP-2993

Intellisense stops after "DBCC CHECKDB WITH"

SP-2994

Intellisense doesn't offer DROPCLEANBUFFERS after DBCC

SP-2996

Intellisense stops during parameters to ALTER INDEX

SP-2998

ROLLBACK isn't suggested after typing WITH

SP-3021

Qualify object names and table variables creates invalid sql

SP-3509

SET DEADLOCK_PRIORITY High keyword is missing

SP-3720

ALTER USER foo WITH LOGIN intellisense fail

SP-3837

Suggestions not working

SP-3853

Make SQL Prompt dialogs go away when the escape key pressed

SP-3975

Smart rename & identity column

SP-4017

Unsupported syntax: create server audit

SP-4187

Code completion following DBCC SQLPerf has wrong suggestions

SP-4411

No suggestions for Raiserror

SP-4414

SELECT COUNT(*) FROM snippet lacks trailing space

SP-4435

When enabling or disabling a trigger, SQL Prompt will include the schema name which causes the script to fail.

SP-4466

FREEPROCACHE keyword is not listed in the suggestions list after typing DBCC

SP-4467

CHECKPOINT keyword not included in the suggestions list

SP-4718

SQL Server 2012 feature MERGE give strange results for FormatSQL

SP-4916

Feature request for early support of SSMS 2014

SP-4956

SET DEADLOCK_PRIORITY should not prompt for COLLATE

SP-4957

SET DEADLOCK_PRIORITY should prompt for variables in the script

SP-4958

RAISERROR(...) WITH prompts for XMLNAMESPACES which is invalid

SP-4973

Tab history doesn't reconnect tabs in SSMS 2008

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

SP-3502

{SA} AccessViolationException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-3505

{SA} ArgumentException @ ObjectFactory.LoadTable(...)

SP-3551

{SA} ExternalException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-3693

{SA} InvalidCastException @ RenameLevel2Item.GetWizard(...)

SP-3722

{SA} InvalidOperationException @ VSEditorView.GetLocationForPosition(…)

SP-3734

{SA} ArgumentException @ SqlPromptEngine.HoverPrompt(…)

SP-3760

{SA} NullReferenceException @ SqlPromptEngine.HoverPrompt(…)

SP-3795

{SA} InvalidOperationException @ CandList`1/<Filter>d__6`1.MoveNext(…)

SP-3858

{SA} ArgumentException @ SnippetManager.SaveSnippet(…)

SP-3880

{SA} NullReferenceException @ CandidateBase.GetGrammar(…)

SP-3906

{SA} AccessViolationException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-3917

{SA} ArgumentException @ ImageToRtfConvertor.ConvertToMetaFile(...)

SP-3919

{SA} ExternalException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-3965

{SA} ObjectDisposedException @ TooltipForm.HideTooltip(…)

SP-3978

{SA} FileNotFoundException @ TableCandidate/<>c__DisplayClass1.<GetCompletionFragment>b__0(…)

SP-3999

{SA} [unknown type from RedGate.SQLCompare.ASTParser] @ Utils.GetAst(…)

SP-4003

{SA} ApplicationException @ PopupController.ResetPopupTimer(…)

SP-4070

{SA} ArgumentOutOfRangeException @ TBVAliasCandidate.<get_AliasColumns>b__0(...)

SP-4159

{SA} AccessViolationException @ VSEditorWindow.InternalGetCaretPosition(…)

SP-4163

{SA} InvalidOperationException @ ColoringMachine.UpdateTabColors(…)

SP-4197

{SA} InvalidProgramException @ VSEditorWindow.set_CaretPosition(…)

SP-4276

{SA} OutOfMemoryException @ ImageToRtfConvertor.ConvertToHexString(…)

SP-4399

{SA} Exception @ ObjectFactory.GetServerType(…)

SP-4410

{SA} InvalidOperationException @ VSEditorWindow.InternalGetCaretPosition(…)

SP-4515

{SA} FileNotFoundException @ .()(…)

SP-4560

{SA} AccessViolationException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-4563

{SA} ExternalException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-4567

{SA} FileNotFoundException @ IpnUtils.IpnUtils(…)

SP-4572

{SA} InvalidOperationException @ VSEditorView.GetLocationForPosition(…)

SP-4582

{SA} ArgumentException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-4619

{SA} NullReferenceException @ VSEditorWindow.InternalGetCaretPosition(…)

SP-4633

{SA} InvalidOperationException @ VS2010EditorView.ClientPointToScreenPoint(…)

SP-4646

{SA} OutOfMemoryException @ ImageToRtfConvertor.ConvertToMetaFile(…)

SP-4716

{SA} InvalidOperationException @ ScriptPanel.HandleScript(…)

SP-4761

{SA} ArgumentNullException @ JoinSuggestionPlaceholderCandidate.JoinSuggestionPlaceholderCandidate(…)

SP-4766

{SA} InvalidCastException @ ObjectFactory.LoadIndexes(…)

SP-4777

{SA} AccessViolationException @ VSEditorWindow.MoveCaret(…)

SP-4787

{SA} Exception @ TabWatcher.AfterOpenDocument(…)

SP-4788

{SA} ArgumentNullException @ TabCreator.ThrowOnFailure(…)

SP-4791

{SA} ObjectDisposedException @ TabCreator.ThrowOnFailure(…)

SP-4801

{SA} Exception @ MutexWrapper/MutexHandle.MutexHandle(…)

SP-4820

{SA} ArgumentException @ TabWatcher.BeforeOpenDocument(…)

SP-4836

{SA} NullReferenceException @ TabCreator.OpenDocument(…)

SP-4837

{SA} COMException @ TabCreator.ThrowOnFailure(…)

SP-4846

{SA} InvalidOperationException @ VSEditorWindowBase.InternalGetCaretPosition(…)

SP-4850

{SA} AccessViolationException @ TabCreator.OpenDocument(…)

SP-4854

{SA} FileNotFoundException @ TabCreator.ThrowOnFailure(…)

SP-4858

{SA} Exception @ TabWatcher.AfterOpenDocument(…)

SP-4866

{SA} NullReferenceException @ TabCreator.OpenDocumentDisconnected(…)

SP-4869

{SA} COMException @ TabCreator.ThrowOnFailure(…)

SP-4873

{SA} UnauthorizedAccessException @ TabCreator.ThrowOnFailure(…)

SP-4898

{SA} DirectoryNotFoundException @ TabCreator.ThrowOnFailure(…)

SP-4901

{SA} NotSupportedException @ ServerCandidate.LoadServerCapabilities(…)

SP-4919

{SA} ImportCardinalityMismatchException @ TabCreator.ThrowOnFailure(…)

SP-4925

{SA} NullReferenceException @ TabCreator.ThrowOnFailure(…)

SP-4927

{SA} TargetInvocationException @ TabCreator.ThrowOnFailure(…)

SP-4944

{SA} ArgumentException @ DataCompressionHelper.GetDataCompressionSQL(…)

SP-4955

{SA} AccessViolationException @ TabCreator.OpenDocumentDisconnected(…)

SP-4966

{SA} IOException @ TabCreator.ThrowOnFailure(…)

SP-4971

{SA} InvalidCastException @ CandidateListBox.DrawSynonym(…)


Didn't find what you were looking for?