SSMS Shared SQL Templates

Question

Post reply

SSMS Shared SQL Templates

CarlDemelo

SSC Enthusiast

Points: 151
More actions
January 8, 2012 at 9:33 pm

#253012

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

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

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

David McKinney SSChampion Points: 10472 More actions · Answer 1

David McKinney

SSChampion

Points: 10472

January 9, 2012 at 2:55 am

#1430337

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

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

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

fmblopes SSC Enthusiast Points: 159 More actions · Answer 3

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

CGSJohnson SSCertifiable Points: 7208 More actions · Answer 4

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

CarlDemelo SSC Enthusiast Points: 151 More actions · Answer 5

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

-- Carl

b3236551 Grasshopper Points: 11 More actions · Answer 6

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.

Heslous SSC Enthusiast Points: 160 More actions · Answer 7

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

rferreira.dba Old Hand Points: 301 More actions · Answer 8

Excellent article. I wish Microsoft weren't neglecting SSMS, and ESPECIALLY the "Solutions" feature... 😓 From here: https://learn.microsoft.com/en-us/sql/ssms/solution/solution-explorer?view=sql-server-ver16 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.