Getting false results in 3.0.x

• 

  Rob C wrote: »

  We're currently looking into this problem but in the mean time, I'd suggest rolling back to version 3.0.4 if you're affected. You can download it here.

  
  I'm not able to reach that file (3.0.4). Not sure if it's my company's firewall.
  "This site can’t be reached"

  gflores February 05, 2018 17:58

  - 0 +
• 
  Hi,
  
  Please find here an alternative download location for SQL Search 3.0.4, this is an https link so hopefully you will not have the same issues as before. This is a temporary link that will expire in a few days:
  
  https://files.red-gate.com/link/Toash4XL6qVLkCBexiBOeQ
  
  Thank you,

  Sergio R February 06, 2018 16:52

  - 0 +
• 
  When I downloaded SQL Search 3.0.4 I received the error message, " The Add-in supporting this command could not be loaded." At that point SQL Search was inoperable and I had uninstall it and re-install everything from the bundle.

  Ks3 February 07, 2018 13:01

  - 0 +
• 
  Hi @Ks3
  
  Thanks for your post.
  
  Just to let you know that the team are currently working on SQL Search replacing the index components which will be available in a later version, possibly V3.0.8 or the release after this.
  
  Kind regards

  RichardL February 09, 2018 13:58

  - 0 +
• 
  I am also having this same issue. When will it be fixed?

  mdullni1 February 16, 2018 16:58

  - 0 +
• 
  Hi @mdullni1
  
  
  NOTE: updated version released since this post. Check further down the page. 
  
  
  Thanks for your post.
  
  We do not have a fixed time for resolution on this yet but the development team are working on it.
  For now we recommend reverting to SQL Search version 3.04
  You can get it from my link below.
  
  ftp://support.red-gate.com/patches/SQLSearch/17Nov2017/SQLSearch.exe
  
  I hope this helps to resolve it for now.
  
  Kind regards and have a good weekend!

  RichardL February 16, 2018 17:01

  - 0 +
• 
  Using 3.0.7 I get zero results. Nothing at all. re-indexing does not do anything. SSMS vs 17.5

  Fjames56 March 03, 2018 17:57

  - 0 +
• 
  Hi @Fjames56
  
  Thanks for your post.
  
  As stated we currently recommend reverting to SQL Search version 3.04
  You can get it from my link below.
  
  ftp://support.red-gate.com/patches/SQLSearch/17Nov2017/SQLSearch.exe
  
  I hope this helps to resolve it for now but please keep an eye out for the next release.

  RichardL March 05, 2018 13:40

  - 0 +
• 
  thanks, I did that over the weekend and it does work.

  Fjames56 March 05, 2018 13:50

  - 0 +
• 
  Hi,
  
  I have some good news.  V3.1.0.1966 is now available that fixes the problems with SQL Search returning false results or no results.
  
  In the background, the indexing module of SQL Search has been redesigned to fix the problems reported in this forum thread.
  
  If you wish to upgrade to SQL Search V3.1.0.1966, please use the link below to download:
  
  ftp://support.red-gate.com/patches/SQLSearch/20Mar2018/SQLSearch_3.1.0.1966.zip 
  
  Many thanks
  Eddie

  Eddie D March 21, 2018 16:10

  - 0 +
• 
  Indeed this is GREAT news!!
  
  I just installed it, and I promise to get back here in 24h and tell about my experience.

  motionmotion March 21, 2018 16:22

  - 0 +
• 
  OMG!! you added wildcards, made me happy   THANKS!

  motionmotion March 21, 2018 16:26

  - 0 +
• 
  Is this available on the home page download link or only through this ftp link?

  gflores March 21, 2018 16:54

  - 0 +
• 
  Hi @gflores
  
  Thanks for checking this. 
  
  It is available both from the link above and also from our Website in the link below which is http.
  
  http://download.red-gate.com//checkforupdates/SQLSearch/SQLSearch_3.1.0.1966.exe
  
  I hope this helps. 
  
  Best
  
  Richard Lynch. 

  RichardL March 21, 2018 17:16

  - 0 +
• 
  For me, 3.1.0.1966 is giving correct results.

  alphonseg March 23, 2018 20:50

  - 0 +
• 
  Am I the only one having issues? It just keeps "indexing" forever and never finishes. I tried this on two computers and different servers. On a different computer, I used an older version and indexing was seconds.
  
  Btw, using ssms v17.5.

  gflores March 23, 2018 20:52

  - 0 +
• 
  So far, fast and accurate.  Reindex looks to be 10x faster than it used to be.

  cell001uk March 23, 2018 21:33

  - 0 +
• 
  Works fine for me.
  
  The only issue is that it sometimes does not refresh the results after my search. I need to toggle on and off the "Match whole words only" checkbox in order to see the results my the search.
  
  But the good news is that the search is back accurate, previous version was certainly dangerous. Thanks RG for the fix and for the new wildcard search functionality you brought with it.

  motionmotion March 24, 2018 00:36

  - 0 +
• 
  i've installed from zip link but when opening SSMS now , it throws this error:
  
  The SQL Source Control is no longer available and the SQL Search button doesn;t work.
  
  I've had to spend time uninstalling and reinstalling the toolbelt to get back to where i was before.
  
  How can i install the new version of sql search without encountering this error?

  kalo March 24, 2018 11:27

  - 0 +
• 

  gflores said:

  Am I the only one having issues? It just keeps "indexing" forever and never finishes. I tried this on two computers and different servers. On a different computer, I used an older version and indexing was seconds.

  
  I confirm glfores' issue. Start it up, indexing is fairly quick against my local database. Much slower against remote and Azure. Also seems to reindex every time the server is changed, so switching back and forth is difficult.
  
  Then, against a remote server on which I only have permissions for a single database, the "indexing forever" issue begins. Nothing can stop it. Disconnect from the remote server. No change. Disconnect from all servers. No change. Close the Search tab. Reopen. Still "indexing."
  
  Have to restart SSMS to get back to ground zero. Since 95% of the time I'm using this against my local development DBs, it's not a showstopper (yet), but it's definitely an issue.
  
  
  As far as accuracy goes--in my initial tests, this release seems to have solved the original problem. 
  

  Jason Hannas March 26, 2018 15:07

  - 0 +
• 
  I loaded the program from the link and when I put in a search parameter, it does nothing, I hit re-index, it does nothing. 

  Fjames56 March 26, 2018 16:14

  - 0 +
• 
  Hi @Jason Hannas and @Fjames56
  
  Thank you for this info. 
  
  We have alerted the development team to these indexing issues and they are now being worked on under bug reference number SDI-735. 
  
  We will get back to you on this as soon as it has been fixed. 
  
  Kind regards
  
  Richard Lynch. 
  
  
  

  RichardL March 27, 2018 14:01

  - 0 +
• 
  @RichardL - I updated the latest version of SSMS (that came out just a few days ago) and the latest build of SQL Search is working fine now. I'd recommend the others update their SSMS too (@Jason Hannas)

  gflores April 02, 2018 15:45

  - 0 +
• 
  Hi @kalo
  
  Thanks for your post and apologies for the delay in reply. 
  
  Please find the very latest version in the link below which should get around this issue. 
  
  ftp://support.red-gate.com/patches/SQLSearch/04Apr2018/SQLSearch_3.1.3.2006.exe
  
  Do let us know if there are still any issues. 
  
  Best
  
  Richard Lynch. 

  RichardL April 10, 2018 08:46

  - 0 +
• 
  Thank goodness, I had stopped using it as it didn't do the one thing it's supposed to: search.
  
  Still no "exclude comments" option for excluding commented sections in stored procedures?

  clemsontiger April 10, 2018 17:40

  - 0 +
• 
  Hi @clemsontiger
  
  Thanks for your post. 
  
  Another version has just been released today if you'd like to try it. It is available below. 
  ftp://support.red-gate.com/patches/SQLSearch/16Apr2018/SQLSearch.exe
  
  Kind regards
  
  Richard. 

  RichardL April 16, 2018 13:11

  - 0 +
• 

  RichardL said:

  Hi @kalo
  
  Thanks for your post and apologies for the delay in reply. 
  
  Please find the very latest version in the link below which should get around this issue. 
  
  ftp://support.red-gate.com/patches/SQLSearch/04Apr2018/SQLSearch_3.1.3.2006.exe
  
  Do let us know if there are still any issues. 
  
  Best
  
  Richard Lynch. 

  
  Boom! thank you Richard - this has installed without error , and my first search has come back with results. 

  kalo April 19, 2018 17:44

  - 0 +
• 
  @RichardL the last version you linked to, I'm not seeing any exclude comments option available.

  clemsontiger May 09, 2018 13:16

  - 0 +

Add comment

Please sign in to leave a comment.