Microsoft SQL Server Management Studio (SSMS)

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

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


'Microsoft SQL Server Management Studio (SSMS)' is part of the:

View All Definitions

Dig deeper on Microsoft SQL Server Tools and Utilities



Enjoy the benefits of Pro+ membership, learn more and join.



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:

File Extensions and File Formats

Powered by: