• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1925
  • Last Modified:

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.
0
normanpaterson
Asked:
normanpaterson
1 Solution
 
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
 
Computer101Commented:
PAQed with points refunded (20)

Computer101
EE Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now