560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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.
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.
The option for Management Studio will be in a folder similar to this one in the Start menu.
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.
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.
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:
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.
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.
|Parts of this blog|
25 Aytoun Street