SSMS Tips and Tricks

Productivity Driven Development

Change the Default Text in the New Query Window

| Comments

Do you always like to insert some default text in a new query (like author comments, or transactions). You can change the file at C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\SQLFile.sql to do this.

For example, if I put the following text in there:

Author: <Author, SYSNAME, Author_Name`>
Last Edited: <LastEdited, SYSNAME, LastEdited>

Then I get the below on opening a new query window:

If I press Ctrl + Shift + M, I can insert values for the parameters:

You can also change the default text for triggers, stored procedures and so on if you look at files inside different sub-folders in that folder.

Use SqlSmash to write maintainable SQL scripts, understand code faster and navigate around easily in SSMS.