How to prevent SQL Search from Crashing SSMS 19.1.56

chj124

When ever I click on the Sql Search icon, the cursor changes to a busy icon in SSMS and after a second SSMS closes.

I have downloaded and reinstalled the latest Sql Search and SSMS. Same issue.

On Windows 10. What to do?

Robyn

Hi, Thanks for your post. 

I'm going to raise a support ticket for you to see if we can find a resolution as so far we've been unable to reproduce the issue. 

chj124

I noticed this morning, after reinstalling SSMS and  SQL Search that when I click on the search icon, I see the outline it a rectangle in the lower half of the sceen, more to the left side. I tried to reproduce to get a screen shot but I could not replicate it. SSMS still crashed.

- System
  - Provider
   [ Name]  Application Error
  - EventID 1000
   [ Qualifiers]  0
   Version 0
   Level 2
   Task 100
   Opcode 0
   Keywords 0x80000000000000
  - TimeCreated
   [ SystemTime]  2023-07-13T11:14:18.3578390Z
   EventRecordID 14950
   Correlation
  - Execution
   [ ProcessID]  0
   [ ThreadID]  0
   Channel Application
   Computer XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
    Security
 - EventData
   ssms.exe
   19.1.56.0
   64685293
   Microsoft.Data.SqlClient.SNI.x86.dll
   3.0.1.0
   63d4772c
   c0000409
   00015819
   5558
   01d9b4b00e0f3f66
   C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\ssms.exe
   C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Microsoft.Data.SqlClient.SNI.x86.dll
   75431c50-1ad3-494f-ac40-85ff28b43f6b

StanCOS

I have the same issue.  Going to try reverting to a previous version of SSMS

StanCOS

I installed 19.0.2 and the problem went away.

StanCOS

I was wrong.  Still crashing SSMS

StanCOS

After uninstalling SQL Search, rebooting and then reinstalling, it seems to be working.  Still have not gone back to SSMS 19.1.x yet

Dan_J

Hi @chj124

Thank you for your last reply on this. 

Just to check, do you have any other Redgate applications installed?

If you also try uninstalling SQL Search (using the MS removal tool), rebooting your machine and reinstalling SQL Search, does SSMS still continue to crash?

chj124

I do not have any other Redgate products, i did try uninstall/reinstall and no change

djsavlon

Crashing here as well.

ATurner

Hi All,

Could you confirm what version of SQL Search you are using? Also where you downloaded? 
Could you try this version and let me know if it still errors? https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.3.3612.exe 

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.