Microsoft SQL Server Management Studio (SSMS or S.S.M.S.) is the integrated environment for managing your SQL Server infrastructure. SQL Server Management Studio presents a graphical interface for configuring, monitoring, and administering instances of SQL Server. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases. SQL Server Management Studio also provides Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Management Studio is a completely standalone product, not tied to any specific version or edition of SQL Server, and no longer requires licensing of any kind.
Quick Summary:
| Version | Build number | Release year | Download latest |
|---|---|---|---|
| SQL Server Management Studio 20 | 20.0.x.x | 2024 | Direct download 20.1 |
| SQL Server Management Studio 19 | 19.0.x.x | 2023 | Direct download 19.3 |
| SQL Server Management Studio 18 | 15.0.x.x | 2019 | Direct download 18.12.1 |
| SQL Server Management Studio 17 | 14.0.x.x | 2017 | Direct download 17.9.1 |
| SQL Server Management Studio 16 | 13.0.x.x | 2016 | Direct download 16.5.3 |
| Not standalone (integral part of SQL Server): | |||
| SQL Server Management Studio 2014 | 12.0.x.x | 2014 | Download 2014 |
| SQL Server Management Studio 2012 | 11.0.x.x | 2012 | Download 2012 |
| SQL Server Management Studio 2008 R2 | 10.50.x.x | 2010 | Download 2008 R2 |
| SQL Server Management Studio 2008 | 10.0.x.x | 2008 | Download 2008 |
| SQL Server Management Studio 2005 | 9.0.x.x | 2005 | |
SSMS 18 can be installed side-by-side with SSMS 17 / 16 or SQL Server 2014 SSMS and earlier.
Build numbers:
| Version | Build | Description | Release date |
|---|---|---|---|
| 20.1 | 20.1.10.0 | SQL Server Management Studio (SSMS) 20.1 Latest Direct download | *new |
| 20.0 | 20.0.70.0 | SQL Server Management Studio (SSMS) 20.0 | *new |
| 20.0 | 20.0.65.0 | SQL Server Management Studio (SSMS) 20.0 (Preview 1) Beta | |
| 19.3 | 19.3.4.0 | SQL Server Management Studio (SSMS) 19.3 | |
| 19.2 | 19.2.56.2 | SQL Server Management Studio (SSMS) 19.2 | |
| 19.1 | 19.1.56.0 | SQL Server Management Studio (SSMS) 19.1 | |
| 19.0.2 | 19.0.20209.0 | SQL Server Management Studio (SSMS) 19.0.2 | |
| 19.0.1 | 19.0.20200.0 | SQL Server Management Studio (SSMS) 19.0.1 | |
| 19.0 | 19.0.20196.0 | SQL Server Management Studio (SSMS) 19.0 | |
| 19.0 | 19.0.20179.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 4) Beta | |
| 19.0 | 16.0.19061.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 3) Beta | |
| 19.0 | 16.0.19056.0 | SQL Server Management Studio (SSMS) 19.0 (Preview 2) Beta | |
| 18.12.1 | 15.0.18424.0 | SQL Server Management Studio (SSMS) 18.12.1 | |
| 18.12 | 15.0.18420.0 | SQL Server Management Studio (SSMS) 18.12 | |
| 18.11.1 | 15.0.18410.0 | SQL Server Management Studio (SSMS) 18.11.1 | |
| 18.11 | 15.0.18404.0 | SQL Server Management Studio (SSMS) 18.11 | |
| 18.10 | 15.0.18390.0 | SQL Server Management Studio (SSMS) 18.10 | |
| 18.9.2 | 15.0.18386.0 | SQL Server Management Studio (SSMS) 18.9.2 | |
| 18.9.1 | 15.0.18384.0 | SQL Server Management Studio (SSMS) 18.9.1 | |
| 18.9 | 15.0.18382.0 | SQL Server Management Studio (SSMS) 18.9 | |
| 18.8 | 15.0.18369.0 | SQL Server Management Studio (SSMS) 18.8 | |
| 18.7.1 | 15.0.18358.0 | SQL Server Management Studio (SSMS) 18.7.1 | |
| 18.7 | 15.0.18357.0 | SQL Server Management Studio (SSMS) 18.7 | |
| 18.6 | 15.0.18338.0 | SQL Server Management Studio (SSMS) 18.6 | |
| 18.5.1 | 15.0.18333.0 | SQL Server Management Studio (SSMS) 18.5.1 | |
| 18.5 | 15.0.18330.0 | SQL Server Management Studio (SSMS) 18.5 | |
| 18.4 | 15.0.18206.0 | SQL Server Management Studio (SSMS) 18.4 | |
| 18.3.1 | 15.0.18183.0 | SQL Server Management Studio (SSMS) 18.3.1 | |
| 18.3 | 15.0.18178.0 | SQL Server Management Studio (SSMS) 18.3 Withdrawn | |
| 18.2 | 15.0.18142.0 | SQL Server Management Studio (SSMS) 18.2 | |
| 18.1 | 15.0.18131.0 | SQL Server Management Studio (SSMS) 18.1 | |
| 18.0 | 15.0.18118.0 | SQL Server Management Studio (SSMS) 18.0 | |
| 18.0 | 15.0.18116.0 | SQL Server Management Studio (SSMS) 18.0 Private Beta | |
| 18.0 | 15.0.18098.0 | SQL Server Management Studio (SSMS) 18.0 Release Candidate 1 (RC1) Beta | |
| 18.0 | 15.0.18092.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 7) Beta | |
| 18.0 | 15.0.18075.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 6) Beta | |
| 18.0 | 15.0.18068.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 5) Beta | |
| 18.0 | 15.0.18040.0 | SQL Server Management Studio (SSMS) 18.0 (Preview 4) Beta | |
| 17.9.1 | 14.0.17289.0 | SQL Server Management Studio (SSMS) 17.9.1 | |
| 17.9 | 14.0.17285.0 | SQL Server Management Studio (SSMS) 17.9 | |
| 17.8.1 | 14.0.17277.0 | SQL Server Management Studio (SSMS) 17.8.1 | |
| 17.8 | 14.0.17276.0 | SQL Server Management Studio (SSMS) 17.8 Withdrawn | |
| 17.7 | 14.0.17254.0 | SQL Server Management Studio (SSMS) 17.7 | |
| 17.6 | 14.0.17230.0 | SQL Server Management Studio (SSMS) 17.6 | |
| 17.5 | 14.0.17224.0 | SQL Server Management Studio (SSMS) 17.5 | |
| 17.4 | 14.0.17213.0 | SQL Server Management Studio (SSMS) 17.4 | |
| 17.3 | 14.0.17199.0 | SQL Server Management Studio (SSMS) 17.3 | |
| 17.2 | 14.0.17177.0 | SQL Server Management Studio (SSMS) 17.2 | |
| 17.1 | 14.0.17119.0 | SQL Server Management Studio (SSMS) 17.1 | |
| 17.0 | 14.0.17099.0 | SQL Server Management Studio (SSMS) 17.0 | |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 3 (RC3) | |
| 17.0 | 14.0.16140.0 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 2 (RC2) | |
| 17.0 | 14.0.16000.64 | SQL Server Management Studio (SSMS) 17.0 Release Candidate 1 (RC1) | |
| 16.5.3 | 13.0.16106.4 | SQL Server Management Studio (SSMS) 16.5.3 | |
| 16.5.2 | 13.0.16105.4 | SQL Server Management Studio (SSMS) 16.5.2 Withdrawn | |
| 16.5.1 | 13.0.16100.1 | SQL Server Management Studio (SSMS) 16.5.1 | |
| 16.5 | 13.0.16000.28 | SQL Server Management Studio (SSMS) 16.5 | |
| 16.4.1 | 13.0.15900.1 | SQL Server Management Studio (SSMS) 16.4.1 | |
| 16.4 | 13.0.15800.18 | SQL Server Management Studio (SSMS) 16.4 Withdrawn | |
| 16.3 | 13.0.15700.28 | SQL Server Management Studio (SSMS) 16.3 | |
| 13.0.15600.2 | SQL Server Management Studio (SSMS) July 2016 Hotfix Update | ||
| 13.0.15500.91 | SQL Server Management Studio (SSMS) July 2016 Withdrawn | ||
| 13.0.15000.23 | SQL Server Management Studio (SSMS) June 2016 | ||
| 13.0.14000.36 | SQL Server Management Studio (SSMS) April 2016 Preview | ||
| 13.0.13000.55 | SQL Server Management Studio (SSMS) March 2016 Preview Refresh | ||
| 13.0.12500.29 | SQL Server Management Studio (SSMS) March 2016 Preview Withdrawn | ||
| 13.0.12000.65 | SQL Server Management Studio (SSMS) February 2016 Preview | ||
| 13.0.11000.78 | SQL Server Management Studio (SSMS) January 2016 Preview | ||
| 13.0.900.73 | SQL Server Management Studio (SSMS) December 2015 Preview | ||
| 13.0.800.111 | SQL Server Management Studio (SSMS) November 2015 Preview | ||
| 13.0.700.242 | SQL Server Management Studio (SSMS) October 2015 Preview | ||
| 13.0.600.65 | SQL Server Management Studio (SSMS) September 2015 Preview | ||
| 13.0.500.53 | SQL Server Management Studio (SSMS) August 2015 Preview | ||
| 13.0.400.91 | SQL Server Management Studio (SSMS) July 2015 Preview | ||
| 13.0.300.44 | SQL Server Management Studio (SSMS) June 2015 Preview |
