Sql-server – SSMS Template Browser Add-In development

sql serversql-server-2012ssms

Okay, I’m trying to do something that I just can’t seem to get accomplished and I haven’t found anything online to address this request.

In the “Template Browser” I want to add another category of templates to keep the various templates separate. Looking at the template browser, there are two icons in the “header”. One icon is for the “SQL Server Templates” and the other is for the “Analysis Services Templates”. (See icons in red circle in the image below.)

I want to add a third icon (or more) to the header along with the “SQL Server Templates” icon and “Analysis Services Templates” icon.

Does anybody know if this is possible, and if so, how do you do it? I'm a full-stack developer / DBA / BI and would like to build / modify this on my own as opposed to just installing a third party solution.

I have SQL Server 2012 with an instance of SSMS 2012 and an instance of SSMS 2018.

enter image description here

Best Answer

That would likely fall into the realm of SSMS Add-In Development. Having said that, I'm not certain you can add a button to the Template Browser, even then.

Microsoft has a GitHub repo with a sample SSMS Add-In here.