Manage MS SQL Server with Management Studio

SQL Server Management Studio is a tool in SQL Server if you choose when installing. This tool helps to connect and manage SQL Server on a graphical interface instead of using the command line.

To connect to a remote SQL Server installation, you will also need this software or another similar software. Management Studio is often used by administrators, developers, testers .

These are common ways to open SQL Server Management Studio.

Method 1:

Open Start > All Programs > MS SQL Server 2012 > SQL Server Management Studio.

Method 2:

Open Run and type SQLWB (with 2005 edition) or SSMS (with version 2008 and later), then click Enter. SQL Server Management Studio will open as shown in the image below.

Manage MS SQL Server with Management Studio Picture 1
MS SQL Server Management Studio interface when opened

Previous article: Learn about MS SQL architecture

Next lesson: How to login database on MS SQL Server

Marvin Fry

Update 25 May 2019

You should read it

May be interested

Instructions for installing MS SQL Server
this is a step by step guide to installing ms sql server.
Learn about the architecture of MS SQL Server
in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.
MS SQL Server versions
sql server currently has many different versions. below is a list of versions with features of each version.
What is MS SQL Server?
this article will give you a general introduction to sql server, demonstrating the benefits and benefits of using sql server as well as existing versions.