Whenever we launch SQL Server Management Studio, it will load “SQLFile.sql” from the operating system and shows the text in the New Query Window. The location of this file depends on the version of sql server and the bit of your local machine. Here is the location of SQLFile.sql on my 64 bit machine for SQL 2012: C:\ProgramFiles(x86)\Microsoft\SQLServer\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\SQLFile.sql
If you are running 32 bit operating system, then just remove the (x86) for 32-bit installations,so the location of SQLFile.sql should be: C:\ProgramFiles\MicrosoftSQLServer\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\SQLFile.sql
- Microsoft SQL Server 2014 120
- Microsoft SQL Server 2012 110
- Microsoft SQL Server 2008 R2 100
- Microsoft SQL Server 2008 100
After modifying, whenever you open new query windows, it would be as below.