SQL Prompt 6.2 release notes
Published 17 December 2013
Version 6.2.0.366 - 20th January, 2014
Fixes
- SQL Prompt now uninstalls cleanly from SSMS 2012 (http://www.red-gate.com/messageboard/viewtopic.php?t=19605)
Version 6.2.0.361 - 14th January, 2014
Fixes
- Trial expiry dialog now only shows once (http://www.red-gate.com/messageboard/viewtopic.php?t=19484)
- Ctrl+Enter no longer jumbles keywords (http://www.red-gate.com/messageboard/viewtopic.php?t=19421)
- Snippets starting with z are now suggested (http://www.red-gate.com/messageboard/viewtopic.php?t=19518)
- Fixed bug where view suggestions are missing (http://www.red-gate.com/MessageBoard/viewtopic.php?t=19514)
- Ctrl+Left and Ctrl+Right aren't swallowed if the column picker tab is disabled
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(…) |