In SQL Server 2005 and newer, you have access to a list of pre-made templates, providing scripts to several database-related tasks. To access the provided templates, just go to SQL Server Management Studio (SSMS) and click on the View menu, then click on Template Explorer. A window will appear with scores of templates for you to select and use. The power comes from your ability to add your scripts to the provided templates, as well as edit the templates provided.
You can read more from Microsoft using the online documentation.