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

Known issues

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(…)