How to create item templates for SQL files, for Visual Studio Database Projects

Question

It's possible to define your own custom templates for normal project types, such as templates for C# files, for a Class Library project.

What about a 'Database Project' scenario?

I would like to define a standard template for adding a stored procedure, which uses the company's conventions for all stored procedures, such as standard comments at the top.

---

After looking through an MSDN article on the topic, it seems as though the Database Project isn't supported:

Figure 5 TemplateData Elements for an Item

ProjectType | Indicates the type of project that this item can be added to. Possible values include CSharp, VisualBasic, VisualC, JSharp, and Web.

Answer 1

Please see: Create Reusable Project And Item Templates For Your Development Team

VS Ref: Visual Studio Templates

Answer 2

you can created customized project item templates for the database project , we do it all the time

the item must be placed in the following folder:

C:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\Templates\Database Project Items

and then you can select it