How to prevent SQL Search from Crashing SSMS 19.1.56

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

  Robyn July 12, 2023 16:09

  - 0 +
• 
  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

  chj124 July 13, 2023 11:21

  - 0 +
• 
  I have the same issue.  Going to try reverting to a previous version of SSMS
  

  StanCOS July 13, 2023 20:18

  - 0 +
• 
  I installed 19.0.2 and the problem went away.
  

  StanCOS July 13, 2023 20:26

  - 0 +
• 
  I was wrong.  Still crashing SSMS

  StanCOS July 13, 2023 20:27

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

  StanCOS July 13, 2023 20:57

  - 0 +
• 
  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?

  Dan_J July 17, 2023 06:52

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

  chj124 July 17, 2023 12:11

  - 0 +
• 
  Crashing here as well.

  djsavlon July 17, 2023 13:04

  - 0 +
• 
  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 July 17, 2023 20:13

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

  ATurner July 20, 2023 18:51

  - 0 +

Add comment

Please sign in to leave a comment.