SQLPrompt for SSMS 18.0

• 
  Hi @nsundararajan,
  
  Apologies for the delay in getting back to you. I'm pleased to confirm there is - SQL Prompt 9.5 was released yesterday and is on Check for Updates.

  
  

  You can find more info in the release notes. Any questions, let us know.
  
  Cheers,
  
  Roseanna

  Roseanna April 26, 2019 08:08

  - 0 +
• 
  I uninstalled SSMS 17 and installed SSMS 18. No VS on my machine (Windows 10 Pro ver 1809), just SSMS. When I run the install/upgrade for the SQL Toolbelt it shows upgrading SQL Prompt as an option but throws this error: "MSI returned failure code InstallFailure. Microsoft Visual Studio 2015+ or SQL Server Management Studio 2012+ is required"

  kendal.vandyke April 29, 2019 15:58

  - 0 +
• 
  Hi.

  I just installed SSMS 18 side by side with 17. After the update of SQL Prompt to 9.5.1 (popped up on first launch of SSMS after computer reboot) I'm getting an error window pointing to the ActivityLog.xml where I found:

  
  

  &nbsp; <entry><br>&nbsp;&nbsp;&nbsp; <record>251</record><br>&nbsp;&nbsp;&nbsp; <time>2019/05/02 14:58:22.433</time><br>&nbsp;&nbsp;&nbsp; <type>Information</type><br>&nbsp;&nbsp;&nbsp; <source>VisualStudio</source><br>&nbsp;&nbsp;&nbsp; <description>Begin package load [SQLPromptSsmsPackage2018]</description><br>&nbsp;&nbsp;&nbsp; <guid>{E33B8A3B-D1CF-4EB0-92AA-0590F0B55B1A}</guid><br>&nbsp; </entry><br>&nbsp; <entry><br>&nbsp;&nbsp;&nbsp; <record>252</record><br>&nbsp;&nbsp;&nbsp; <time>2019/05/02 14:58:22.438</time><br>&nbsp;&nbsp;&nbsp; <type>Error</type><br>&nbsp;&nbsp;&nbsp; <source>VisualStudio</source><br>&nbsp;&nbsp;&nbsp; <description>CreateInstance failed for package [SQLPromptSsmsPackage2018]Source: &apos;mscorlib&apos; Description: String cannot have zero length.&#x000D;&#x000A;System.ArgumentException: String cannot have zero length.&#x000D;&#x000A;&nbsp;&nbsp; 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;&nbsp;&nbsp; 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;&nbsp;&nbsp; at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark&amp; stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)&#x000D;&#x000A;&nbsp;&nbsp; at System.Reflection.RuntimeAssembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, Boolean suppressSecurityChecks, StackCrawlMark&amp; stackMark)&#x000D;&#x000A;&nbsp;&nbsp; at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)&#x000D;&#x000A;&nbsp;&nbsp; at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)&#x000D;&#x000A;&nbsp;&nbsp; at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)</description><br>&nbsp;&nbsp;&nbsp; <guid>{E33B8A3B-D1CF-4EB0-92AA-0590F0B55B1A}</guid><br>&nbsp;&nbsp;&nbsp; <hr>80004005 - E_FAIL</hr><br>&nbsp;&nbsp;&nbsp; <errorinfo></errorinfo><br>&nbsp; </entry><br>

  
  

  Any ideas on how to solve this?

  
  

  Thanks!
  

  jrguay May 02, 2019 16:06

  - 0 +
• 
  I tried installing 9.5.1 and got the same issue. I have to uninstall and go back to previous version then everything worked.

  nsundararajan May 02, 2019 16:46

  - 0 +
• 
  Hi everyone,
  
  I've flagged this with our Support team and we'll get back to you ASAP. Thank you for bringing this to our attention.
  
  Thanks,
  
  Roseanna

  Roseanna May 03, 2019 07:15

  - 0 +
• 
  A quick update on the above. There has been an issue with this version and our development team are working on a fix that we hope to release ASAP. We'll let you know once there's an update.
  
  Thanks for your patience everyone.
  
  Roseanna

  Roseanna May 03, 2019 07:30

  - 0 +
• 
  Thanks @RoseannaW!

  
  

  I just re-downloaded SQL Toolbelt (latest version) and installed SQL Prompt version 9.5.2 with an update of SSMS Integration Pack (2.1) and that seem to have fixed the issue in both SSMS 17 & 18.

  
  

  I hope this helps. Thank you for the help.
  

  Jose
  

  jrguay May 03, 2019 13:26

  - 0 +
• 
  Great news @jrguay!
  
  As Jose has said above, our Prompt team have released the fix. @kendal.vandyke and @nsundararajan - you download SQL Prompt 9.5.2 now and find further info in the release notes.
  
  Hope this helps you both!
  
  Roseanna

  Roseanna May 03, 2019 13:40

  - 0 +
• 
  It worked for me too. Thanks @redgate

  nsundararajan May 03, 2019 14:11

  - 0 +
• 
  Works for me now. Thanks for correcting this so quickly!

  kendal.vandyke May 06, 2019 14:15

  - 0 +

Add comment

Please sign in to leave a comment.