SQL Server Management Studio Tip: Get a Customized New Query Window

Posted: June 10, 2013 by Virendra Yaduvanshi in Database Administrator
Tags: , , , , ,

Here is a SSMS tips where we can customized our new query windows as,

For SQL Server 2008 (64 Bits)
1) Find the file SQLFile.SQL , which mostly located at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\SQLFILE.SQL
and modify the file as per your wish.

For SQL Server 2008 (32 Bits)
1) Find the file SQLFile.SQL , which mostly located at C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\SQLFILE.SQL
and modify the file as per your wish.

For SQL Server 2012 (64 Bits)
1) Find the file SQLFile.SQL , which mostly located at C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\SQLFile.sql
and modify the file as per your wish.

For SQL Server 2012 (32 Bits)
1) Find the file SQLFile.SQL , which mostly located at C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql\SQLFile.sql
and modify the file as per your wish.

Let See my Modified SQLFILE.SQL file as

Source : Mr. Amit Bansal’s Blog


Advertisements
Comments
  1. Tuan says:

    Does this work in SQL Express 2012? I don’t see the SqlWorkbenchProjectItems folder, and if I create it and the Sql folder, it still doesn’t work.

    Like

  2. Tuan says:

    Never mind, I found it. It’s in the Program FIles(x86) folder, even though I’m pretty sure I have the 64-bit version installed.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s