Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 template folder in Windows 7?

Author  Topic 

pug2694328
Posting Yak Master

166 Posts

Posted - 2009-10-11 : 15:51:57
In xp, using sql server 2005, I remember being able to go put files in this folder and them being available in the templates control:
C:\Documents and Settings\userid\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates\Sql
I've upgraded to sql server 2008 and Windows 7 and would like to put my custom templates in, but can't find where they are being stored now. I created a custom template called 'findme' but searching my entire computer couldn't find where it was saved. Is 2008 saving templates in a different way?

Thanks in advance for any help you can give. I'd prefer not to have to recreate my custom templates manually.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-13 : 06:23:36
Here's where I found the templates in my SQL 2008:
C:\Users\<user>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql

Go to Top of Page

pug2694328
Posting Yak Master

166 Posts

Posted - 2009-10-16 : 22:31:55
Bingo, thanks! Same spot on my computer.
Go to Top of Page
   

- Advertisement -