SQL Server Mgmt Studio Templates

March 6, 2010 by Chris · Leave a Comment 

Here’s a little feature that has been shown to me multiple times over the years. Every time I see it I get all excited by the possibilities — then (sadly) quickly forget it. This time I hope that by writing it down I’ll remember longer… Enjoy the pictures!

It turns out that SQL Server Management Studio has a nifty little option to speed up many, if not most, database tasks. Just find the Template Explorer under the View menu:
(note: my understanding is this is the same for 2005 and 2008 versions. The pictures below are from 2005)

Template Explorer

This opens a new panel on the right side of SSMS (by default). Tons of tasks are listed. For instance, suppose you want to create a new table. Drill down to it and then double-click.

Template Explorer

Read more

Tags: , , , ,

  • About

    Wandering the Internet, looking at all things bright and shiny. Playing with many, writing about some. More...

  • Referrals and Ads

    Mozy Logo for Referral

    Dropbox Logo for Referral

    Dreamhost Promotion
    Get $50 off at Dreamhost — Just mention SOLOTECH50 when signing up!

  • Topics

  • Flair and Sparklies