Post reply

SSMS Shared SQL Templates

  • January 8, 2012 at 9:33 pm

    #253012

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

  • January 9, 2012 at 2:55 am

    #1430337

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

  • January 9, 2012 at 7:39 am

    #1430461

    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."

  • January 9, 2012 at 7:53 am

    #1430473

    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: http://technet.microsoft.com/en-us/sysinternals/bb896768

  • January 9, 2012 at 8:25 am

    #1430502

    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.

    Thanks...Chris

  • January 10, 2012 at 6:59 pm

    #1431535

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

    -- Carl

  • January 11, 2012 at 11:51 am

    #1432027

    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.

  • August 7, 2014 at 4:45 am

    #1735906

    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


    Steph

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

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