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 these SQL objects.  In my templates I have also included hooks to source ...