?
Solved

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

Posted on 2006-11-08
5
Medium Priority
?
1,889 Views
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.
0
Comment
Question by:normanpaterson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 43

Expert Comment

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

check
http://msdn2.microsoft.com/en-us/library/ms179334.aspx
0
 
LVL 2

Author Comment

by:normanpaterson
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
0
 
LVL 1

Accepted Solution

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

Computer101
EE Admin
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

741 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