BUG: SQL Search not working after SSMS 18.5 upgrade and after that SQL Prompt update
MichelD
Posts: 8 Bronze 1
in SQL Prompt
Pressing SQL Search in Red Gate Toolbar doesn't show SQL Search, SQL Prompt and Tab History does work.
Tried manual update of SQL Search, but that gives message 'a newer version is installed'
Using
And SQL Prompt 10.1.4.14671
Below the Log:
16 Apr 2020 10:27:31,560 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
Tried manual update of SQL Search, but that gives message 'a newer version is installed'
Using
| SQL Server Management Studio | 15.0.18330.0 | |
Below the Log:
16 Apr 2020 10:27:31,560 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Apr 2020 10:27:31,566 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Apr 2020 10:27:31,568 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Apr 2020 10:27:31,568 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnSetFocus IVsTextView: 1008758412
16 Apr 2020 10:27:31,570 [1] INFO RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [25364199] Started task 'Code analysis task <SQLQuery17.sql - X.X(.\Micheld (197))*>'.
16 Apr 2020 10:27:31,843 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Apr 2020 10:27:31,911 [12] INFO RedGate.SqlPrompt.Engine.AsyncExecution.AsyncWork`2[[RedGate.SqlPrompt.Engine.AsyncExecution.AlwaysSkipWorkInput, RedGate.SqlPrompt.Engine, Version=10.1.4.14671, Culture=neutral, PublicKeyToken=7f465a1c156d4d57],[System.Collections.Generic.IList`1[[RedGate.SqlPrompt.Analysis.Engine.Issues.AnalysisIssue, RedGate.SQLPrompt.Analysis.Engine, Version=10.1.4.14671, Culture=neutral, PublicKeyToken=7f465a1c156d4d57]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [25364199] Run 'Code analysis task <SQLQuery17.sql - sql04. .\Micheld (197))*>' completion handler!
16 Apr 2020 10:27:31,912 [12] INFO RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [25364199] Successfully finishing current task 'Code analysis task <SQLQuery17.sql - X.X .\Micheld (197))*>'.
16 Apr 2020 10:27:32,325 [15] DEBUG RedGate.SQLPrompt.CommonVS.Plugins.AutoRefreshPlugin.AutoRefresh - AutoRefreshing database X
16 Apr 2020 10:27:35,100 [1] DEBUG RedGate.SqlPrompt.Platform.Client.SharedFormattingStyles.ISharedFormattingStylesClient - Redgate platform not available: [formatting styles] GetSharedFormattingStyles called => no results
16 Apr 2020 10:27:38,099 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
16 Apr 2020 10:27:38,100 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 1008758412
Best Answer
-
MichelD
Posts: 8 Bronze 1
SQL Prompt 10.1.5 doesn't have release notes (yet), but doesn't fix it.
Bu i found a fix in : https://forum.red-gate.com/discussion/86773/sql-search-does-not-start-in-ssms-18-5
