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

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.
LVL 2
normanpatersonAsked:
Who is Participating?
 
Computer101Commented:
PAQed with points refunded (20)

Computer101
EE Admin
0
 
Eugene ZCommented:
right click from what place? what is your goal?

check
http://msdn2.microsoft.com/en-us/library/ms179334.aspx
0
 
normanpatersonAuthor Commented:
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
0
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.

All Courses

From novice to tech pro — start learning today.