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

SQL Prompt - Menu greyed out

SQL Prompt menu is greyed out since I upgraded to version 8.
I am unable to refresh suggestions as well as other menu options.
Tagged:

Comments

  • Options
    This also happened to myself and 3 other developers. The SQL prompt menu is available and works in VS2015, but is not available in SSMS 2008 R2. The Red Gate menu is also greyed out... I've tried repairing the SSMS Integration Pack 1 and SSMS Integration Pack Framework 1 entries in the installed programs menu of Windows, but that did not have any effect.
  • Options
    James RJames R Posts: 104 Silver 4
    Hi @Phil,

    Thanks for your post. Unfortunately SQL Prompt no longer supports SSMS 2008R2 and lower. You can upgrade your version of SSMS for free here

    Hope this helps!

    James
    Software Engineer
    Redgate Software
  • Options
    Beards_247Beards_247 Posts: 3 New member
    James R wrote: »
    Hi @Phil,

    Thanks for your post. Unfortunately SQL Prompt no longer supports SSMS 2008R2 and lower. You can upgrade your version of SSMS for free here

    Hope this helps!

    James

    @James R I have SQL 2016 SSMS studio, I my menu is grayed out also. To be fair, my work station has 2008 r2 and 2014 - so perhaps that's where the failure comes from.
  • Options
    Hi @Beards_247

    SQL Prompt should install to all versions that it is able to be installed to. It being greyed out sounds like a licensing issue.

    Are you able to check if Prompt is activated correctly? If you go to SQL Prompt- Help - About, can you see your serial number in the left bottom corner?

    Thanks.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.