SQL Server 2005 : Change templates for SP's, Functions, Tables Scripts etc

Following post tells how you can customize templates for SP's and Functions and other DB objects.

Following post written for SQL SERVER 2005, 32 bit Window7 Enterprise to be precise.

Following post tells how you can customize templates for SP's and Functions and other DB objects.

Following post written for SQL SERVER 2005, 32 bit Window7 Enterprise to be precise.

Customizing means :

Say, For Stored procedures default template in SQL SERVER 2005 is like below :

Default Create SP Template

Default Create SP Template

If you want to customize it as below :

Custom Sp Create Template

Follow Following Steps:

   §  Go To Path :

•  \C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql 
• You will find all the template for Creation, Deletion and Alteration of DB objects here. Open Folder “Stored Procedure” and open file “Create Stored Procedure (New Menu).sql”  in notepad as in Fig.“Default Create SP Template“.

• Make changes to this file as in Fig.” Custom Sp Create Template”
• Save the file, and open SQL Server Management Studio.

And done, you have got your new Customized Template, that will save your lot of time in changing comments or writing common stuff for each SP you create or Alter.