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

2016 April Preview doesn't see SQL Prompt

PDinCAPDinCA Posts: 642 Silver 1
edited May 27, 2016 11:05AM in SQL Prompt
Already running the latest 7.2 build, I downloaded and, as Administrator, installed SSMS April Preview, which is still the latest build according to the SSMS Check for Updates.

SQL Prompt is not there.

I ran a Repair from Programs and Features.

Still not there.

Many reboots have since occurred. Still.......

View ==> Toolbars ==> no sign of Red Gate anything.

SSMS 2014 is running just fine, with SQL Prompt and ApexSQL items in the main menu (textual).

Fix, please?

Running Windows 8.1 Pro, 64-bit, patched to the gunnels automatically.

Microsoft SQL Server Management Studio 13.0.14000.36
Microsoft Analysis Services Client Tools 13.0.1400.353
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18321
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    Hi Stephen,

    All the version numbers look good to me, SQL Prompt should be loading into that SSMS version. Could you check if you have the following directory:
    C:Program Files (x86)Microsoft SQL Server130ToolsBinnManagementStudioExtensionsSQLPrompt
    
    It should contain a extension.vsixmanifest and RedGate.SQLPrompt.SsmsPackage.pkgdef file, which are used to tell SSMS2016 to load SQL Prompt.

    One thing to try is installing this build to see if performing an upgrade (rather than a repair) fixes it.

    Thanks,
    Aaron.
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    That solved the problem immediately. Many thanks.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
  • Options
    I have the same problem but am already on the latest version of SQL Prompt so it won't allow upgrade and as previously mentioned, Repair option doesn't install it into SSMS 2016 Preview.
    I don't want to uninstall / reinstall SQL Prompt as I'll lose my tab history and server tab colour coding ...

    Any advice is appreciated.

    Thanks,

    Rob.
  • Options
    Aaron LAaron L Posts: 596 New member
    Hi Rob,

    Uninstalling/reinstalling won't remove any settings or your tab history so it's safe to do.

    If you want to make a backup of your settings and tab history just in case, you can make a copy of the folder where they are all stored:
    %localappdata%Red GateSQL Prompt 7
    

    Thanks,
    Aaron.
  • Options
    That did the trick ... and I didn't lose anything either :D

    Thanks.
Sign In or Register to comment.