{"id":1114,"date":"2016-10-31T14:34:32","date_gmt":"2016-10-31T21:34:32","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=1114"},"modified":"2017-04-13T12:29:14","modified_gmt":"2017-04-13T19:29:14","slug":"sql-server-management-studio-changes-and-servicing","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/","title":{"rendered":"SQL Server Management Studio Changes and Servicing"},"content":{"rendered":"

For the SQL Server 2016 release cycle, Microsoft has separated SQL Server Management Studio (SSMS) from the rest of the SQL Server 2016 product. This new standalone version of SSMS (which is completely free<\/a>) is designed to work with SQL Server 2008 through SQL Server 2016. It may also work with SQL Server 2000 and SQL Server 2005, although Microsoft does not officially support that scenario. Finally, it is designed to work with Azure SQL Database<\/a>.<\/font><\/p>\n

The setup program for SSMS is not included with the rest of product on the SQL Server 2016 DVD or .iso file. <\/font>Instead, there is a link that takes you to the Download SQL Server Management Studio (SSMS) page<\/a> where you can download the most current version of the SSMS setup program. <\/font><\/p>\n

If you are trying to install SSMS on a machine that does not have internet access (which is pretty common), then you will need to download the SSMS setup program in advance, and make it available on the server where you want to install it. The SSMS setup program is typically about 800-900MB in size, so this should not be a huge burden for most people.<\/font><\/p>\n

If you have internet access on a machine where SSMS is installed, it will periodically check for a newer version and will notify you that there is one via a \u201ctoast\u201d popup in your system tray. You can also go to the Tools menu in SSMS, and select \u201cCheck for Updates\u2026\u201d to force SSMS to check for any updated components that may be available. The latest SSMS release notes are available from the link below:<\/font><\/p>\n

<\/font> <\/p>\n

\n

SQL Server Management Studio – Release Notes<\/a><\/font><\/p>\n

<\/font> <\/p>\n<\/blockquote>\n

Microsoft has been pretty reliable about releasing new versions of SSMS every month, which often have many bug fixes and feature improvements. <\/font>Figure 1 shows an example dialog with details about components that have available updates.<\/font><\/p>\n

<\/font> <\/p>\n

\"image\"<\/a><\/p>\n

Figure 1: SSMS Updates are Available Example<\/strong><\/font><\/p>\n

<\/font> <\/p>\n

Figure 2 shows an example dialog where SSMS is up to date.<\/font><\/p>\n

<\/font> <\/p>\n

\"image\"<\/a><\/p>\n

Figure 2: SSMS Is Up to Date Example<\/strong><\/font><\/p>\n

<\/font> <\/p>\n

If the machine where SSMS is installed does not have internet connectivity, you will have to be a little more proactive about checking for new versions of SSMS. You can pull up the About dialog for SSMS, as shown in Figure 3, and compare the build number for Microsoft SQL Server Management Studio (in the top row) to the latest available build number shown in the changelog page in the link below, using some other machine that does have internet connectivity.<\/font><\/p>\n

\n

SQL Server Management Studio – Changelog (SSMS)<\/font><\/a><\/p>\n<\/blockquote>\n

<\/font> <\/p>\n

\"image\"<\/a><\/p>\n

Figure 3: About Microsoft SQL Server Management Studio Dialog<\/strong><\/font><\/p>\n

 <\/p>\n

The Microsoft SQL Server Release Services Blog<\/a> usually has a new post when a new version of SSMS is released. The latest post is here<\/a>.<\/font> <\/p>\n

<\/font>  <\/p>\n

You should also be able to use Windows Server Update Services<\/a> (WSUS) to check for and obtain SSMS updates, if your organization is using WSUS.<\/font> <\/p>\n

<\/font>  <\/p>\n

<\/font> <\/p>\n

<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

For the SQL Server 2016 release cycle, Microsoft has separated SQL Server Management Studio (SSMS) from the rest of the SQL Server 2016 product. This new standalone version of SSMS (which is completely free) is designed to work with SQL Server 2008 through SQL Server 2016. It may also work with SQL Server 2000 and […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[246,295],"tags":[296],"class_list":["post-1114","post","type-post","status-publish","format-standard","hentry","category-sql-server-2016","category-ssms","tag-ssms"],"yoast_head":"\nSQL Server Management Studio Changes and Servicing - Glenn Berry<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Management Studio Changes and Servicing - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"For the SQL Server 2016 release cycle, Microsoft has separated SQL Server Management Studio (SSMS) from the rest of the SQL Server 2016 product. This new standalone version of SSMS (which is completely free) is designed to work with SQL Server 2008 through SQL Server 2016. It may also work with SQL Server 2000 and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-31T21:34:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T19:29:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/\",\"name\":\"SQL Server Management Studio Changes and Servicing - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png\",\"datePublished\":\"2016-10-31T21:34:32+00:00\",\"dateModified\":\"2017-04-13T19:29:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png\",\"width\":644,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Management Studio Changes and Servicing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Management Studio Changes and Servicing - Glenn Berry","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Management Studio Changes and Servicing - Glenn Berry","og_description":"For the SQL Server 2016 release cycle, Microsoft has separated SQL Server Management Studio (SSMS) from the rest of the SQL Server 2016 product. This new standalone version of SSMS (which is completely free) is designed to work with SQL Server 2008 through SQL Server 2016. It may also work with SQL Server 2000 and […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/","og_site_name":"Glenn Berry","article_published_time":"2016-10-31T21:34:32+00:00","article_modified_time":"2017-04-13T19:29:14+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/","name":"SQL Server Management Studio Changes and Servicing - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png","datePublished":"2016-10-31T21:34:32+00:00","dateModified":"2017-04-13T19:29:14+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/2016\/10\/image_thumb.png","width":644,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/sql-server-management-studio-changes-and-servicing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"SQL Server Management Studio Changes and Servicing"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=1114"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/1114\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=1114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=1114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=1114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}