Connecting to a Database in SQL Server Management Studio

Published on August 14, 2016 by abundantcode

Filed under SQL Server

Last modified August 14, 2016

Print this page

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

This article have been viewed 394 times

Most of the time you will be connecting to your database when working in SQL Server Management Studio. You want to know how to connect to a particular database in SQL Management Studio when working with SQL Server 2014 and executing a query. For example , you want to connect to the AdventureWorks2014 database.

How to connect to a database in SQL Management Studio in SQL Server ?

By default , you are connected to the master database when you launch the Microsoft SQL Server Management Studio. You might want to switch to your database. In this example (AdventureWorks2014).

There are multiple options for you to connect to a database in SQL Management Studio.

1. Select the database from the available databases dropdown list in the toolbar.


2. use the "USE" command and mention your database name when running the query. In this case , the database name is "AdventureWorks2014" and hence the query looks something like this.

USE  AdventureWorks2014
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.

Leave a Comment


You might be Interested in these Posts

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...

How to change positive numbers to negative in Microsoft Excel 2016 ?

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) ,...

How to convert number to text in Excel?

In Microsoft Excel 2016 , there are times when you don't want the numbers present in the cell to be ...