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