Options

How to prevent SQL Search from Crashing SSMS 19.1.56

chj124chj124 Posts: 3 New member
in SQL Search
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?
Tagged:
· Share on Twitter

Answers

  • Options
    RobynRobyn Posts: 180 Silver 5
    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. 
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • Options
    chj124chj124 Posts: 3 New member
    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
    · Share on Twitter
  • Options
    StanCOSStanCOS Posts: 4 New member
    I have the same issue.  Going to try reverting to a previous version of SSMS
    · Share on Twitter
  • Options
    StanCOSStanCOS Posts: 4 New member
    I installed 19.0.2 and the problem went away.
    · Share on Twitter
  • Options
    StanCOSStanCOS Posts: 4 New member
    I was wrong.  Still crashing SSMS
    · Share on Twitter
  • Options
    StanCOSStanCOS Posts: 4 New member
    edited July 13, 2023 8:58PM
    After uninstalling SQL Search, rebooting and then reinstalling, it seems to be working.  Still have not gone back to SSMS 19.1.x yet

    · Share on Twitter
  • Options
    Dan_JDan_J Posts: 450 Silver 2
    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?
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • Options
    chj124chj124 Posts: 3 New member
    I do not have any other Redgate products, i did try uninstall/reinstall and no change
    · Share on Twitter
  • Options
    djsavlondjsavlon Posts: 1 New member
    Crashing here as well.
    · Share on Twitter
  • Options
    ATurnerATurner Posts: 192 Silver 2
    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 
    · Share on Twitter
  • Options
    ATurnerATurner Posts: 192 Silver 2
    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. 
    · Share on Twitter
Sign In or Register to comment.