SQL Server 2014 Tutorial – Personalize SQL Management Studio

Published on April 8, 2016 by admin

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: 1.3 (16 votes)

This article have been viewed 18212 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.


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 swap two numbers without using temporary variable

Problem Write a program in Visual CSharp to swap two numbers using temporary variable and display t...

C# Program to swap two numbers

Problem Write a program in C# to swap two numbers using temporary variable and display the result i...

C# Program to print the sum of two numbers

Problem Write a program in C# to add two numbers and display the result in copnsole window. How to...