This is a quick one today as a follow-up to my previous post on using the SSMS Template explorer. While I do like the convenience of using the template explorer to store frequently used scripts, one of my biggest complaints was the fact that all the scripts are buried several directories down under the C:\users directory (windows 7).
Carl Demelo shared an awesome way to move your template directory to a different directory on SQL Server Central. This solution will only work on Windows 7 using the new shell command mklink.
I tried it out to move my template directory to a network drive that gets backed up on a regular basis. It worked perfect, thanks Carl!