Just Code‎ > ‎

SSMS - Adding your own addin to SSMS

posted Mar 25, 2013, 8:52 AM by Peter Henell   [ updated Apr 5, 2013, 12:10 AM ]
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>
Comments