SSMS Shared SQL Templates

  • Comments posted to this topic are about the item SSMS Shared SQL Templates

  • Very clear and nice writing style....thanks.

  • I hadn't thought of using the directory link, we use something similar for our SQL Prompt snippets rather than templates.

    What if one of your users wanted to have their own version of something, and didn't want to share? This is our (my) situation, and our solution was to create a cmd file that sits in the startup folder, and copies down the scripts from the shared location to the local directory on login.

    In this way, I still get shared scripts, I can still save the ones I want to share to the main location, but I can develop my own without worrying about cluttering up everyone else's.

    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Very well written article. Since the mklink feature is only available on Windows 7, I decided to share a tool that I've been using for quite a while to achieve the same functionality on Windows XP.

    This tool is called Junction and is part of the Sysinternals suite of tools that everybody loves.

    Download it from here:

  • Thanks for the article.

    To use shared templates, we overwrite the existing templates, whichever ones we want/need, with ours. We distributed a batch file to perform this action.


  • Thank you. I really enjoy the technical writing and hope to publish more.

    -- Carl

  • Great article! I haven't been involved for too long with SQL Server but you seem to know a lot about the inner workings. It's too bad that a lot of so called DBA's only know the gui. Hope to see more articles from you soon.

  • Thanks a lot for this Artcicle

    I used to create a separate folder "MY TEMPLATES" in the Sql Path but doing your way i can now leave my MY TEMPLATES in my own directory and not have to paste it in the Sql path


  • Excellent article. I wish Microsoft weren't neglecting SSMS, and ESPECIALLY the "Solutions" feature... 😓 From here: It reads: "Important. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."

    This is disheartening to me. Very shortsighted of Microsoft if you ask me.

    I was not familiar with the Templates functionality as you described per se in this article. I knew there were templates delivered with the installation of SSMS itself, I just never bothered looking for them. So, THANK you for teaching me something new.

    Now, tying what I mentioned before, I hope Microsoft does not have plans to deprecate Templates as well... It just seems that ALL their efforts nowadays are directed towards Azure this, Azure that, yadah, yadah, yadah. Very frustrating.

    Anyways, peace, be well, R.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply