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.