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!