Menu
I have SQL server 2008 R2 installed.
The SQL Prompt menu item is no longer displayed on the toolbar. To remove the menu item from Visual Studio 2010 and later: From the Tools menu, select Customize. Open the Commands tab. From the Controls list, select SQL Prompt, then click Delete. Click Close to close the dialog. The SQL Prompt menu item is no longer displayed on the toolbar.
In the past I have installed the Redgate Sql Promprt 5 add-in. It doesn't work anymore, but I still have the menu in the SQL Management Studio.
I don't see the add-in in the Programs and features list in windows 7, so I can't uninstall it. When I click on a command in the menu I get this message:
The Add-in supporting this command could not be loaded. Do you wish to remove the command?
When I choose 'Yes' it removes only the selected command from the menu.
I want to completely remove the add-in from my Management Studio.
Where can I find the add-ins and where can I configure them in Management Studio 2008 R2?
If I need to remove some files to get rid of it, where could I find these files?I looked in the installation folder and didn't find anything about add-ins...
ShaharShahar35611 gold badge44 silver badges1919 bronze badges
5 Answers
This should help:
Essentially, you have to use the 'Customize' functionality.
David AtkinsonDavid Atkinson4,55522 gold badges1919 silver badges2626 bronze badges
![Uninstall Uninstall](/uploads/1/2/4/9/124933687/490640682.png)
And now for the correct answer
To remove all addin from SQL Server Management Studio. Delete all keys from:
- HKEY_LOCAL_MACHINE
- SOFTWARE
- Wow6432Node
- Microsoft
- Microsoft SQL Server
- 100
- Tools
- Shell
- AddIns
- Shell
- Tools
- 100
- Microsoft SQL Server
- Microsoft
- Wow6432Node
- SOFTWARE
I didn't ask RedGate to slow down my SSMS with no way to disable it.
Ian BoydIan Boyd125k197197 gold badges705705 silver badges10221022 bronze badges
I had same issue under 120. It seems Addins are now stored in Program Data. I renamed file but didn't help. I had to open/run SSMS in Administrator mode and this fixed it. Later I deleted the Addin from folder 'C:ProgramDataMicrosoftSQL Server Management Studio12.0Addins'. May be you can try renaming the Addin with '_'. That was the only difference in me renaming the file and SSMS in Admin mode renaming it.
user6121177user6121177
I had the same error when loading SQL Server, an Add-in from another related application was giving that error. I didn't need that Add-in, but couldn't remove it. Even removing from the registry (thanks for posting that by the way) didn't work for me. I had to uninstall and reinstall the related application (Toad for SQL Server) and the 'Add-in' was no longer an issue.
Craig DinsmoreCraig Dinsmore
I was using SSMS Tools but it kept autosaving my queries which I couldn't easily disable. Therefore I had to remove add in.
Dasal KalubowilaDasal Kalubowila