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

Clicking on SQL Search Crashes SSMS

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
0

Comments

29 comments

  • BTP
    Found logs but nothing in relating to any errors
    BTP
    0
  • ATurner
    Hi BTP

    To confirm are you using the latest SSMS 19.0.2?
    ATurner
    0
  • TDM
    I'm on SSMS 19.0.2, downloaded the latest SQL Search. Shows on the toolbar, but clicking it crashes SSMS
    TDM
    0
  • TDM
    Is there a beta build that might work with the latest SSMS?
    TDM
    0
  • 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.
    ATurner
    0
  • DannySpringer
    Same here, installed ssms 19.0.2 and as soon as I click sql search, SSMS crashes. Nothing in the logfiles.
    DannySpringer
    0
  • BTP
    SSMS 19.0.2 - crashes everytime you try SQL Search as above
    BTP
    0
  • ATurner
    Hi All

    The dev team are aware of this issue and are looking into it.
    ATurner
    0
  • eagle
    Any update to Search working with 19.0.2?  

    Any workaround in the meantime for using SQL Search besides using SSMS 18?
    eagle
    0
  • ATurner
    Hi eagle

    There was a fix released yesterday, SQL search version 3.6.2 that should have a fix for this.
    ATurner
    0
  • 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.
    eagle
    0
  • 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... :-)
    SJP
    0
  • PaulNewtonMarco
    Can you provide the link for 3.6.2 please, thanks.
    PaulNewtonMarco
    0
  • ATurner
    ATurner
    0
  • PaulNewtonMarco
    ATurner said:
    Thank you, mine is working again
    PaulNewtonMarco
    0
  • 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.
    DannySpringer
    0
  • 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.
    algrote
    0
  • 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.
    AndrewH
    0
  • Miles404
    ATurner said:
    Thank you, I had same problem, this fixed it for me.
    Miles404
    0
  • 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
    Faded
    0
  • AndrewH
    Uninstalling Search, repairing SSMS via Control Panel, rebooting laptop/PC, and then installing Search again resolved the problem for me.
    AndrewH
    0
  • 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?
    Faded
    0
  • 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
    RobertShattock
    0
  • Stefan Hoffmann
    Happens here using SSMS 19.1.56.0 and SQL Search 3.6 downloaded today..
    Stefan Hoffmann
    0
  • Lewistremonti
    Same here using Using SSMS 19.1.56.0 and SQL Search 3.6.1.3286 downloaded today
    Lewistremonti
    0
  • IowaDave
    Same for me: clicking on SQL Search 3.6.1.3286 in SSMS 19.1 crashes SSMS.
    IowaDave
    0
  • 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.
    ATurner
    0
  • IowaDave
    @ATurner - that worked!  THANKS SO MUCH!!!!
    IowaDave
    0
  • Oliphant
    The 3.6.3.3612 worked.   The .3390 version stopped the crash, but did not work properly , this one does both
    Oliphant
    0

Add comment

Please sign in to leave a comment.