How to stop SQL Search auto-searching
kalo
Posts: 84 Bronze 5
in SQL Search
Is this a setting or somesuch that i am totally overlooking but does SQL Search have to start searching as soon as it opens.
At times it decides to look across all databases for a blank string even though i've not had chance to tell it what i want to find.
If you put a word in it goes off and brings back results for something it had already decided to look at so you have to click a few times to provoke it into doing the intended search.
Great that it comes back with the correct results eventually but why is that i have to cajole it into doing it , why can't it have a GO button that just searches when you are ready for it start looking?
At times it decides to look across all databases for a blank string even though i've not had chance to tell it what i want to find.
If you put a word in it goes off and brings back results for something it had already decided to look at so you have to click a few times to provoke it into doing the intended search.
Great that it comes back with the correct results eventually but why is that i have to cajole it into doing it , why can't it have a GO button that just searches when you are ready for it start looking?
Tagged:
Best Answer
-
RichardL
Posts: 417 Gold 4
Hi @kalo
Thanks for your post.
Are you running the latest version? You'll need to be on V3.1.3 or later. New in V3.1.3, SQL Search does not index databases automatically on start-up. In V3.1.6 released on 22nd May we made improvements to initial indexing performance. Further information is below.
https://documentation.red-gate.com/ss3/release-notes-and-other-versions/sql-search-3-1-release-notes
The link for the download is below.
ftp://support.red-gate.com/patches/SQLSearch/23May2018/SQLSearch.exe
I hope this helps.
Richard.Customer Support
Redgate Software
Answers
Thanks for your prompt reply
I'm on V3.1.5 so i will look to update over the weekend and get the benefit of this change.