SQL Server Management Studio

<h1>SQL Server Management Studio</h1> <p>SQL Server Management Studio is an integrated environment for managing your SQL Server infrastructure and Azure SQL Database. Management Studio provides tools to configure, monitor, and administer instances of SQL Server. It also provides tools to deploy, monitor, and upgrade the data-tier components, such as databases and data warehouses used by your applications, and to build queries and scripts.</p> <div class="div-center"> <a class="button" href="/ssms/ssms-addins">36 SSMS Addins</a> <a class="button" href="/ssms/ssms-shortcuts">SSMS Shortcuts</a> <a class="button" href="/ssms/ssms-tips">SSMS Tips</a> <a class="button" href="/ssms/ssms-shortcuts">SSMS Shortcuts</a> </div> <h3>Useful Resources</h3> <ul> <li><a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Download SQL Server Management Studio (SSMS)</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server Management Studio - Changelog (SSMS)</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms-release-candidate" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server Management Studio (SSMS) - Release Candidate</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/ssms/previous-sql-server-management-studio-releases" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Previous SQL Server Management Studio Releases</a></li> <li><a href="http://blogs.sqlsentry.com/team-posts/latest-builds-management-studio/" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQLSentry Latest Builds of Management Studio</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/ssdt/sql-server-tools" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server Tools</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server Management Studio (SSMS)</a></li> <li><a href="https://www.microsoft.com/en-us/download/search.aspx?q=sql%20server%20management%20studio&p=0&r=10&t=&s=Relevancy~Descending" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Microsoft Download Center SSMS</a></li> <li><a href="https://docs.microsoft.com/en-us/sql/relational-databases/scripting/add-transact-sql-snippets" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Add Transact-SQL Snippets</a></li> </ul> <h2>Supported SQL Server versions</h2> <p>This version of SSMS works with all supported versions of SQL Server (SQL Server 2008 - SQL Server 2017), and provides the greatest level of support for working with the latest cloud features in Azure SQL Database, and Azure SQL Data Warehouse. There is no explicit block for SQL Server 2000 or SQL Server 2005, but some features may not work properly. Additionally, SSMS 17.x can be installed side-by-side with SSMS 16.X or SQL Server 2014 SSMS and earlier.</p> <h2>Supported Operating systems</h2> <p>This release of <strong>SSMS 17.x Version</strong> supports the following platforms when used with the latest available service pack: Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2016, Windows Server 2012 (64-bit), Windows Server 2012 R2 (64-bit), Windows Server 2008 R2 (64-bit)</p> <p>SSMS 18.x is not supported on Windows 8. Windows 10 / Windows Server 2016 requires version 1607 (10.0.14393) or later: Due to the new dependency on NetFx 4.7.2, SSMS 18.0 does not install on Windows 8, older versions of Windows 10, and Windows Server 2016. SSMS setup will block on those operating systems. Windows 8.1 is still supported.</p> <h3>SSMS Version Notes</h3> <p>SSMS 17.X is based on the Visual Studio 2015 Isolated shell, which was released before Windows Server 2016. Microsoft takes app compatibility very seriously and ensures that already-shipped applications continue to run on the latest Windows releases. Because of this, we do not anticipate that SSMS with all latest updates applied) will encounter issues when running on Windows Server 2016. Customers are advised to contact support, should they encounter any issues with SSMS on Windows Server 2016. Support will then work with customers to determine if the issue is with SSMS or Visual Studio or with Windows compatibility, and route the issue appropriately.</p> <p>SSMS 18.x is based on the new Visual Studio 2017 Isolated Shell: The new shell unlocks all the accessibility fixes that went in to both SSMS and Visual Studio.</p> <h2>Available Languages</h2> <p><strong>SQL Server Management Studio 18.9.2 GA</strong>: <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x804" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Chinese (People's Republic of China)</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x404" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Chinese (Taiwan)</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x409" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">English (United States)</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x40c" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">French</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x407" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">German</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x410" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Italian</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x411" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Japanese</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x412" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Korean</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x416" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Portuguese (Brazil)</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x419" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Russian</a> | <a href="https://go.microsoft.com/fwlink/?linkid=2168063&clcid=0x40a" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">Spanish</a></p> <h2>SQL Server Management Studio Download Links and Release Info</h2> <ul> <li><strong>GA</strong> - General Availability</li> <li><strong>PP</strong> - Public Preview</li> <li>Size in Megabytes for English version</li> </ul> <table> <thead> <tr> <th>Version/Download Link</th> <th>Info</th> <th>Build</th> <th>Release Date</th> <th style="text-align: right;">Size, Mb</th> </tr> </thead> <tbody> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2168063" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.9.2 GA Release</a></td> <td><strong>Latest GA</strong></td> <td>15.0.18386.0</td> <td>2021-07-15</td> <td style="text-align: right;">642</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2161193" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.9.1 GA Release</a></td> <td></td> <td>15.0.18384.0</td> <td>2021-04-20</td> <td style="text-align: right;">635</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2160964" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.9 GA Release</a></td> <td></td> <td>15.0.18382.0</td> <td>2021-04-15</td> <td style="text-align: right;">635</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2151644" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.8 GA Release</a></td> <td></td> <td>15.0.18369.0</td> <td>2020-12-17</td> <td style="text-align: right;">640</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2147207" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.7.1 GA Release</a></td> <td></td> <td>15.0.18358.0</td> <td>2020-10-27</td> <td style="text-align: right;">635</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2146265" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.7 GA Release</a></td> <td></td> <td>15.0.18357.0</td> <td>2020-10-20</td> <td style="text-align: right;">635</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2135491" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.6 GA Release</a></td> <td></td> <td>15.0.18338.0</td> <td>2020-07-22</td> <td style="text-align: right;">534</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2132606" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.5.1 GA Release</a></td> <td></td> <td>15.0.18333.0</td> <td>2020-06-09</td> <td style="text-align: right;">535</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2125901" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.5 GA Release</a></td> <td></td> <td>15.0.18183.0</td> <td>2020-04-07</td> <td style="text-align: right;">535</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2108895" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.4 GA Release</a></td> <td></td> <td>15.0.18206.0</td> <td>2019-11-04</td> <td style="text-align: right;">539</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2105412" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.3.1 GA Release</a></td> <td></td> <td>15.0.18183.0</td> <td>2019-10-02</td> <td style="text-align: right;">534</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2104251" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.3 GA Release</a></td> <td></td> <td>15.0.18178.0</td> <td>2019-09-23</td> <td style="text-align: right;">534</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2099720" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.2 GA Release</a></td> <td></td> <td>15.0.18142.0</td> <td>2019-07-25</td> <td style="text-align: right;">528</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2094583" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.1 GA Release</a></td> <td></td> <td>15.0.18131.0</td> <td>2019-06-11</td> <td style="text-align: right;">527</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2088649" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 GA Release</a></td> <td></td> <td>15.0.18118.0</td> <td>2019-04-24</td> <td style="text-align: right;">524</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2085742" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 RC1 Release</a></td> <td></td> <td>15.0.18098.0</td> <td>2019-03-28</td> <td style="text-align: right;">484</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2078638" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 Preview 7 Release</a></td> <td></td> <td>15.0.18092.0</td> <td>2019-03-01</td> <td style="text-align: right;">478</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2052501" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 Preview 6 Release</a></td> <td></td> <td>15.0.18075.0</td> <td>2018-12-18</td> <td style="text-align: right;">457</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2041155" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 Preview 5 Release</a></td> <td></td> <td>15.0.18068.0</td> <td>2018-11-15</td> <td style="text-align: right;">457</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2014662" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">18.0 Preview 4 Release</a></td> <td></td> <td>15.0.18040.0</td> <td>2018-09-24</td> <td style="text-align: right;">456</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2043154" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.9.1 Release</a></td> <td><strong>Latest 17</strong></td> <td>14.0.17289.0</td> <td>2018-11-21</td> <td style="text-align: right;">807</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=2014306" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.9 Release</a></td> <td></td> <td>14.0.17285.0</td> <td>2018-09-04</td> <td style="text-align: right;">807</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=875802" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.8.1 Release</a></td> <td></td> <td>14.0.17277.0</td> <td>2018-06-26</td> <td style="text-align: right;">806</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=875673" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.8 Release</a></td> <td><strong>Deprecated</strong></td> <td>14.0.17276.0</td> <td>2018-06-21</td> <td style="text-align: right;">806</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=873126" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.7 Release</a></td> <td></td> <td>14.0.17254.0</td> <td>2018-05-09</td> <td style="text-align: right;">803</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=870039" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.6 Release</a></td> <td></td> <td>14.0.17230.0</td> <td>2018-03-20</td> <td style="text-align: right;">802</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=867670" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.5 Release</a></td> <td></td> <td>14.0.17224.0</td> <td>2018-02-15</td> <td style="text-align: right;">802</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=864329" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.4 Release</a></td> <td></td> <td>14.0.17213.0</td> <td>2017-12-07</td> <td style="text-align: right;">802</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=858904" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.3 Release</a></td> <td></td> <td>14.0.17199.0</td> <td>2017-10-09</td> <td style="text-align: right;">801</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=854085" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.2 Release</a></td> <td></td> <td>14.0.17177.0</td> <td>2017-08-07</td> <td style="text-align: right;">819</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=849819" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.1 Release</a></td> <td></td> <td>14.0.17119.0</td> <td>2017-05-24</td> <td style="text-align: right;">784</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=847722" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.0 Release</a></td> <td></td> <td>14.0.17099.0</td> <td>2017-04-25</td> <td style="text-align: right;">729</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=844503" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.0 RC3 Release</a></td> <td></td> <td>14.0.17028.0</td> <td>2017-03-09</td> <td style="text-align: right;">677</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=840957" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.0 RC2 Release</a></td> <td></td> <td>14.0.16150.0</td> <td>2017-02-01</td> <td style="text-align: right;">682</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?LinkID=835608" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">17.0 RC1 Release</a></td> <td></td> <td>14.0.16000.64</td> <td>2016-11-16</td> <td style="text-align: right;">687</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?LinkID=840946" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">16.5.3 Release</a></td> <td><strong>Latest 16</strong></td> <td>13.0.16106.4</td> <td>2017-01-26</td> <td style="text-align: right;">898</td> </tr> <tr> <td>16.5.2 Release</td> <td><strong>Deprecated</strong></td> <td>13.0.16105.4</td> <td>2017-01-18</td> <td style="text-align: right;">898</td> </tr> <tr> <td><a href="https://go.microsoft.com/fwlink/?linkid=837453" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">16.5.1 Release</a></td> <td></td> <td>13.0.16100.1</td> <td>2016-12-05</td> <td style="text-align: right;">894</td> </tr> <tr> <td><a href="http://go.microsoft.com/fwlink/?linkid=832812" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">16.5 Release</a></td> <td></td> <td>13.0.16000.28</td> <td>2016-10-26</td> <td style="text-align: right;">894</td> </tr> <tr> <td><a href="http://go.microsoft.com/fwlink/?LinkID=828615" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">16.4.1 Release</a></td> <td></td> <td>13.0.15900.1</td> <td>2016-09-23</td> <td style="text-align: right;">894</td> </tr> <tr> <td>16.4 Release</td> <td><strong>Deprecated</strong></td> <td>13.0.15800.18</td> <td>2016-09-20</td> <td style="text-align: right;"></td> </tr> <tr> <td><a href="http://go.microsoft.com/fwlink/?LinkID=824938" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">16.3 Release</a></td> <td></td> <td>13.0.15700.28</td> <td>2016-08-15</td> <td style="text-align: right;">806</td> </tr> <tr> <td><a href="http://go.microsoft.com/fwlink/?LinkID=822301" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">July 2016 Hotfix Update</a></td> <td></td> <td>13.0.15600.2</td> <td>2016-07-13</td> <td style="text-align: right;">825</td> </tr> <tr> <td>July 2016 Release</td> <td><strong>Deprecated</strong></td> <td>13.0.15500.91</td> <td>2016-07-01</td> <td style="text-align: right;"></td> </tr> <tr> <td><a href="http://go.microsoft.com/fwlink/?LinkID=799832" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">June 2016 Release</a></td> <td></td> <td>13.0.15000.23</td> <td>2016-06-01</td> <td style="text-align: right;">825</td> </tr> <tr> <td><a href="http://download.microsoft.com/download/1/5/6/156992E6-F7C7-4E55-833D-249BD2348138/ENU/x86/SQLManagementStudio_x86_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server 2014 SP1</a></td> <td></td> <td>12.0.4100.1</td> <td>2015-05-14</td> <td style="text-align: right;">815</td> </tr> <tr> <td><a href="http://download.microsoft.com/download/F/6/7/F673709C-D371-4A64-8BF9-C1DD73F60990/ENU/x86/SQLManagementStudio_x86_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server 2012 SP3</a></td> <td></td> <td>11.0.6020.0</td> <td>2015-11-21</td> <td style="text-align: right;">964</td> </tr> <tr> <td><a href="https://www.microsoft.com/en-us/download/details.aspx" id="30438" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Server 2008 R2</a></td> <td></td> <td>10.50.4000</td> <td>2012-07-02</td> <td style="text-align: right;">161</td> </tr> </tbody> </table> <h2>SQL Server 2014 RTM Management Studio download links</h2> <ul> <li><a href="http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/MgmtStudio 64BIT/SQLManagementStudio_x64_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x64</a></li> <li><a href="http://download.microsoft.com/download/E/A/E/EAE6F7FC-767A-4038-A954-49B8B05D04EB/MgmtStudio 32BIT/SQLManagementStudio_x86_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x86</a></li> </ul> <h2>SQL Server 2012 SP1 Management Studio download links</h2> <ul> <li><a href="http://download.microsoft.com/download/8/D/D/8DD7BDBA-CEF7-4D8E-8C16-D9F69527F909/ENU/x64/SQLManagementStudio_x64_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x64</a></li> <li><a href="http://download.microsoft.com/download/8/D/D/8DD7BDBA-CEF7-4D8E-8C16-D9F69527F909/ENU/x86/SQLManagementStudio_x86_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x86</a></li> </ul> <h2>SQL Server 2008 R2 Management Studio download links</h2> <ul> <li><a href="http://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLManagementStudio_x64_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x64</a></li> <li><a href="http://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLManagementStudio_x86_ENU.exe" target="_blank" rel="nofollow noopener noreferrer" class="external-link no-image">SQL Management Studio x86</a></li> </ul>