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 ...

These templates are for creating stored procedures, functions, and views.  See the readme in the zip file for instructions on using them or go to http://sqladvice.com/blogs/gstark/ for more details.