• Very interesting approach. I never thought of using the templates. However from BOL

    "The first time the template explorer is opened, a copy of the templates is

    placed in the users Documents and Settings folder under Application

    Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates."

    i.e. "C:\Users\John\AppData\Roaming\Microsoft\Microsoft SQL

    Server\100\Tools\Shell\Templates\Sql"

    Since we have several DBAs in my area using templates would make it difficult to share. Instead We just set up a network share and organize all the scripts there under multiple folders. usually when I open a file SSMS returns to the same share.

    Francis