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

Ruth

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

Victoria W

Hi @Ruth

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

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

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?

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

what to try next? Is it not installed correct?

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.

Gamper

@Tianjiao_Li, any progress on the support ticket?

Gamper

@Tianjiao_Li, any update pls...?

Russell D

Do you have an open ticket? I'll try and find out, but I can't find any matching details.

Gamper

Hi @Russell D
I have what you see in this thread.. @Tianjiao_Li said he would open a support ticket...?

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.

Gamper

Hi @Russell D 
Ticket number: #126378