"SSMS" redirects here. For the type of mass spectrometer using spark ionization, see spark source mass spectrometer.
SQL Server Management Studio
Earlier version of Microsoft SQL Server Management Studio showing a query, the results of the query, and the Object Explorer pane while connected to a SQL Server database engine instance.
Developer(s)
Microsoft
Initial release
2005
Stable release
20.1[1]
/ April 9, 2024; 27 days ago (2024-04-09)
Operating system
Microsoft Windows
Available in
Chinese (Simplified), Chinese (Traditional), English (United States), French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish
Website
docs.microsoft.com/en-us/sql/ssms
Microsoft SQL Server Management Studio (SSMS) is a software application developed by Microsoft that is used for configuring, managing, and administering all components within Microsoft SQL Server. First launched with Microsoft SQL Server 2005, it is the successor to the Enterprise Manager in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.[2]
A central feature of SSMS is the Object Explorer, which allows the user to browse, select, and act upon any of the objects within the server.[3] It also shipped a separate Express edition that could be freely downloaded; however recent versions of SSMS are fully capable of connecting to and manage any SQL Server Express instance. Microsoft also incorporated backwards compatibility for older versions of SQL Server thus allowing a newer version of SSMS to connect to older versions of SQL Server instances. It also comes with Microsoft SQL Server Express 2012, or users can download it separately.
Starting from version 11, the application was based on the Visual Studio 2010 shell, using WPF for the user interface. Versions 18 and after are based on the Visual Studio 2017 Isolated Shell.[4]
In June 2015, Microsoft announced their intention to release future versions of SSMS independently of SQL Server database engine releases.[5]
^"Download SQL Server Management Studio (SSMS)". 2024-04-09. Retrieved 2024-04-09.
^"What is SQL Server Management Studio (SSMS)?". microsoft.com. 2022-01-28. Retrieved 2022-07-14.
^"Manage Objects by Using Object Explorer". microsoft.com. 2022-01-18. Retrieved 2022-07-14.
^"SSMS 18.0 (preview 4)". SQL Server Management Studio - Changelog (SSMS). Microsoft. 24 September 2018. Retrieved 22 October 2018.
^"Announcing SQL Server Management Studio – June 2015 Release". SQL Release Services Blog. Microsoft. 24 June 2015. Retrieved 7 September 2015.
and 28 Related for: SQL Server Management Studio information
Microsoft SQLServerManagementStudio (SSMS) is a software application developed by Microsoft that is used for configuring, managing, and administering...
Microsoft SQLServer Express is a version of Microsoft's SQLServer relational database management system that is free to download, distribute and use...
Microsoft SQLServer (Structured Query Language) is a proprietary relational database management system developed by Microsoft. As a database server, it is...
Microsoft SQLServer Compact (SQL CE) is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops...
The history of Microsoft SQLServer begins with the first Microsoft SQLServer database product – SQLServer v1.0, a 16-bit relational database for the...
Microsoft Azure SQL Database (formerly known as SQL Azure, SQLServer Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database...
SQLServerManagement Objects (SMO) are .NET objects introduced by Microsoft as of Microsoft SQLServer 2005, designed to allow for easy and simple programmatic...
Azure DevOps Server, formerly known as Team Foundation Server (TFS) and Visual Studio Team System (VSTS), is a Microsoft product that provides version...
Microsoft SQLServer Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by...
as SQLServer Embedded Edition) is a variant of SQLServer Express 2005–2014 that is included with Windows Server 2008 (SQL 2005), Windows Server 2008...
PostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛl/, POHST-gres kyoo el), also known as Postgres, is a free and open-source relational database management system (RDBMS)...
MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/) is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael...
Partners to Launch SQLServer 2005, Visual Studio 2005 and BizTalk Server 2006". Press Releases. Microsoft. November 7, 2005. "Visual Studio 2005 and .NET...
System 12 IBM System R MICRO Relational Database Management System Pick PRTV QBE IBM SQL/DS Sybase SQLServer OpenOffice.org Base HSQLDB StarBase Adabas D...
database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQLServer need ongoing management. As such...
SQL Database Studio is professional client for Microsoft SQLServer developed by Jan Prochazka in Czech Republic. SQL Database Studio (SDS) is used by...
MariaDB and MySQL provide ACID compliance through the default InnoDB storage engine. Note (3): "For other than InnoDB storage engines, MySQLServer parses and...
SharePoint Skype for Business Server Microsoft SQLServer Microsoft Desktop Engine Team Foundation Server Visual Studio Team Services Hyper-V List of...
Studio Express for Windows Phone (2010 only) Visual Basic Express has the following limitations: No IDE support for databases other than SQLServer Express...
SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to...
business management processes via Orchestrations. BizTalk integrates with other Microsoft products like Microsoft Dynamics CRM, Microsoft SQLServer, and...
such as Microsoft SQLServer and Oracle. However, Zen provides the option to set up a Zen Client Reporting Engine as a proxy server to reduce the load...
community websites. Redgate produces database management tools for Microsoft SQLServer, Oracle, MySQL and Microsoft Azure. It also produces advanced...
Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended...
database server the user is connected to. The column completion provides a list of columns for only tables referenced in the SQL statement. SQLServer Management...