Comments
Sort by recent activity
Thanks for the reply Victoria. Yes, tried looking within the adjacent dropdown but was not showing. Issue occurred again the following day and Repair worked from the uninstall. Next time issue occurs I will try following your suggestion. Thanks again. / comments
Thanks for the reply Victoria. Yes, tried looking within the adjacent dropdown but was not showing.Issue occurred again the following day and Repair worked from the uninstall.Next time issue occurs...
i've followed wave22 advice from other ticket and used Repair / comments
i've followed wave22 advice from other ticket and used Repair
Hi Jon, Thanks for your response and trying to replicate the issue. After it behaved like this and I was about to post on here I thought I had better update to the latest. So I installed what I was being prompted to update to when opening SSMS v18.12.1 and this has put me on Version 10.13.10.1356. Check for updates is saying "No updates available" [and not offering v10.13.11.1356] I then retested and had the same issue so I started this topic. Just testing again and I notice that on the normal search it will find one example at the top of the list but if i then look in the second item here it has no mention of the search term (As do any of the other listed items). Then when i switch to advanced search it seems to give up looking - if i change the term to just 'created' it finds stuff but as soon as i add the underscore it no longer returns relevant items. Repeated this sequence and this time the advanced search behaves like the normal and returns lots of items but only the first in the list contains the search term. [image] i think looking at the logs - they contain too much of our code for me to send whilst adhering to our company policies. If i'm able to blank out the items such as Received operation json: "SELECT\r\, would that still be useful to you? I will try installing the version you advised via your link thanks, James / comments
Hi Jon, Thanks for your response and trying to replicate the issue.After it behaved like this and I was about to post on here I thought I had better update to the latest. So I installed what I was ...
So can't find the most recent time you executed a proc to rescue a proc that someone else overwrote without trawling and collating the order ourselves. as Keith asks - what version do we need to rollback to to get less 'advanced' search for the moment please? / comments
So can't find the most recent time you executed a proc to rescue a proc that someone else overwrote without trawling and collating the order ourselves.as Keith asks - what version do we need to rol...
Victoria W said:
Hi @kalo Thank you for your patience while we worked on this issue.
The development team has now released a fix which you can download here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.0.31319.exe
thanks - noticed this but not had chance to update just yet - is there away of combining my old savedtabs.db prior to error to the new one i've had to maintain since? / comments
Victoria W said:
Hi @kaloThank you for your patience while we worked on this issue.
The development team has now released a fix which you can download here: https://download.red-gate.com/chec...
Hi Victoria W said:
Hi @kalo This is a known bug which we're working on but we have a workaround while we're waiting for the new release. Please can you close down SSMS, navigate to %localappdata%\Red Gate\SQL Prompt 10\ and delete the file "SqlHistory.db", before then relaunching SSMS (you won't lose your tab history in doing this), you should see this functionality restored. I'll let you know when the new version is available.
Hi - thanks for suggestion. However, I have followed these steps and Tab History is still not showing anything. I can see in the folder that a new SqlHistory.db file has appeared slightly smaller than before. Of course for a long time it's not been clear if the search in tab-history has actually fired - so i'm a bit blind to whether it is searching and taking a long time or not searching at all. I presume it's the latter because i'm giving it plenty of time before i give up. (Also once the tab-history is up you have to wait as it will close if you happen to click outside of it.) For the time being, i've cut my SavedTabs and SqlHistory to a folder on my machine elsewhere and then opened Tab History again. This works although i obvs haven't got immediate access to my history. So i can at least see what i ran from earlier today onwards. Once fix is released -hopefully i can revert to my bigger history / comments
Hi Victoria W said:
Hi @kalo This is a known bug which we're working on but we have a workaround while we're waiting for the new release. Please can you close down SSMS, navigate to %localapp...
rhodrie said:
Installed SQL History 10.13.0.31319 this morning - seems to solve the issues I've been having with SQL History. It also introduces SQL History as a tab within SSMS (the pop out window is still available by clicking the history icon in the bottom right of this tab.)
Thanks - was going to ask if anyone had validated this release. That's great if it's no longer just a pop-up that disappears when you accidentally click outside of it. Don't suppose anyone know it it is possible to merge a tab-history saved prior to rolling back version to the tab-history db maintained over last few weeks? / comments
rhodrie said:
Installed SQL History 10.13.0.31319 this morning - seems to solve the issues I've been having with SQL History. It also introduces SQL History as a tab within SSMS (the pop out...
klaursen said:
Same issue. I have my "SavedTabs.db" on OneDrive (referred from RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml). RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml has not been modified by the installation, and SavedTabs.db still has the same file size. So assuming that history is still in there. But nothing is shown in SSMS. Workarounds mentioned above do not work.
Hi - would you mind sharing you managed to do this [point to onedrive rather than local drive - just mapping]? I tried a while back and kept being thwarted - always worried if my laptop goes kaput i'm going to lose my precious history! / comments
klaursen said:
Same issue. I have my "SavedTabs.db" on OneDrive (referred from RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml). RedGate_SQLPrompt_CommonUI_Options_TabMagicOptions.xml ...
Kurt_M said:
Hi @kalo, @Averia @mattbenham Saloni @DangerDBA @brad_bruce_01 @jjnemmers Thank you for your patience on this issue, we now have a release which contains the latest SQL Compare engine and this should resolve the issue you was experiencing! Are you able to patch into v7.5.4 at your earliest convenience and confirm if this issue has been resolved. Download link available here: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe Patch note 7.5.4.16994 - February 28th, 2023
Improvements
VT-282 - Providing support for SSMS 2019 GA.
Updated SQL Compare Engine to 15.0.5.23167
Thank you - can confirm that has opened without error for me / comments
Kurt_M said:
Hi @kalo, @Averia @mattbenham Saloni @DangerDBA @brad_bruce_01 @jjnemmers Thank you for your patience on this issue, we now have a release which contains the latest SQL Compare e...
Kurt_M said:
Hi @kalo Apologies, but this issue is still being worked on. We don't have a release just yet. Once there is an update, I'll make sure to post on this thread letting everyone know.
Hi, is there any timeframe for an expected fix for this. At the moment i'm always having to bat away the prompt saying there's a new version for me to update to. Often come quite close to forgetting why it is that I have to keep saying remind me tomorrow. If this is a problem that's not affecting everyone is there something i can do my side to get my setup to work with the latest version? regards, James / comments
Kurt_M said:
Hi @kaloApologies, but this issue is still being worked on. We don't have a release just yet. Once there is an update, I'll make sure to post on this thread letting everyone know...