Prompt 9 Error in SSMS 18.5

• 
  Same behaviour for me. SSMS 18.5. SQL Prompt 10.1.3.14531. Tried repair. Restarted RedgateClient service. SQL prompt menu present in full in SSMS but nothing on it works.
  Update: now fixed. Of course once it was broken 'Check for updates' from within SSMS was also broken but I downloaded the latest release via this forum (see - 'The latest release of SQL Prompt is available here'). Uninstalled and reinstalled. That has resolved all issues. :-)

  davidagriffiths April 09, 2020 11:11

  - 0 +
• 
  Any way to resolve this issue without upgrading to version 10?
  

  Arclight April 14, 2020 13:43

  - 0 +
• 
  Hi @Arclight
  
  No, you'll need to upgrade to version 10 in order for SQL Prompt to support SSMS 18.5.

  Sarah B April 15, 2020 13:18

  - 0 +
• 
  Forced upgrade with no warning.  Nice customer service.  Grrr...
  

  Arclight April 15, 2020 13:24

  - 0 +
• 
  Hi @Arclight
  
  Did SQL Prompt (excuse the pun) prompt you to update?  
  
  Major releases are free for users with a current Support and Upgrades contract.
  
  

  If you don't have a current Support and Upgrades contract, installing a major release will start a free 14-day trial.  If you wish to continue using that major version you'll need to purchase an upgrade.

  Sarah B April 15, 2020 13:39

  - 0 +
• 
  SQL Prompt 10 dropped support for SQL Server 2005 database, so if you still want to use SQL Prompt with it you're stuck with SQL Prompt 9 even if you pay for support
  

  Powlin April 16, 2020 13:07

  - 0 +
• 
  Hi @Powlin
  
  SQL Prompt 10 will likely still work when connected to a SQL Server 2005 instance, it just isn't formally supported any more. Therefore, you should still be able to use it.
  
  Thanks

  TomW April 17, 2020 07:22

  - 0 +
• 
  Ok glad to hear it, because It also use SQL Compare and SQL Data Compare and they removed support for SQL 2005 from the recent version so when I see the same change in SQL Prompt I supposed that the same method was used.
  

  Powlin April 17, 2020 13:49

  - 0 +
• 
  Here's a link to previous versions of SSMS that can be used with SQL Prompt 9....
  
  https://sqlserverbuilds.blogspot.com/2018/01/sql-server-management-studio-ssms.html
  
  

  TML April 20, 2020 13:02

  - 0 +
• 
  
  Please note RedGate that I am still seeing this message despite the fact that I have upgraded to SQL Prompt 10. Running SSMS v18.5 and SQL Prompt v 10.1.0.13908
  
  What is my next move here @Sarah B  ?
  
  Cheers
  
  Joe
  
  

  JoeGT May 03, 2020 01:29

  - 0 +
• 
  Hi @JoeGT
  
  The fix for SSMS 18.5 support was only released in SQL Prompt v10.1.4, so you'll need to update to that version.
  
  Thanks,
  Tom

  TomW May 04, 2020 07:23

  - 0 +
• 
  Thank you @TomW
  
  I can confirm I did the update to that version and the issue is now resolved

  JoeGT May 07, 2020 01:25

  - 0 +
• 
  Would have been nice if this incompatibility was called out in the Known Issues for SSMS 18.5
  https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#known-issues-185
  
  I find it very disappointing that a "dot" release of SSMS breaks a tool as popular as SQL Prompt, forces an upgrade to same, and the incompatibility is not called out.
  

  VisualDragon May 11, 2020 15:12

  - 0 +

Add comment

Please sign in to leave a comment.