SQL Search now available for SSMS 19

Victoria WVictoria W Posts: 396 Gold 2
in SQL Search
We're happy to announce that SQL Search is now available for SSMS 19.

You can download the latest version here:
https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe 
Kind regards

Victoria Wiseman | Redgate Software
Have you visited our Help Center?
Tagged:
· Share on Twitter
«1

Comments

  • bush3102bush3102 Posts: 1 New member
    Is there a timeline for this version to be available from this link?
    https://www.red-gate.com/products/sql-development/sql-search/installer/
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @bush3102

    The link has now been updated - thanks for flagging it up!
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • jjohnjjohn Posts: 1 New member
    edited March 15, 2023 5:09PM
    I am running SSMS ver 19.0.1. I just downloaded SQLSearch_3.6.1.3286.exe from link above. When I install, it appears to be trying to install 3.6. Error SQL Search 3.6 MSI returned failure code 1603: Fatal error during installation. Microsoft SQL Server Management Studio (SSMS) 2005,2008,2012,2014,2016,2017 or SQL Server Management Studio Express (SSMSE) 2008 required.  Is there a new updated link?
    UPDATE: I have resolved my issue. Had to uninstall SQL Search 3 (older version) using Revo Uninstaller due to fatal error when regular uninstall run. Then install ver 3.6.1.3286 successfully.

    · Share on Twitter
  • RanjeetcRanjeetc Posts: 4 New member
    SSMS v19.0.2 automatically closes when SQL search button is clicked. I have the latest version installed. This does not happen in SSMS v18.12.1
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @Ranjeetc

    Please can you try uninstalling and reinstalling SQL Search first:

    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.1.3286.exe 

    If this doesn't help, are there any recent events in the SSMS event viewer? Can you send over the SSMS logs?

    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • RanjeetcRanjeetc Posts: 4 New member
    @Victoria W I followed your steps but still the same issue , unfortunately i don't have access to SSMS logs 
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    HI @Ranjeetc

    It's just been confirmed that this is a bug in the latest version of SQL Prompt.

    We're working on this right now but in the meantime please can you downgrade to the previous version until we have a fix:
    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe

    I'll let you know as soon as there's a release.
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • RanjeetcRanjeetc Posts: 4 New member
    @Victoria W
    Thanks for the info.
    · Share on Twitter
  • iokevinsiokevins Posts: 5 Bronze 1
    Hi @Victoria W hoping all is well, how does SQLSearch_3.6.1.3286.exe released on February 21, 2023 resolve the following long-standing issue (if at all)? Thank you

    "Stop SQL Server from trying to login to all databases on the instance"
    https://forum.red-gate.com/discussion/89373/stop-sql-server-from-trying-to-login-to-all-databases-on-the-instance

    @Eddie D on Nov 7, 2022 (before the latest release):
    "The Development Team responsible for SQL Search are in the process of adding a fix for this situation.  I do not have an accurate ETA but the team plan to release this fix sometime next week."

    However, no news since on this issue in several months since his Nov 7 post and no response after one week to my follow-up question in the thread.

    Thank you! 
    · Share on Twitter
  • iokevinsiokevins Posts: 5 Bronze 1
    Hi @Victoria W hoping all is well, how does SQLSearch_3.6.1.3286.exe released on February 21, 2023 resolve the following long-standing issue (if at all)? Thank you

    "Stop SQL Server from trying to login to all databases on the instance"
    https://forum.red-gate.com/discussion/89373/stop-sql-server-from-trying-to-login-to-all-databases-on-the-instance

    @Eddie D on Nov 7, 2022 (before the latest release):
    "The Development Team responsible for SQL Search are in the process of adding a fix for this situation.  I do not have an accurate ETA but the team plan to release this fix sometime next week."

    However, no news since on this issue in several months since his Nov 7 post and no response after one week to my follow-up question in the thread.

    Thank you!  :]
    · Share on Twitter
  • JR_AUSJR_AUS Posts: 17 Bronze 2
    Victoria W said:
    ... please can you downgrade to the previous version until we have a fix:
    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe
    I have downloaded this version and installed to SSMS 19.0.20209. The Search app toolbar does not appear and is not available to add when trying to customise the menu. I have uninstalled and reinstalled multiple times.
    ~JR~
    · Share on Twitter
  • JR_AUSJR_AUS Posts: 17 Bronze 2
    JR_AUS said:
    Victoria W said:
    ... please can you downgrade to the previous version until we have a fix:
    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.0.3167.exe
    I have downloaded this version and installed to SSMS 19.0.20209. The Search app toolbar does not appear and is not available to add when trying to customise the menu. I have uninstalled and reinstalled multiple times.
    Update: I uninstalled SSMS 19.0.2 and reinstalled 19.0.1 and SQL Search 3.6.1.3286 works. 

    SQL Search is fairly important to me  :]
    ~JR~
    · Share on Twitter
  • AndyReilly68AndyReilly68 Posts: 1 New member
    Ranjeetc said:
    SSMS v19.0.2 automatically closes when SQL search button is clicked. I have the latest version installed. This does not happen in SSMS v18.12.1
    I'm getting exactly the same 
    · Share on Twitter
  • gfloresgflores Posts: 8 Bronze 1
    AndyReilly68 said:
    Ranjeetc said:
    SSMS v19.0.2 automatically closes when SQL search button is clicked. I have the latest version installed. This does not happen in SSMS v18.12.1
    I'm getting exactly the same 

    Same. they're working on it. 
    https://forum.red-gate.com/discussion/comment/170204/#Comment_170204
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi all

    I'm pleased to report that we've fixed this bug in the latest version of SQL Search:

    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe

    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • jboyerjboyer Posts: 12 Bronze 2
    Victoria W said:
    Hi all

    I'm pleased to report that we've fixed this bug in the latest version of SQL Search:

    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe

    Thanks a lot.
    · Share on Twitter
  • StefnStefn Posts: 1 Bronze 1
    Victoria W said:
    Hi all

    I'm pleased to report that we've fixed this bug in the latest version of SQL Search:

    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe

    Thanks, that has resolved the issue for me.

    The general download link still downloads 3.6.1.3286
    https://www.red-gate.com/products/sql-development/sql-search/installer/

    · Share on Twitter
  • gerthauangerthauan Posts: 9 New member
    Victoria W said:
    Hi all

    I'm pleased to report that we've fixed this bug in the latest version of SQL Search:

    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.2.3390.exe

    @Victoria W I have just downloaded the latest version from your site, 3.6.3.3612. In SSMS 19.1 there is still an issue with SSMS shutting down when clicking the SQL Search-button.

    Also, when I tried to install the above version, I got a message sayiing that there was already a newer version installed on the system. I had to uninstall and then install this version in order to be able to see the SQL Search button in SSMS 19.1 at all.

    What version should I install in order for SQL Search to work in both SSMS 18 and 19.1?
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @gerthauan

    Please can you uninstall SQL Search using this Microsoft uninstaller tool:
    https://www.tenforums.com/tutorials/86975-program-install-uninstall-troubleshooter-windows.html 

    This tool is good for removing rogue registry keys that can cause installation problems.

    Then do a fresh install. The latest version of SQL Search will work with SSMS 18 and 19:
    https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.6.3.3612.exe 
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • ggoeppelggoeppel Posts: 4 New member
    edited June 28, 2023 5:51PM
    Just hangs ssms 19 for me. Then crashes

    Faulting application name: Ssms.exe, version: 19.1.56.0, time stamp: 0x64685293
    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: 0x1a9c
    Faulting application start time: 0x01d9a83c466f5286
    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: b078c930-8115-45bc-b779-1eee26632605
    Faulting package full name: 
    Faulting package-relative application ID: 
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @ggoeppel

    We have had reports of this issue but have been unable to reproduce it as yet. 

    It would be useful to have a copy of your event log if possible? I will reach out in a support ticket so that you don't have to share this information on the forum.
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • TimWongDevTimWongDev Posts: 1 New member
    @Victoria W - I've been also getting the same issues. Did a clean install of SQL Search but clicking on the SQL Search button just shuts down my SSMS. Started happening when I installed the latest SSMS version (19.1).

    <div>Log Name:&nbsp; &nbsp; &nbsp; Application</div><div>Source:&nbsp; &nbsp; &nbsp; &nbsp; Application Error</div><div>Date:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/6/2023 11:10:31 AM</div><div>Event ID:&nbsp; &nbsp; &nbsp; 1000</div><div>Task Category: (100)</div><div>Level:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Error</div><div>Keywords:&nbsp; &nbsp; &nbsp; Classic</div><div>User:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N/A</div><div>Computer:&nbsp; &nbsp; &nbsp; .....</div><div>Description:</div><div>Faulting application name: Ssms.exe, version: 2023.160.20209.0, time stamp: 0x640c19f5</div><div>Faulting module name: Microsoft.Data.SqlClient.SNI.x86.dll, version: 3.0.1.0, time stamp: 0x63d4772c</div><div>Exception code: 0xc0000409</div><div>Fault offset: 0x00015819</div><div>Faulting process id: 0x2240</div><div>Faulting application start time: 0x01d9b01bf56ba6e6</div><div>Faulting application path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe</div><div>Faulting module path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Microsoft.Data.SqlClient.SNI.x86.dll</div><div>Report Id: b52c2186-8ff3-46ad-860a-58beb6105a26</div><div>Faulting package full name:&nbsp;</div><div>Faulting package-relative application ID:&nbsp;</div><div>Event Xml:</div><div><Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"></div><div>&nbsp; <System></div><div>&nbsp; &nbsp; <Provider Name="Application Error" /></div><div>&nbsp; &nbsp; <EventID Qualifiers="0">1000</EventID></div><div>&nbsp; &nbsp; <Version>0</Version></div><div>&nbsp; &nbsp; <Level>2</Level></div><div>&nbsp; &nbsp; <Task>100</Task></div><div>&nbsp; &nbsp; <Opcode>0</Opcode></div><div>&nbsp; &nbsp; <Keywords>0x80000000000000</Keywords></div><div>&nbsp; &nbsp; <TimeCreated SystemTime="2023-07-06T15:10:31.1933521Z" /></div><div>&nbsp; &nbsp; <EventRecordID>45843</EventRecordID></div><div>&nbsp; &nbsp; <Correlation /></div><div>&nbsp; &nbsp; <Execution ProcessID="0" ThreadID="0" /></div><div>&nbsp; &nbsp; <Channel>Application</Channel></div><div>&nbsp; &nbsp; <Computer>......</Computer></div><div>&nbsp; &nbsp; <Security /></div><div>&nbsp; </System></div><div>&nbsp; <EventData></div><div>&nbsp; &nbsp; <Data>Ssms.exe</Data></div><div>&nbsp; &nbsp; <Data>2023.160.20209.0</Data></div><div>&nbsp; &nbsp; <Data>640c19f5</Data></div><div>&nbsp; &nbsp; <Data>Microsoft.Data.SqlClient.SNI.x86.dll</Data></div><div>&nbsp; &nbsp; <Data>3.0.1.0</Data></div><div>&nbsp; &nbsp; <Data>63d4772c</Data></div><div>&nbsp; &nbsp; <Data>c0000409</Data></div><div>&nbsp; &nbsp; <Data>00015819</Data></div><div>&nbsp; &nbsp; <Data>2240</Data></div><div>&nbsp; &nbsp; <Data>01d9b01bf56ba6e6</Data></div><div>&nbsp; &nbsp; <Data>C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Ssms.exe</Data></div><div>&nbsp; &nbsp; <Data>C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Microsoft.Data.SqlClient.SNI.x86.dll</Data></div><div>&nbsp; &nbsp; <Data>b52c2186-8ff3-46ad-860a-58beb6105a26</Data></div><div>&nbsp; &nbsp; <Data></div><div>&nbsp; &nbsp; </Data></div><div>&nbsp; &nbsp; <Data></div><div>&nbsp; &nbsp; </Data></div><div>&nbsp; </EventData></div><div></Event></div>
    · Share on Twitter
  • mickysoxmickysox Posts: 2 New member
    Any update on this? I have 19.1 fresh install of SQL Search and it crashes SSMS every time I try and open SQL Search.
    · Share on Twitter
  • mickysoxmickysox Posts: 2 New member
    Hi, if you are having problems, it's looks like the download link is pointing to 3.6.1.  If you go to https://download.red-gate.com/checkforupdates/SQLSearch and download 3.6.3.x install that, it works great with 19.1.

    @redgate please update the link on the main site.
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @mickysox

    That's been done, sorry for the inconvenience!
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • csuirecsuire Posts: 25 Bronze 3
    edited November 3, 2023 4:33PM
    SQL Search and SQL Prompt had disappeared from SSMS 2018 and 2019.1 for me recently.
    Multiple SQL Search and SSMS Integration uninstall and reinstall attempts did not fix it.

    After reinstalling SSMS 2019.1 it poppped up an error. I must have clicked "do not show again" that mentioned C:\Users\MYUSERNAME\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml
    Inside of that at the bottom I found a SQL Search error: CreateInstance failed for package [SqlSearchSsmsPackage]Source: &apos;mscorlib&apos; Description: String cannot have zero length.&#x000D;&#x000A;

    Searching for that let me to another post which resolved the issue.
    https://forum.red-gate.com/discussion/87025/sqlsearchssmspackage-not-loading-correctly

    I had to delete SQL Search files that were not being removed during uninstall and reboots and reinstalls.
    So after uninstalling SQL Search, and then delete some left over files in C:\Program Files (x86)\Red Gate\SQL Search\, and reinstalling, That fixed the issue for me.

    Here's the entire error message I found in case it helps redgate resolve this issue for future users:
    <entry>
        <record>273</record>
        <time>2023/11/03 15:53:24.649</time>
        <type>Error</type>
        <source>VisualStudio</source>
        <description>CreateInstance failed for package [SqlSearchSsmsPackage]Source: &apos;mscorlib&apos; Description: String cannot have zero length.&#x000D;&#x000A;System.ArgumentException: String cannot have zero length.&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark&amp; stackMark)&#x000D;&#x000A;   at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)&#x000D;&#x000A;   at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)&#x000D;&#x000A;   at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)</description>
        <guid>{26218D92-039D-466C-BF66-EAE1098379BE}</guid>
        <hr>80004005 - E_FAIL</hr>
        <errorinfo></errorinfo>
      </entry>

    · Share on Twitter
  • RichardMGreenRichardMGreen Posts: 24 Bronze 1
    Hi all

    A bit late to the party here but I've just installed SSMS V19.1 and I can't get SQL Search to appear in the GUI.

    When I try to install either of the versions from the links above, I get the message saying I have a newer version installed.

    I've been into Control Panel to try and uninstall it but it won't disappear.

    I'm just installing SSMS V19.2 so I'll let you know how that goes but is this another bug in the software?

    Regards

    Richard
    · Share on Twitter
  • RichardMGreenRichardMGreen Posts: 24 Bronze 1
    Hi all

    Installed SSMS V19.2 and SQL Search not available.  I've tried to uninstall SQL Search from control panel but it won't go.  I've deleted everything I can find to do with it (in Program Files, Program Files (x86), AppData) but still no joy.

    I can't install either of the versions mentioned here as the setup file is saying I've got a new version installed.

    Anyone any ideas?

    Regards

    Richard
    · Share on Twitter
  • Victoria WVictoria W Posts: 396 Gold 2
    Hi @RichardMGreen

    Have you tried uninstalling SQL Search using this Microsoft uninstaller tool:
    https://www.tenforums.com/tutorials/86975-program-install-uninstall-troubleshooter-windows.html 

    Then reinstalling?
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • RichardMGreenRichardMGreen Posts: 24 Bronze 1
    Hi @Victoria W

    Just tried that but it said it couldn't fix the issues.  I went through all the details and they all said "Issue not present" so I'm at a complete loss now.

    Regards

    Richard
    · Share on Twitter
Sign In or Register to comment.