SSMS 19.0 and SQL Search

SS123456

I installed the SSMS 19.0 release, uninstalled and reinstalled SQLPrompt and SQL Search with latest versions.  SQL Prompt works in SSMS 19, but the SQL Search button is missing.

I followed the advice on this forum from other versions (uninstalled/reinstalled, rebooted, etc) and it still isn't working  Any advice for SSMS 19?

I still have SSMS 18.12.1 installed and SQL search is working there.

Ben_P

Hi @SS123456 thank you for your post. 

currently only SQL Prompt supports SSMS 19. SQL Search and the other tools do not. 

Work has begun on updating the tools though to support SSMS 19.  There should be an announcement on the Forum when this is released.  

jboyer

I am a bit mystified: work has begun? Was Redgate kept in the dark on SSMS19 or is this new app so different from 18 that it required tons of changes on RedGate tools. Disappointing.

Ben_P

Hi @jboyer,

There was a breaking change in preview 4 of SSMS 19. The tools were changed to work with the earlier previews but 4 introduced the change.

Ben_P

Hi all, just to confirm SQL Search now supports SSMS 19 GA in the latest release. SQL Search updates automatically so if you've opened SSMS recently then this should have updated SQL Search but if not then you can download the latest version here: 

https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

SS123456

Thank you, installed and working

piotrszen

HI, I got problem with ssms 19. when I clik on  button SSMS 19 is restarting. 

piotrszen

piotrszen said:

HI, I got problem with ssms 19. when I clik on  button SSMS 19 is restarting. 

ok, small update - I had problem with SSMS 19.0.2. It works with 19.0.1

Ranjeetc

I have the same problem i have installed the latest version of SQL  Search  3.6.1.3286 . SSMS v19.0.2 automatically closes out when search is hit, This does not happen in SSMS v18.12.1

piotrszen

Ranjeetc said:

I have the same problem i have installed the latest version of SQL  Search  3.6.1.3286 . SSMS v19.0.2 automatically closes out when search is hit, This does not happen in SSMS v18.12.1

Hi, SQL Search works on SSMS 19.0.1 - I had the same issue as you with v.2

nanoDBA

Ben_P said:

Hi all, just to confirm SQL Search now supports SSMS 19 GA in the latest release. SQL Search updates automatically so if you've opened SSMS recently then this should have updated SQL Search but if not then you can download the latest version here: 

https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

Installing this corrected the startup errors I was seeing in SSMS 19.0.2 - thank you!

TDM

Tried the download linked above but it is still the same version (3286) publicly available in through the main download link (with a different filename) and it still crashes 19.0.2

axis

TDM said:

Tried the download linked above but it is still the same version (3286) publicly available in through the main download link (with a different filename) and it still crashes 19.0.2

Same here.

VVG

I had same issue with 19.0.2. SSMS Crashing once I hit SQL Search button.
Installed 19.0.1 and still exactly same result. Crashing again.
Any suggestions to fix this?

VVG

I do have this same version of SQL Search on my machine https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

VVG

I do have this same version of SQL Search on my machine https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

lcaceres

Ben_P said:

Hi all, just to confirm SQL Search now supports SSMS 19 GA in the latest release. SQL Search updates automatically so if you've opened SSMS recently then this should have updated SQL Search but if not then you can download the latest version here: 

https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe

I also have the latest version of SSMS 19.02 and tried this link, and have the same crashing issue when clicking the SQL Search button. Any resolution available?