MSSQL Server Management Studio (SSMS) 2005 New Query Template

Question

How do I change a default "New Query" template in SSMS 2005?

Answer 1

Posted this question as a reference, I did some googling, and found a simple way of doing it.

All you need to do is to edit SQLFile.sql located here: <%= your SQL install dir %>\90\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql

Also, Ctrl+Alt+T will show you all the other templates in SSMS; and check out Free SQL Server tools while you're at it.