WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
Changing Settings in SQL Server Management Studio
Part one of a two-part series of blogs

If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.

  1. Configuring SQL Server Management Studio (this blog)
  2. Useful Settings in SQL Server Management Studio

You can find many more articles like this in our complete SQL tutorial.  We're also happy to provide training in person on one of our SQL courses!

Posted by Andrew Gould on 16 February 2012

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Configuring SQL Server Management Studio

Before you start writing SQL queries it's worth spending a little time setting up the SQL Server Management Studio environment to make query-writing as simple as possible.

Opening Management Studio

In order to change the settings in Management Studio, you first have to open it!  The screenshot below shows how to do this for a default installation of SQL Server 2008 R2.

Opening Management Studio

The option for Management Studio will be in a folder similar to this one in the Start menu.


Connecting to a Server

When you first open Management Studio you'll be asked which server you'd like to connect to.  You don't have to pick one at this stage, but it makes sense to do so.

Connecting to a server

Choose which server you want to connect to and click Connect. You may have to provide a login and password depending on how the server has been configured.

You don't need to be connected to a server in order to make changes to the settings in Management Studio, but the effects of some changes are easier to see if you are.

At this point you should be looking at the SQL Server Management Studio environment.

Management Studio

This is what your screen should resemble.  The Object Explorer window on the left shows you all of the objects stored on the server you chose to connect to.

If you chose not to connect to a server when opening Management Studio you can do so now, as shown in the diagram below:

Connecting to a server

Click the Connect button and choose Database Engine... from the list.  This will open the dialog box that appears when you first open Management Studio.


The Options Dialog Box

To change most settings in Management Studio you need to use the Options dialog box.  To display it, from the menu choose: Tools -> Options...


The first page you see when opening the Options dialog box.

Now that you've got access to the Options dialog box you can start making changes to some of the settings.  The next page of this blog lists a few of the most useful things that you can change in SQL Server Management Studio.

  1. Configuring SQL Server Management Studio (this blog)
  2. Useful Settings in SQL Server Management Studio
This blog has 0 threads Add post