What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt load error in SSMS 10.11

bhawth_txbhawth_tx Posts: 1 New member
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>
Tagged:

Answers

  • Options
    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

Sign In or Register to comment.