Activity overview
Latest activity by alphonseg
Thanks. That worked, although I don't understand why since the content of both files look identical. / comments
Thanks. That worked, although I don't understand why since the content of both files look identical.
Copy SQL History to New Machine
Using SQL Prompt 10.14.0.4046
I've copied C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 10\SqlHistory.db to a new machine.When I open SQL History, The 'Recent Queries' pane lists everything exp...
Just installed the newest version. Initially, SQL History loads, but on entering any search term, it returned zero results. Closed and re-opened SSMS and it worked. According to the release notes, the only change regarding SQL History, is the addition of sorting option under Advanced search. This is a big help. It would be better if the default sort was by newest first, and there are still other significant annoyances, but I guess that is best discussed in a new thread. / comments
Just installed the newest version. Initially, SQL History loads, but on entering any search term, it returned zero results. Closed and re-opened SSMS and it worked. According to the release notes, ...
Where is the support we are paying for? These issues are costing me time by a utility that is supposed to save me time. / comments
Where is the support we are paying for? These issues are costing me time by a utility that is supposed to save me time.
This really needs to be fixed. SQL History is unreliable. I'm searching for terms that I know I ran last week (I have the Excel output to prove it) and it comes up with thing from 4 years ago, but not last week. The old history was clunky, but it at least worked. Is there any way to activate it? / comments
This really needs to be fixed. SQL History is unreliable. I'm searching for terms that I know I ran last week (I have the Excel output to prove it) and it comes up with thing from 4 years ago, but ...
I'm using SSMS 17.9.1. Yes, the search bar is correct. Doesn't matter if advanced is displayed or not. The search animation does display, then the 'no items to display' is shown.
Yes, if the search is empty, history is displayed.
It seems to be intermittent. The last couple of days it was working. Today, it initially did not. I emptied the search box clicked on a displayed query, then entered a search term and it worked. Closed and reopened SSMS and it worked. Rebooted, and it worked. Very strange. There is one consistent issues though, when results are returned. They are NOT sorted by date. Seems to be random. This really needs to be fixed. I search for a simple term and get 1000 results.
/ comments
I'm using SSMS 17.9.1.Yes, the search bar is correct. Doesn't matter if advanced is displayed or not.The search animation does display, then the 'no items to display' is shown.
Yes, if the search i...
SQL History Search no longer works
I just updated to v 10.13.4.32349. SQL Search opens noticeably quicker, however it no longer works. No matter what I type (even simple words like 'select', 'from') in the search box, there are no r...
I just installed 10.13.4. That solved it, thanks. / comments
I just installed 10.13.4. That solved it, thanks.
I'm still using 10.13.31952 and won't update until I hear that the problem is fixed. Is there a newer version than 10.13.3.32087? / comments
I'm still using 10.13.31952 and won't update until I hear that the problem is fixed. Is there a newer version than 10.13.3.32087?
I had upgraded from 10.13.31952. I uninstalled the new version and re-installed 10.13.31952 and it is working as previous - needs work, but at least functions. Yes, I have submitted suggestions, but, of course, never hear anything back.
/ comments
I had upgraded from 10.13.31952.I uninstalled the new version and re-installed 10.13.31952 and it is working as previous - needs work, but at least functions. Yes, I have submitted suggestions, but...