Hi Friends,

Whenever I click on ‘New Query’ in SQL Server Management Studio, I get the New Query Window, but a customized one. See below:

1_SQL_Server_Management_Studio_Tip_Get_a_customized_New_Query_Window

 

You can see that “Copyright 2011 – Amit Bansal’ comes by default whenever I click on New Query. In a recent conference, one of the attendees observed this and asked me how can he customize the new query window. Well here is the trick:

Modify SQLFile.sql which is located in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql. And you are done. This path is for 64 bit installations. Just remove the (x86) for 32-bit installations. Or search for the file ;)

Edit the file in any editor (I use Notepad, my fav editor), put any default comment that you want to be there whenever you create a New Query. And you are done !

 

 

Like us on FaceBook | Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Amit Bansal
SQL MCM, SQL MVP
Director – eDominer Systems, Peopleware India, SQLMaestros

Follow me on Twitter | Follow me on FaceBook | Browse my blog posts on SQLMaestros
FB page | Connect on LinkedIn | Google+ | Know more about me

SQL Server - History of Business Intelligence (BI)
Change Collation setting for TemDB