Templates for SQL Server Management Studio 2008 are stored in this folder on WIndows XP:
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql
On my new WIndows 7 machine, the location is:
C:\Users\[user]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql
Create sub-folders and SQL files there and they show up in the Template Explorer. Really useful…
/Emil