SQL Prompt load error in SSMS 10.11

bhawth_tx

I've had SQL Prompt failing to load in SQL Management Studio (17.1.2) lately. Works fine in Visual Studio 2022. Latest version of SQL Prompt.

I've uninstalled/scrubbed the registry of SQL Prompt, reinstalled, to no avail. Any suggestions?

From SSMS ActivityLog.xml:

<entry>

    <record>293</record>

    <time>2022/04/05 20:46:29.681</time>

    <type>Warning</type>

    <source>VisualStudio</source>

    <description>Unexpected system error mode before loading package [SQLPromptSsmsPackage18]</description>

    <guid>{E33B8A3B-D1CF-4EB0-92AA-0590F0B55B1A}</guid>

  </entry>

  <entry>

    <record>294</record>

    <time>2022/04/05 20:46:29.681</time>

    <type>Information</type>

    <source>VisualStudio</source>

    <description>Begin package load [SQLPromptSsmsPackage18]</description>

    <guid>{E33B8A3B-D1CF-4EB0-92AA-0590F0B55B1A}</guid>

  </entry>

  <entry>

    <record>295</record>

    <time>2022/04/05 20:46:29.693</time>

    <type>Error</type>

    <source>VisualStudio</source>

    <description>CreateInstance failed for package [SQLPromptSsmsPackage18]Source: &apos;mscorlib&apos; Description: Could not load type &apos;RedGate.SQLPrompt.SsmsPackage18.SQLPromptSsmsPackage18&apos; from assembly &apos;RedGate.SqlPrompt.SsmsPackage18, Version=10.11.9.27382, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos;.&#x000D;&#x000A;System.TypeLoadException: Could not load type &apos;RedGate.SQLPrompt.SsmsPackage18.SQLPromptSsmsPackage18&apos; from assembly &apos;RedGate.SqlPrompt.SsmsPackage18, Version=10.11.9.27382, Culture=neutral, PublicKeyToken=7f465a1c156d4d57&apos;.&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)&#x000D;&#x000A;   at System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)&#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>{E33B8A3B-D1CF-4EB0-92AA-0590F0B55B1A}</guid>

    <hr>80004005 - E_FAIL</hr>

    <errorinfo></errorinfo>

  </entry>

dkim1999

Hi Brent,
 
I am glad to hear that uninstalling and reinstalling SQL Prompt has fixed your issue. 
 

It could be that the file in question became corrupted somehow and reinstalling and updated it to a working version.

Thank you!

David Kim

Product Support Engineer