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.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.