SQL Server 2014 Tutorial – Personalize SQL Management Studio

Published on April 8, 2016 by abundantcode

Filed under SQL Server

Last modified April 8, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2 (1 votes)

This article have been viewed 1835 times

Problem Statement

You need to personalize SQL Server Management Studio.


There are various personalization options available for the SQL Server users in the SQL Management Studio.

For example, if you want the Object explorer to be place on a different position instead of showing it in the left side of the SSMS, you can just move it by clicking it on the title bar of Object explorer.

Additionally, you can change the Font styles and colors within the SQL Management Studio.

1. In the SQL Management studio 2014, navigate to Tools -> Options.


2. Select "Fonts and Colors" in the Options dialog box. Select a different Font from the "Font" combo box and change the size of the font and click ok.


3. Open “New Query” window by clicking on the “New Query” button which is found just above the object explorer.

4. Enter the below query in the “New Query” window and click the execute button

SELECT ‘abundantcode’

5. You will see that the new font style that you applied is the one that is used for the Query Window. The bottom of the “New Query” window shows the status of the query execution along with other details like server name, database name, user name etc.


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

1 Comment

  1. SQL Server 2014 Tutorial – List all the databases in SQL Server using Query | Abundant Code
    April 8, 2016 - 10:50 pm

Leave a Comment


You might be Interested in these Posts

How to get the Number of Elements in an Array in C# ?

You can use the Length property of the array to return the number of elements in it. Note that once ...

How to get the Machine Name from a .NET Application using C# ?

You can use the MachineName property defined in the System.Environment class in order to get the Mac...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...