SQL Server Management Studio (SSMS) 17.9.1 is now generally available

SQL Server Management Studio (SSMS) 17.9.1 is now generally available.

This is a minor update to 17.9 with the following important improvements:

• Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this is as follows:
  • Open a New Query window in SSMS
  • Connect to Azure SQL DB with MFA
  • Create a global temp table, insert some data and run a SELECT from the table
  • After a few seconds, re-run the above SELECT statement
  • The Temp table may have been dropped, in certain scenarios.

Based on a few CSS cases and the impact of these issues, we decided to release a minor update for the benefit of our customers.

• DAC Wizards: DacFX Import/Export fails with the below error during import:
  • Failed to connect to server sqlce.database.windows.net. (Microsoft.SqlServer.Smo).
• SSMS Restore plan: SSMS does not generate correct restore plan and picks up an older full backup, despite having newer full backups.
• SMO: Updated Microsoft.SqlServer.SqlManagementObjects NuGet package to include a readme.txt file.