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

SQL Prompt 9.4 and SQL Search menu not available in SSMS 2008 R2

Hello there,

I have just installed from this package SQLDeveloperBundle.exe, today to my Win 10 machine.
Found out SQL Prompt 9.4 and SQL Search menu not available in SSMS 2008 R2 are not working.
I have tried some of the options for the fixing, and also re-installing but couldn't make it work.
any help greatly appreciated

thanks
Ruth
elvis
0

Comments

12 comments

  • Victoria W
    Hi @...

    Sometimes, after upgrading SQL Prompt (or a bundle of products that contains SQL Prompt), it will disappear from the Redgate toolbar in SQL Server Management Studio.

    This can sometimes be fixed by repairing the SIP Framework installation:

    1. Open Programs and Features
    2. Right-click SSMS Integration Pack Framework 1 and select Repair

    You should now be able to access SQL Prompt normally but if it still doesn't appear in Management Studio uninstall and reinstall the tool.

    1. Open Add or Remove Programs
    2. Click on SQL Prompt and select Uninstall

    3. Install the latest version of the tool
    Victoria W
    0
  • Gamper
    Same issue, but the solution suggested doesn't change anything for me. Can't get the SQL Prompt menu.. I use SSMS 2017.. 
    tried uninstall and install several times..
    pls advice
    Gamper
    0
  • Tianjiao_Li
    @Gamper

    Found out SQL Prompt 9.4 and SQL Search menu not available in SSMS 2008 R2 are not working.
    Latest version of SQL Prompt and SQL Search are not supported anymore in SSMS 2008 R2, but it should work in SSMS 17.

    What's the full version of your SSMS 17? If you go to C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions , do you see SQLPrompt and SQLSearch folder?

    Do you have any other addins in SSMS?



    Tianjiao_Li
    0
  • Gamper
    SQL SSMS v17.9
    I see SQLSearch but not SQLPrompt in that folder.
    I also have SQL Source Control, which is also in that folder. 
    Gamper
    0
  • Gamper
    what to try next? Is it not installed correct?
    Gamper
    0
  • Tianjiao_Li
    @Gamper

    Reinstall usually should resolve the issue. 

    As you are supported, we've opened a support ticket and will get back to directly.
    Tianjiao_Li
    0
  • Gamper
    @Tianjiao_Li, any progress on the support ticket?
    Gamper
    0
  • Gamper
    @Tianjiao_Li, any update pls...?
    Gamper
    0
  • Russell D
    Do you have an open ticket? I'll try and find out, but I can't find any matching details.
    Russell D
    0
  • Gamper
    Hi @Russell D
    I have what you see in this thread.. @Tianjiao_Li said he would open a support ticket...?
    Gamper
    0
  • Tianjiao_Li
    @Gamper

    We indeed emailed you on 26th Nov. I'm sorry if you didn't receive it. I've resent again and please get back in touch if you still don't receive anything.
    Tianjiao_Li
    0
  • Gamper
    Hi @Russell D 
    Ticket number: #126378
    Gamper
    0

Add comment

Please sign in to leave a comment.