Save Stored Procedure Template

Question

Save Stored Procedure Template

Anthony Lukindo

SSC-Addicted

Points: 407
More actions
August 13, 2007 at 4:06 pm

#180304

Hi:
In MS SQL Server 2000 and below, I was able to save my own stored procedure template that would then come up each time I wanted to create a new one.
I have been unable to find this feature in MS SQL Server 2005. Can someone please point me to where it is or confirm if it has in fact been removed.
Thanks
Anthony

Viewing 5 posts - 1 through 4 (of 4 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