Microsoft SQL Server Management Studio (SSMS) definition

Contributor(s): Jessica Sirkin

SQL Server Management Studio (SSMS) is an integrated environment for managing a SQL Server infrastructure. 

SSMS provides a user interface that interacts with SQL Server. Microsoft first released the product alongside SQL Server 2005, and it has continued to be a part of management for Microsoft SQL Server 2008 and Microsoft SQL Server 2012.

SSMS provides tools to configure, manage and administer instances of Microsoft SQL Server, bringing together a range of graphical and visual design tools and script editors that simplify working with SQL Server. In addition to simplifying SQL Server tasks, SSMS maintains a single, integrated environment for SQL Server Database Engine management and authoring.

Microsoft SQL Server Management Studio's features include Object Explorer, which can view and manage all objects in a SQL Server instance; Template Explorer, which builds and manages files of boilerplate text that can be reused to speed up query and script development; and Solution Explorer, which builds the projects used to manage administration items, such as queries and scripts.

This was first published in May 2014

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close