Importing Templates into Sql Server Management Studio

You can add templates to the template explorer by navigating to a directory and putting the files directly into a folder.

On Vista/Windows 7 the folder is:

C:\Users\user\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql

“user” should be replaced with your username and the 100 directory is for Sql Server Management Studio 2008 and you replace it with 90 for 2005!

On XP it is:

C:\Documents and Settings\user\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql

“user” should be replaced with your username and the 100 directory is for Sql Server Management Studio 2008 and you replace it with 90 for 2005!

You will have to restart management studio for the templates to come up. If you have 2005 and 2008 management studio and you use both then you will have to put the templates in the folder for each version also.

Advertisements

One Response to “Importing Templates into Sql Server Management Studio”

  1. Runing SQL 2008 Enterprise on Vista Business O/S for the First Time « CGoldwater's Blog Says:

    […] to be connected to the right spot.  Next job is to get all my 2005 templates into 2008 – JWWishart’s blog on that subject is […]


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: