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


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

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