SSMS 2012 - Template Modification

Ran into a situation where i needed to modify the standard templates that SSMS uses to Create Stored Procedures, Functions, and some other scripts.

Problem:
I did not know where to find these templates.

First Solution:
Goto Code Snippet Manager and modify snippets.
Problem with this is that it requires you to create the XML snippet file and even then requires you to put it in, either the Public or Your Profile's, My Snippets folder. This does not solve the immediate problem as i would rather use the Context menu's New Stored Procedure (Function, etc).

After-Thought:
This solution though is great for things such as doing standard Select Statements for your organization.


Second Solution:
Edit the Template used, via Template Explorer.
This created a solution and was exactly what i needed, BUT this is Profile based on not Application based.

This solution is great if you want to do some edits to various templates, but understand that these edits will not be transferred to the SSMS context-menu implementation.  If you do not mind double-click'ing the templates from the Explorer to create the necessary object, then this will be your solution.

Any edits to the templates, via Template Explorer, will be stored in C:\Users\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\Templates\Sql and as such generally not accessible to SSMS as most of us use it.

This does however provide us a way to do mass edits to various SQL templates, thus providing a Part of the solution i need.

Final Solution:
Take Second Solution combined with Cut & Paste to actual directory (Need to be able to execute process as Administrator, when the prompt shows up.

  1. So take the steps completed from the Second Solution, you now need to open and explorer window to the path C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql (Or if you did a custom installation for SSMS, then its respective location, with notable subfolder being SqlWorkbenchProjectItems from the root location of SSMS.exe.
  2. Select either the file or folder, pends on how many edits you made, from the . If you made alot of SQL file edits acrossed multiple folders, then select either the folder(s) you made the edits in, or the parent folder of them.
  3. Now the most import, AND SUPER CRITICAL STEP, Copy & Paste the folder(s), from Step 2, and paste them into C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql. This of course pending on how many edits, but i would localize the paste into the folder(s) that you made the edits.

Result:
Now you can take these SQL Template files and use them from the Context menu in the various options available.  Most notable, for my situation, where the *.sql files with (New Menu) in the filename.

Comments

Post a Comment

Popular posts from this blog

SysInternals - BgInfo for ALL Users

Image
I have seen various sites that have been pretty good at getting close to the point of getting Background Information created by the tool BgInfo but none of them have actually solved my specific problem. Solutions currently out there include: Placing into the "All Users" folder This did not work for me, as our implementation does not contain an "All Users" folder in the "Users" folder for profiles. Reg-Hacking and HKCU or HKLM entry This is the worst of all the bad choices available.  I am experienced with Registry Editing and I still would not want or find a need to do this. Placing into the "Default" folder This is good going forward but what about those 20+ user profiles that are already logged in.  FYI, if your server has 20+ user account profiles in the "Users" directory you have larger problems than I am willing to assist with in this posting. The solution that worked for me, will be described below in pain-staki
Read more

JSON/AJAX Helpers

Recently, had an implementation where I needed to implement ASP.Net Web API 2 and accompanied it with Javascript/JQuery AJAX communication.  In doing this i found myself making the same pattern calls with some varying value for certain properties for the AJAX data calls.  As such, i ended up building a few helper functions to simply the inclusion of these various minor quirks based on what was needed.  Below  you will find the various forms. 1: /********************************************************************* 2: @type - dataType, such as 'json', 'xml', 'script', 'jsonp' or 'html' 3: @contentType - string value, represents the HTML type of content 4: IE: 'application/json; charset=utf-8' 5: @url - API URL, such as 'api/tasks' should be constrainted to the 6: Web API Controller 7: @success - Function(data, status, xhr) handler, The logic to execute 8: on a 200 res
Read more

Acquiring List of controls - Classic JS

Recently ran into a scenario where I need to use the low-level JavaScript parser, instead of JQuery.  During this venture, I ran across a situation where it would be easier for me to select all the HTML Elements with an ID, assign it to a variable as JSON, and then operate on it from that point. So using my previous short-hand experience with JQuery, I started constructing a similar type of format to be used. *********** JQuery *************** // One line and your done, pretty much var cntrls = $('[id]') // Later on, you simply access the element from the variable var val = cntrls['someID'].value *********** JavaScript *********** // Not so one-liner; put in the DOM.Ready event for JS var cntrlIDs = {} var root = document.getElementById('rootID').querySelectorAll('*'); for (i = 0, n = root.length; i < n; ++i) { var el = root[i]; if (el.id) { cntrlIDs[el.id] = el; } } // Later
Read more