How can we help you today? How can we help you today?

SQL Prompt Wont appear in SSMS 21

Hi

I can understand that SQL Promt should work in SSMS 21 now from this post:
https://documentation.red-gate.com/sp/getting-started/installing-and-running-sql-prompt

I have tried to install newest version

I have tryed to uninstall SQL Promt and reinstalling it again, but the plugin wont work or appear in the Extensions menu.

I have the latest SSMS preview and the latest SQL Promt versions

Anyone who can help?

Rasmus
4

Comments

25 comments

  • Vic
    Official comment

    Hi Rasmus 

    SQL Prompt added preview support for SSMS 21 as of version v10.16.6. It's possible to patch into a current version of Prompt and add it into SSMS 21 for usage.
     
    The latest version V10.16.8 can be accessed here:
    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.11.16409.exe 
     
    It may be necessary to make some changes to settings in SSMS 21 to enable the Redgate extensions, please refer to this guide and the section Running SQL Prompt with SSMS 21 Preview:
    https://documentation.red-gate.com/sp/getting-started/installing-and-running-sql-prompt
     
    The main setting to check is that both SQL Prompt extensions are disabled in the Extensions > Customize Menu... menu selection.

    Vic
  • Rasmus

    Hi 

    Thanks for replying on my ticket.

    I have version: SQL Promt 10.16.11.16409 installed (as mentioned tryed to uninstall the old and install again):
     

     

    And SSMS 21.0.0 Preview 6.0:
     

     

    The extension doesn't show up in:
     

    Niether does the menu:

    Rasmus
    1
  • Vic

    Hi Rasmus @... 

    How are you installing SQL Prompt; are you installing on both SSMS and VS or just SSMS? 

    Are you installing the software or is an admin installing it for you (is the installer being run as a different user to the one running SSMS?) 

    Does SQL Prompt appear in other versions of SSMS that you have installed? 

    Vic
    0
  • Rasmus

    In the installation proces i choose both SSMS and VS.

    It is me who has executed the installation, and i have done it both with my own user and tryed to elevate it to administrator. 

    SQL Promt works fine in SSMS 20.2.30.0 and in VS 2022 Version 17.13.6 on the same server

    Rasmus
    0
  • ted

    I have tried multiple times to get Sql Prompt installed on SSMS 20.0 preview 7 and have been unsuccessful.  

    ted
    0
  • Vic

    Hi all

    Please can you try uninstalling SSMS 21 and SQL Prompt and then reinstall, SSMS first and then SQL Prompt, to see if that fixes the issue.

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.11.16409.exe 

    Vic
    1
  • Rasmus

    It worked

    The only difference in the installation is that I placed the program files folder in the suggested place instead of on our application drive as we usually do.

    Thanks for your support

    Rasmus
    0
  • Ed Carden

    FYI - Grant Fitchey left a post today saying he can see SQL Prompt in his 21.X preview version  of SSMS

    Ed Carden
    0
  • Rasmus

    Just did the installation again on a new server.

    Both Visual studio and SSMS 21 preview 6 are installed on our applikation drive (E) and same result as ealier.

    Visual studio is working with SQL Promt

    SSMS 21 Preview 6 is not working with SQL promt.

    seems like SQL Promt can't find it on other drives.

    On this server i can't install it on C so is there a work aorund for this ?

    Rasmus
    0
  • SelectStar

    It was working in the preview for me, but now that SSMS 21 has gone GA, Prompt is no longer working.  RedGate, can you please flip whatever switch needs to be flipped to enable Prompt with the GA release?  Thanks.

    SelectStar
    10
  • Klaus Ondrich

    It was working with all SSMS 21 Preview versions, but even the current SQL Prompt version 10.16.12 does not appear after installing release version of SSMS 21 and reinstalling SQL Prompt (and SQL Search).
    I know the manual to enable it with customizing Extensions Menu, bit SQL Prompt is not listed there anymore. I guess because the Preview version used the Preview channel and folder and the Release version uses the Release channel and folder. Maybe other internal folder/registry path settings should refer to the Release channel now.

    Klaus Ondrich
    8
  • kiinxx00

    You will note it is still currently installing under the Extensions Preview folder-

    C:\Program Files\Microsoft SQL Server Management Studio 21\Preview\Common7\IDE\Extensions

     

    Copy the entire SQLPrompt folder from the Preview folder to the Release folder-

    C:\Program Files\Microsoft SQL Server Management Studio 21\Release\Common7\IDE\Extensions

     

    It will now work

    kiinxx00
    9
  • Klaus Ondrich

    Thank you for the hint. I didn't look into the folders myself until then.
    Yes, SQL Prompt and SQL Search menu buttons appear after moving the files from Preview to Release folder.
    SQL Prompt settings and code suggestions are working.

    However, an empty tab is opened when clicking the SQL History or SQL Search button.

    Klaus Ondrich
    1
  • ADAM WORONIEC

    After fussing with where the files were being installed, I can view the 2 SQL Prompt listings in the extension menu, and have unchecked them, but doing this makes no changes, and cannot get any SQL prompt functionality working beyond seeing them on that list.  

    ADAM WORONIEC
    2
  • Curtis

    I believe you need to remember to click on the ‘Save and Restart’ button after you uncheck the boxes.

    Curtis
    2
  • Vic

    Support for SSMS 21 GA with SQL Prompt should be available with the next release of SQL Prompt. 

    Once this new version is out the release notes will also be updated here:

    https://documentation.red-gate.com/sp/release-notes-and-other-versions

    Vic
    2
  • Klaus Ondrich

    In my last post, I wrote:

    However, an empty tab is opened when clicking the SQL History or SQL Search button.

    This can be worked around by disabling the new SSMS option “Optimize rendering for screens with different pixel densities” in Tools/Options, section “General”.
    Disabling this option is generally a good idea, because Registered Servers pane will also displayed as empty when it's enabled.

    Klaus Ondrich
    0
  • terry

    Vic Any ETA for this? Upgraded to SSMS 21 (release) thinking this would already be working.

     

    Thanks

    terry
    0
  • kiinxx00

    Looks like official release available now for SQL Prompt 11.0

    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.0.0.16715.exe

    kiinxx00
    0
  • John

    kiinxx00 FYI it will not import your version 10 settings. Be sure to export first at a minimum.

    John
    0
  • Vic

    Yes, SQL Prompt 11 is now available in SSMS 21 GA - it won't work in the preview versions.

    You can copy these settings manually from v10 folder to v11 folder by following below steps.

    1. Copy contents of

    C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\CodeAnalysis to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\CodeAnalysis

    1. Copy contents of

            C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Snippets to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Snippets

    1. Copy contents of

           C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Styles to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Styles

    Copy ConnectionColoringCategories.xml, ConnectionColoringServers.xml, RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml, RedGate_SqlPrompt_Engine_EngineOptions.xml files from C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\

    Vic
    1
  • Alin

    Moderators: While the problem is somewhat similar, not sure if commenting here is the best idea, or I should have opened a new thread. Please move this comment around as needed.

    Problem: I've installed latest release of SQL Prompt 11 (11.0.0.16715) on the latest version of SSMS 21 (21.1.3). While it appears to be working… syntax completion, edit styles (was able to set my custom folder for styles from there), the top menu entry is completely missing.

    In SSMS 20 that still appears fine, and SMSS 21 Preview the menu is now also gone after the update - which makes sense given is no longer supported.

    Things I've tried:

    1. in the extension menu, the 2 SQL Prompt options (were already ticked) untick → save → restart SSMS, tick again → save → restart SSMS. No change.
    2. copy the contents as per the previous comment - this helps bringing the previous settings in lack of being able to import via the options menu - but, obviously it doesn't bring the menu

    Although is not specified exactly which version SQL Prompt 11 supports beyond the major version (SSMS 21), and seeing the release of SQL Prompt 11 was just a day later after the release of the SSMS 21.1.3, I guess is entirely possible that it could have worked on the initial GA version, but got broke by the latest update…

    I think the take away from the above would be that may be a good idea to specify in the release notes the SSMS version supported (i.e. tested up to version x.1.2.3.4, but could work on newer versions as well at user's risk, etc). But also please fix this :)

    Alin
    0
  • SelectStar

    Alin I have the Prompt menu item in SSMS 21.1.3.  You need to leave the SQL Prompt checkboxes UN-checked for the menu item to show up.

    SelectStar
    0
  • Alin

    Thank you! Although I've tried based on some screenshots a few messages back (or I thought I did!) that bit already, reluctantly trying again it seems fine now.

    Alin
    1
  • Rasmus

    Vic Same problem in the new release. When installing SSMS 21 on another drive than default(C), SQL Promt is not instllaed into SSMS 21. Works with SSMS 20.

    Rasmus
    3

Add comment

Please sign in to leave a comment.