I am trying to write an add-in into the SSMS 2008 R2 IDE. I believe it is possible, though maybe not fully supported by Microsoft.
I have created a new project in Visual Studio 2010 of type Extensibility - Visual Studio Add-in. This has created my project and all of the relevant code to get the add-in loaded onto the Tools menu. THe only line of code I have added is inot the
OnConnection method to display a messagebox so I know it has at least loaded.
When I build this as is, it will load as an Add-in into VS 2010 onto the Tools menu - which is fine - at least part is working. But when I try to add this as an Add-in into SSMS 2008 it keeps giving me the error message:
The Add-in 'DataFollower.Connect' failed to load or cause an exception. Would you like to remove this add-in? ... Error Message: Class not registered Error number: 80040154
To get this add-in registerd in SSMS I followed the methods found using google searches. And loaded into the registry :
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\Addins\DataFollower.Connect]
View Complete Post