Clicking on SQL Search Crashes SSMS

BTP

I have recently moved to a new PC and installed everything again
Latest build of SSMS integration installed, fresh local SQL Engine and SSMS
Everything else worksing (SQL History etc) but I click on SQL Search and it crashes everytime

Local  SQL 
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)   Mar 18 2018 09:11:49   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor) 

Event Log

Faulting application name: Ssms.exe, version: 2023.160.20209.0, time stamp: 0x640c19f5

Faulting module name: Microsoft.Data.SqlClient.SNI.x86.dll, version: 3.0.1.0, time stamp: 0x63d4772c

Exception code: 0xc0000409

Fault offset: 0x00015819

Faulting process ID: 0x1e78

Faulting application start time: 0x01d95bd442662c5c

Faulting application path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe

Faulting module path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Microsoft.Data.SqlClient.SNI.x86.dll

Report ID: 88861f73-4918-4b76-a770-a587e9aecdf5

Faulting package full name: 

Faulting package-relative application ID: 

Not Sure where the logs are for SQL Prompt/Search are located

BTP

Found logs but nothing in relating to any errors

ATurner

Hi BTP

To confirm are you using the latest SSMS 19.0.2? 

TDM

I'm on SSMS 19.0.2, downloaded the latest SQL Search. Shows on the toolbar, but clicking it crashes SSMS

TDM

Is there a beta build that might work with the latest SSMS?

ATurner

Hi TDM

There is a known issue with 19.0.2 that the development team are working on currently. It does work on 19.0.1 however. 

DannySpringer

Same here, installed ssms 19.0.2 and as soon as I click sql search, SSMS crashes. Nothing in the logfiles.

BTP

SSMS 19.0.2 - crashes everytime you try SQL Search as above

ATurner

Hi All

The dev team are aware of this issue and are looking into it.

eagle

Any update to Search working with 19.0.2?  

Any workaround in the meantime for using SQL Search besides using SSMS 18?

ATurner

Hi eagle

There was a fix released yesterday, SQL search version 3.6.2 that should have a fix for this. 

eagle

ATurner said:

Hi eagle

There was a fix released yesterday, SQL search version 3.6.2 that should have a fix for this. 

Thank you, yes, this works again for me.

SJP

I installed 3.6.2, however the dropdown for the databases was empty and when I clicked on it to see the list then it crashed SSMS 19.0.2

Strange: I didn't change anything, but it started working perfectly today... :-)

PaulNewtonMarco

Can you provide the link for 3.6.2 please, thanks.

ATurner

Hi PaulNewtonMarco

Here is the link https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe 

PaulNewtonMarco

ATurner said:

Hi PaulNewtonMarco

Here is the link https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe 

Thank you, mine is working again

DannySpringer

SJP said:

I installed 3.6.2, however the dropdown for the databases was empty and when I clicked on it to see the list then it crashed SSMS 19.0.2

Strange: I didn't change anything, but it started working perfectly today... :-)

I already had this problem some times, without a crash, but with the new version it crashes when the database dropdown is empty.

algrote

I had the same problem and 3.6.2 solved the problem. But when you download from normal site we still have 3.6.1 version. Should be updated in the download web page.

AndrewH

I'm running SSMS 19.0.2 and Search 3.6.2.3390 and still having crashes every time I try to use Search.

Miles404

ATurner said:

Hi PaulNewtonMarco

Here is the link https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe 

Thank you, I had same problem, this fixed it for me.

Faded

AndrewH said:

I'm running SSMS 19.0.2 and Search 3.6.2.3390 and still having crashes every time I try to use Search.

Unfortunately this is the same for me. Is there a new 

AndrewH

Uninstalling Search, repairing SSMS via Control Panel, rebooting laptop/PC, and then installing Search again resolved the problem for me.

Faded

AndrewH said:

I'm running SSMS 19.0.2 and Search 3.6.2.3390 and still having crashes every time I try to use Search.

Unfortunately this is the same for me. Is there a new version of SQL Search that might fix this?

RobertShattock

SSMS 19.0.2 crashes with the version of SQL Search installed from the RedGate website (their support are aware that this isn't the latest version and it has an issue but don't want to update it). Their support team provided the link for the latest version which works for me: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.3.3612.exe 

Stefan Hoffmann

Happens here using SSMS 19.1.56.0 and SQL Search 3.6 downloaded today..

Lewistremonti

Same here using Using SSMS 19.1.56.0 and SQL Search 3.6.1.3286 downloaded today

IowaDave

Same for me: clicking on SQL Search 3.6.1.3286 in SSMS 19.1 crashes SSMS.

ATurner

Hi All
Apologies, the site is serving an older version! Here is a link to the version compatible with 19.1 https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.3.3612.exe have escalated this with the team. 

IowaDave

@ATurner - that worked!  THANKS SO MUCH!!!!

Oliphant

The 3.6.3.3612 worked.   The .3390 version stopped the crash, but did not work properly , this one does both