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

Creator Studio - Facebook page management application
aimed at marketers and social content creators, creator studio is a free business and productivity tool from meta platforms, inc. allows you to create and edit posts, track page metrics, etc.
Instructions for setting up and managing FTP Server on Windows 10
if you want to create a private cloud for sharing and converting large files without restrictions, you can create an ftp server (file transfer protocol server) on your windows 10 computer.
Manage mailboxes in Exchange Server 2007
in this article, we will approach the management of mailboxes in exchange server 2007. this seems to be a simple discussion but we will look at some advanced points related to management tasks. users to support those
Manage Exchange Server 2007 using Windows XP workstation
some administrators don't like to use terminal services sessions to manage their exchange server environment. in this article, we will show you how to install the exchange management tools on a workstation running win
Enable Hyper-V Manager mode in Windows 8
as we know, the 'birth' of windows 8 has led to a lot of changes in how people manage and work. technically, windows 8 has built-in functionality to manage microsoft virtualization and hypervisor for experienced users, so they won't need to switch to windows 8 server to use hyper-v. client
Manage servers and databases with detailed utilities in SQL Operations Studio (preview)
detailed utilities retrieve the transact-sql (t-sql) queries you use to monitor servers and databases, then turn them into visual images.
Visual Studio 2010 SP1 enhances developer support
microsoft launched a local help viewer for visual studio 2010, integrating project server with team foundation server to help development teams work more effectively.
Remote computer management in Windows Server 2008 R2
unlike windows server 2008 rtm, windows server 2008 r2 has a feature that allows you to manage remote computers using server manager.
Basic Knowledge Management Principles Everyone Should Know
how do you make sense of the flow of information you encounter on a daily basis as a knowledge worker or lifelong learner? the answer lies in personal knowledge management (pkm).
7 great ideas using Raspberry Pi as a server
raspberry pi is a great solution for many computer projects, from learning programming to remote control a car to building a basic stop-motion animation studio. but do you know that raspberry pi can also be used as a server? here are some ideas for using raspberry pi as a server.