How to change default right click CREATE NEW STORED PROCEDURE template in SQL Server 2005

Posted on 2006-11-08
Medium Priority
Last Modified: 2011-10-03
I was beating my head trying to figure out how to change the right click menu option "Create New Stored Procedure" - I created a new template in the template explorer, but the right click menu wouldn't use it.  The solutions is to save your new template in the following location:

F:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql\Stored Procedure\Create Stored Procedure (New Menu).sql

Where "F" is the drive you installed SQL Server 2005 to.
Question by:normanpaterson
LVL 43

Expert Comment

by:Eugene Z
ID: 17905634
right click from what place? what is your goal?


Author Comment

ID: 17910966
That only shows how to create a template, not overwrite the built in templates used in the right click menu.  By right click, I meant when you right click on Stored Procedures in the Server explorer and select New Stored Procedure

Accepted Solution

Computer101 earned 0 total points
ID: 18298276
PAQed with points refunded (20)

EE Admin

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question