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 3231 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

C Program to find the factorial of a number using Recursive function

Problem Write a program in C to find the factorial of a number using recursion and display the resu...

C Program to find the Sum of natural numbers

Problem Write a program in C to find the sum of natural numbers using recursive function. How to f...

C Program to display inverted full pyramid using *

Problem Write a program in C to print inverted full pyramid using * as shown below.The program shou...