Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Introduction

Welcome to release 17.9.1 of SQL Server Management Studio (SSMS)! Full documentation of this release, as well as previous releases, can be found here: SSMS Release documentation. General SSMS Documentation can be found here: SSMS documentation.

Applicability

This update, when applied through Windows Server Update Services (WSUS), is only applicable to previous versions of SSMS 17.X. This package will fully upgrade any previous 17.X version.

Summary

Bug Fixes

General SSMS

  • Fixed an issue in which users may experience their connection being closed and reopened with each query invocation when using "Active Directory – Universal with MFA Support" authentication with the SQL Query Editor. Side effects of such closure included global temporary tables are dropped unexpectedly and sometimes a new SPID is given to the connection.

  • Fixed a long outstanding issue in which restore plan would fail to find a restore plan or would generate an inefficient restore plan under certain conditions.

  • Fixed an issue in the "Import Data-tier Application" wizard which could result in an error when it's connected to an Azure database (DB).

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×