SSMS - Adding your own addin to SSMS

Post date: Mar 25, 2013 3:52:10 PM

The wizard in Visual studio will set up a nice and clean plugin, but it does not enable the plugin in SSMS. To share your plugin this is very simple in SQL Server 2012 and above (it used to be hell and nightmares in older version of ssms).

1) Copy MyOwnPlugin.addin to C:\ProgramData\Microsoft\MSEnvShared\AddIns (C:\Users\Public\Documents\microsoft\MSEnvShared\AddIns was old location for vs2010)

You may need to create the folders.

2) Edit SSMSAddinDenali.addin - Change the <Assembly></Assembly> to be there your binary is.

MyOwnPlugin.addin:

<?xml version="1.0" encoding="UTF-16" standalone="no"?><Extensibility xmlns="http://schemas.microsoft.com/AutomationExtensibility"> <HostApplication> <Name>Microsoft SQL Server Management Studio</Name> <Version>*</Version> </HostApplication> <Addin> <FriendlyName>MyOwnPlugin</FriendlyName> <Description>Some plugin made for SQL Server 2012</Description> <AboutBoxDetails>For more information see http://www.peterhenell.se</AboutBoxDetails> <Assembly>X:\YOUR PATH TO YOUR PLUGIN\MyOwnPlugin.dll</Assembly> <FullClassName>MyOwnPlugin.Connect</FullClassName> <LoadBehavior>0</LoadBehavior> <CommandPreload>1</CommandPreload> <CommandLineSafe>0</CommandLineSafe> </Addin></Extensibility>