Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
Untangle TempDB Performance with SQL Diagnostic Manager - Free Webinar
 

Automatic Updates for SQL Server Management Studio


By:   |   Last Updated: 2015-09-24   |   Comments (3)   |   Related Tips: More > SQL Server 2016

Problem

SQL Server Management Studio for SQL Server 2016 automatically checks for updates. But how does it work? Do the updates run without you noticing it or do you get the chance to choose whether to apply the update or not? Keep reading to learn more.

Solution

Every new version of SQL Server comes with a new version of SQL Server Management Studio that adds support for the new features. Although all releases of SQL Server have periodical updates that fix some issues during the software lifecycle in the form of Hotfixes, Cumulative Updates or Service Packs, those updates did not always cover SQL Server Management Studio.

If you think about it, there is something special with SQL Server Management Studio that made it difficult to provision the updates. SQL Server Management Studio is built on Visual Studio and has its own components like the SQL Server Native Client, ODBC drivers and has dependencies other than the SQL Server Engine. Fortunately for the SQL Server Community, Microsoft has made SQL Server Management Studio a product on its own and is providing updates directly for the product.

Anytime you start SQL Server Management Studio it automatically checks for updates, and when an update is available you will receive a notification like the one in the next image.

Notification of New Update.

When you click the notification you will be redirected to a web page where you can download the new version of the web installer and proceed to upgrade the application. But there is something to note; updates are not applied automatically, and you have the option to download the installer and go through the update process or wait for a newer version.

If you decide to apply the update and click the notification, your default web browser will open a web page (https://msdn.microsoft.com/library/mt238290.aspx) where you can download the new version of the web installer.

You Can Download the New Version of the Web Installer Here.

Manually Checking For Updates

Also if you are impatient, SQL Server Management Studio allows you to manually check for updates by selecting the “Check for Updates…” option from the Tools menu.

New Check For Updates Option.

When you click on that option a window will pop up displaying the current version of SQL Server Management Studio components and the latest version available. If there is an update you will see an “Update” button that will redirect you to the SQL Server Management Studio Download Page.

New Check For Updates Option.

What is upgraded?

The list below shows eight components of SQL Server Management Studio that can be upgraded:

  • Microsoft SQL Server 2016 T-SQL ScriptDom
  • Microsoft SQL Server 2016 T-SQL Compiler Service
  • Microsoft Report Viewer for SQL Server 2016
  • Microsoft System CLR Types for SQL Server 2016
  • Microsoft ODBC Driver 11 for SQL Server
  • Microsoft SQL Server Data-Tier Application Framework (x86)
  • Microsoft SQL Server 2012 Native Client
  • Microsoft Visual Studio 2010 Shell (Isolated)
Next Steps


Last Updated: 2015-09-24


next webcast button


next tip button



About the author
MSSQLTips author Daniel Farina Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Sunday, September 16, 2018 - 8:51:49 AM - Keith Back To Top

Is it possible to suppress auto update? There are platforms where IT does not allow updates to be applied. It would be very nice not to have the constant distraction of automatic update checking and notification.


Friday, March 31, 2017 - 3:23:37 AM - chaitanya Back To Top

How to suppress this auto update in SSMS. Is there any parameter or any files that could suppress this auto update. 

Thank you in advance


Tuesday, October 11, 2016 - 1:13:49 PM - Peter Back To Top

Any idea how I turn off this automatic checking, it's annoying.

pcd

 


Learn more about SQL Server tools