How to change the folder used by SSMS for Template Explorer

Question

I would like to change the folder that SSMS uses for the template explorer in the network folder.

This will allow me to easily share my templates with my colleagues.

Answer 1

I don’t know a way to change the location, but you can configure the login script to copy the templates from the central location to the default location for the templates.

There is an article here with one approach. Not an ideal, but perhaps a suitable solution.