User profile for csuire

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: 'mscorlib' Description: String cannot have zero length.
 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: 'mscorlib' Description: String cannot have zero length.
System.ArgumentException: String cannot have zero length.
 at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
 at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark& stackMark)
 at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
 at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)
 at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)</description> <guid>{26218D92-039D-466C-BF66-EAE1098379BE}</guid> <hr>80004005 - E_FAIL</hr> <errorinfo></errorinfo> </entry> / comments

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

0 votes

MatthiasMcRobbin said: I experienced the same issue with SQL Search 3.5.3 after upgrading from an earlier version of SSMS to 18.9.1. To resolve, I uninstalled SQL Search, deleted the "C:\Program Files (x86)\Red Gate" folder and installed SQL Search again. Thank you! I struggled with this issue this week with SSMS 2019.1 and SQL Search 3.6.7.3908 Multiple reinstalls did not work. But finally found your comment and deleted the left over files after another uninstall and that did fix the issue. Posted here mentioning this issue/fix too https://forum.red-gate.com/discussion/89626/sql-search-now-available-for-ssms-19? / comments

MatthiasMcRobbin said: I experienced the same issue with SQL Search 3.5.3 after upgrading from an earlier version of SSMS to 18.9.1.To resolve, I uninstalled SQL Search, deleted the "C:\Progr...

0 votes

This would help me to automatically add new cloned databases to my distribution list. Each time I use this program I have to go through these steps to add new cloned databases before running scripts. Configure->Expand Server->Highlight all dbs that start with a certain word->Add. / comments

This would help me to automatically add new cloned databases to my distribution list. Each time I use this program I have to go through these steps to add new cloned databases before running scrip...

0 votes

How can we help you today?

csuire

Comments