I have found the SQL Server 2005 templates to be extremely useful. I have created custom templates for creating a new stored procedure, scalar functions, table-value functions and views. The benefit of these is that it creates a standard for creating