The location of SQL Server 2008's template files

If you have used SQL Server 2008 Management Studio, you might have noticed the handy Template Explorer feature. This allows you to quickly run T-SQL scripts by starting from ready-written templates, where you can

In addition to the Template Explorer window, you can find the templates from a file system folder. For instance on a Windows Server 2003 system, the path would be:

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

This location is handy, if you want to share templates or write your own.