<div>
right click from what place? what is your goal?<br />
<br />
check <br />
<a href="http://msdn2.microsoft.com/en-us/library/ms179334.aspx" rel="ugc">http://msdn2.microsoft.com/en-us/library/ms179334.aspx</a>
</div>


right click from what place? what is your goal?

check
http://msdn2.microsoft.com/en-us/library/ms179334.aspx [http://msdn2.microsoft.com/en-us/library/ms179334.aspx]

<div>
That only shows how to create a template, not overwrite the built in templates used in the right click menu. &nbsp;By right click, I meant when you right click on Stored Procedures in the Server explorer and select New Stored Procedure
</div>


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

<div>
<div class="content wysiwyg-content">
I was beating my head trying to figure out how to change the right click menu option &quot;Create New Stored Procedure&quot; - I created a new template in the template explorer, but the right click menu wouldn't use it. &nbsp;The solutions is to save your new template in the following location:<br />
<br />
F:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShe<wbr />ll\Common7<wbr />\IDE\sqlwo<wbr />rkbenchpro<wbr />jectitems\<wbr />Sql\Stored<wbr /> Procedure\Create Stored Procedure (New Menu).sql<br />
<br />
Where &quot;F&quot; is the drive you installed SQL Server 2005 to.
</div>
</div>


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.

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.