Save Stored Procedure Template

Question

Save Stored Procedure Template

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

cantor Say Hey Kid Points: 667 More actions · Answer 1

I use Ctrl_Alt_T to bring up the template explorer in SQLS 2005 Query Analyzer and can add and modify my templates from there. Is this what you are after ?

Anthony Lukindo SSC-Addicted Points: 407 More actions · Answer 2

Hi:

Thanks, yes I later found those templates but when I change the template for the:

. . . . Create Stored Procedure (New Menu)

I still get the same old stored procedure template when I go and try to create a new stored procedure.

Basically, I want to create my own template for a new stored procedure that I will always see when I try to create a new stored procedure from any database.

Thanks for any further help that you can provide

Anthony

cantor Say Hey Kid Points: 667 More actions · Answer 3

I don't think that this is possible as SQLS seems to store these templates internally somewhere (anyone know where?). I guess the alternative is to create a new template folder, add a single template under this folder and then use the standard drag and drop from the explorer. This is a non-issue when you create sps using VS .NET installed templates as you can modify the default behaviour.

Anthony Lukindo SSC-Addicted Points: 407 More actions · Answer 4

Thanks for further input:

I have used SQL Server 2000 for years now and I really like the feature where there is a button at the bottom of the stored procedure editor which says: "Save as Template"

After this button is clicked, all new SPs will start out with the template that you just saved.

Anthony