SQL Search in SSMS 18.5.1 not working

JoJ · June 15, 2020 8:06AM

Just installed SSM 18.5.1 and installed SqlSearch 3.5.1.2598 but the button in ssms does nothing.
Also tried the previous version of sqlsearch 3.5.0.2590 but no succes.

Any sugestions?

Victoria W · June 16, 2020 12:37PM

Hi @JoJ

Did you upgrade to SSMS 18.5 and then install SQL Search 3.5.1.2598 or did you install SQL Search before the SSMS upgrade?

If it was before, you'll need to install SQL Search 3.5.1.2598 again now that you've upgraded SSMS.

If it was after upgrading SSMS, please can you attach a screenshot of what you're seeing?

JoJ · June 16, 2020 12:43PM

Hi,

I installed SQL Search 3.5.1.2598 after I installed SSMS 18.5.
I can not send you a screenshot because there is nothing to see when I click on the button.

Maybe there is al logfile but I don't know where.

Ladewig · June 16, 2020 2:51PM

I'm having the same issue as @JoJ where clicking the SQL Search button in the toolbar in SSMS 18.5.1 does nothing.

I had upgraded to SSMS 18.5.1, and after upgrading clicking the SQL Search button did nothing. I then uninstalled SQL Search, downloaded the current version from the website, then installed it again. I then started SSMS and the problem remains: clicking SQL Search doesn't do anything.

If I uninstall SSMS 18.5.1 and go back to 18.4 which is what I had previously been running, SQL Search 3.5.1.2598 works again.

Victoria W · June 17, 2020 8:23AM

Hi all

I have just been advised that this is a known issue and for now we have a workaround.

When you're connected to the server, and if SQL Search is disabled, choosing disconnect on Object Explorer then connecting enables SQL Search.

JoJ · June 17, 2020 8:58AM

Hi Victoria,

Your solution does not work for me.
The button in ssms is not disabled, it doesn't do anything.

Image: https://us.v-cdn.net/6029854/uploads/editor/u6/bn904o3k576g.jpg

paul_deffenbaugh · June 17, 2020 6:49PM

Hello. I upgraded to SSMS 18.5.1 and have lost the SQL Search menu option completely even with SQL Search 3.5.0.2590 installed. I'm happy to try installing SQL Search 3.5.1.2598 if a link to it is provided.

Ladewig · June 17, 2020 9:34PM

@Victoria W It's working for me now. Thanks.

Victoria W · June 18, 2020 7:48AM

Hi @paul_deffenbaugh

Whenever a new version of SSMS is installed, the Redgate add-on tools need reinstalling after the upgrade.

Here's the latest SQL Search installer:
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.1.2598.exe

Ladewig · June 18, 2020 11:25AM

@Victoria W Just an FYI, that the link on the support article about 18.5 compatibility (https://productsupport.red-gate.com/hc/en-us/articles/360008725017) has a link that says it is for 3.51.2598, but the link goes to 3.50.2590.

Other links on that page are incorrect as well with the text older than the link or vice versa.

Victoria W · June 19, 2020 11:34AM

Thanks for pointing this out @Ladewig, I've updated the links!

michaelmm · June 20, 2020 4:24PM

The linked version worked. Thanks,

undunc · June 22, 2020 3:34PM

This link is still serving 3.4.1.2506 https://www.red-gate.com/products/sql-development/sql-search/installer/

cell001uk · June 24, 2020 6:19AM

I'm having this problem now in SSMS 18.5.1, version 15.0.18333.0. I see the SqlSearch button and it's enabled, but clicking does nothing. I've unintalled SqlSearch and installed the version mentioned above, but nothing seems to fix it.

Victoria W · June 24, 2020 11:13AM

Hi @cell001uk

This is a known issue the development team is aware of and they're working on a fix.

In the meantime, the workaround is to disconnect your SQL server from SSMS Object explore, then close and reopen SQL Search, finally reconnect your SQL Server.

Sorry for the inconvenience.

cell001uk · June 24, 2020 11:23AM

Hi I can't close and re-open sql search as it can't be opened to begin with. I might try uninstalling ssms and installation 18.5.0 instead.

undunc · June 24, 2020 2:46PM

I closed SSMS 18.5.1, deleted \Users\undunc\AppData\Local\Red Gate\SQL Search 3 folder, installed the linked https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.1.2598.exe file over the top of 3.4xxx and it worked for me on SSMS 18.5.1

Redgate can comment on whether that's a good idea or not

cell001uk · June 24, 2020 2:57PM

Won't work for me unfortunately as AppData\Local\Red Gate doesn't contain a folder for SQL Search 3

JoJ · June 25, 2020 5:45AM

The only working solutions for me was to uninstall everything from redgate.
Then to clean up the registery and all the folders from redate.

Then I installes ssms 18.4 and sql prompt 10.2.0.15168.

This worked for me.

Tianjiao_Li · June 25, 2020 12:36PM

@cell001uk

Could you try uninstalling all Redgate tools, and then reinstall the latest version using this installer: https://download.red-gate.com/installers/SQLToolbelt/2020-06-24/SQLToolbelt.exe

Tianjiao_Li · June 25, 2020 12:38PM

@JoJ

It should work fine in SSMS 18.5.1. If you upgrade your SSMS now, does SQL Search stop working again? So sorry for the inconvenience this is causing!

cell001uk · June 25, 2020 1:02PM

@Tianjiao_Li no joy unfortunately, same thing happens where the button is enabled but doesn't do anything.

StephenLag · June 30, 2020 6:33AM

I updated "SQL dependency Tracker" yesterday. I started SSMS after this update and now I have the same problem. The SQL Search button is enabled but isn't doing anything. Just before this update it still worked.

cell001uk · June 30, 2020 7:00AM

I have also reverted to SSMS 18.4 and Sql Search 3.4.1.2506 and works now.

Tianjiao_Li · June 30, 2020 8:30AM

@StephenLag

Would you mind to try uninstall and reinstalling SQL Search one more time and let us know if the problem persists?

I couldn't reproduce the issue with SQL Dependency tracker. Apart from those, do you have any other plugins in SSMS 18.5.1?

StephenLag · June 30, 2020 8:33AM

I did uninstall all redgate products and then reinstalling all but the problem still exists

Tianjiao_Li · June 30, 2020 8:36AM

Do you have any other plugins in your SSMS?

StephenLag · July 3, 2020 6:38AM

Yes, I have one other plugin installed but that plugin hasn't changed for a few months now.

I uninstalled everything, ran CCleaner(Custom Clean, Registry Clean), restarted, installed older version of all the redgate tools and it started working again.

If I then update to newest it stops working

cell001uk · July 8, 2020 6:47AM

Is there any further info on this problem? Is it experienced by everyone who upgrades ssms to 18.5 or only a few?

michaelmm · July 8, 2020 7:46PM

Sigh, it stopped working today after 18 days of bliss. Closed and opened a few times. Eventually started working. Sometimes the same behaviors do yield different results.
.

Tianjiao_Li · July 9, 2020 4:05PM

Thanks all for your patience!

Our development team is investigating this issue and we'll update here shortly.

SQL Search in SSMS 18.5.1 not working

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk