How can we help you today? How can we help you today?

SSMS 19.0 and SQL Search

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.
SS123456
0

Comments

16 comments

  • 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.  

    Ben_P
    0
  • 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.
    jboyer
    0
  • 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
    0
  • 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
    Ben_P
    0
  • SS123456
    Thank you, installed and working
    SS123456
    0
  • piotrszen
    HI, I got problem with ssms 19. when I clik on  button SSMS 19 is restarting.
    piotrszen
    0
  • 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
    piotrszen
    0
  • 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
    Ranjeetc
    0
  • 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 :)
    piotrszen
    0
  • 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!
    nanoDBA
    0
  • 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
    TDM
    0
  • 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.
    axis
    0
  • 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
    0
  • 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
    0
  • 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
    0
  • 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?
    lcaceres
    0

Add comment

Please sign in to leave a comment.