Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
This article provides details about updates, improvements, and bug fixes for the current version of SQL Server Management Studio 22.
Current SQL Server Management Studio release
Download SQL Server Management Studio (SSMS) 22
SQL Server Management Studio 22 is the latest general availability (GA) release of SSMS.
For previous versions of SSMS, see:
- Release notes for SQL Server Management Studio (SSMS) 21
- Release notes for SQL Server Management Studio (SSMS) 20
- Release notes for SQL Server Management Studio (SSMS) 19 and earlier versions
22.9.1
Download SQL Server Management Studio (SSMS) 22
- Release number: 22.9.1
- Release date: August 18, 2026
What's new in 22.9.1
| Feature | Details |
|---|---|
| Visual Studio | Updated to Visual Studio 18.9.1 [12112.369]. |
Bug fixes in 22.9.1
| Feature | Description |
|---|---|
| Index Properties Dialog | Fixed an issue that generated a System.Windows.Media.Effects.DropShadowEffect error when trying to modify included columns on indexes. See SSMS Object Explorer index Included Columns dialog throws DropShadowEffect cross-thread exception. |
| Restore Database Wizard | Fixed an issue that generated a System.Windows.Media.Effects.DropShadowEffect error when hovering over the timeline interval. See Restore Database wizard Timeline Interval hover throws Freezable exception. |
22.9.0
- Release number: 22.9.0
- Release date: August 11, 2026
What's new in 22.9.0
| Feature | Details |
|---|---|
| Azure SQL Database | Updated the Create Database dialog for Azure SQL Databases with separate fields for compute and storage selection, removed options that don't apply to Azure SQL Databases, and changed the default tier to Hyperscale Gen5 2 vCore. |
| Connection Dialog | Added the hostname in certificate field to the default connection properties view. |
| Connection Dialog | Added support for subscription search and filtering when browsing Azure resources and workspaces, and when browsing Fabric resources. |
| Connection Dialog | Added horizontal layout support. |
| Connection Dialog | Changed the server name field to an editable drop-down menu for improved keyboard accessibility. |
| Connection Dialog | Increased the maximum number of recent and favorite connections to 60. |
| Connection Dialog | Added support for browsing Managed Instances for Azure. |
| Connection Dialog | Added search and filtering support to the Browse tab. |
| Connection Dialog | Added support for connection import and export. |
| Connection Dialog | Added enhanced support for available SSMS themes. |
| Database DevOps (preview) | Improved support for theming in dialogs, including Publish, Generate Script, and Add Database Reference dialogs. |
| Database DevOps (preview) | Added more reference types to the Add Database Reference dialog. The dialog now supports four reference types: DACPAC, database project, NuGet package, plus the existing system database. |
| Database DevOps (preview) | Updated the SqlProj document tab names to remove the "- not connected" suffix. See Document tab names in SSMS sqlproj are not good. |
| Database DevOps (preview) | Added support for schema compare (.scmp) and publish profile (.publish.xml) files in Solution Explorer, including launching Schema Compare and Publish from the associated file type. |
| Database Properties | Added the TIME_ZONE configuration option. |
| GitHub Copilot Agent Mode (preview) | Added tools that let GitHub Copilot interact with connected objects in Object Explorer. |
| GitHub Copilot Ask Mode | Updated the behavior of Ask mode and removed the ability to execute arbitrary queries. |
| Settings | Updated the startup settings to remove conflicting options and increase clarity. See Startup configured to open Empty environment still showing Connect windows on starting. |
| SQL Formatter (preview) | Added the ability to indent with tabs instead of spaces. See SQL Formatter lacks option to indent with tabs instead of spaces. |
| SQL Formatter (preview) | Added a setting that configures comma style (trailing or leading). See SQL Formatter lacks configurable option for trailing comma style. |
| SQL Formatter (preview) | Added a setting that configures column aliases to use the AS keyword, an equals sign, or the original style. See SQL Formatter: add option to preserve column alias style "AS" or "=". |
| SQL Formatter (preview) | Added settings that control the new line after the JOIN keyword and before the ON keyword. See SQL Formatter forces newline after JOIN and lacks "new line before ON" option. |
| SQL Formatter (preview) | Added a before-and-after preview to the SQL Formatter settings dialog, which displays example T-SQL with the selected settings. See SQL Formatter settings should preview before/after T-SQL changes. |
| SQL Formatter (preview) | Removed the Include Semicolons setting. |
| Visual Studio | Updated to Visual Studio 18.9.0 [12105.275]. |
Bug fixes in 22.9.0
| Feature | Description |
|---|---|
| Connection dialog | Fixed an issue that prevented saving multiple connection strings with different application intent values. See Unable to save 2 connection strings with different application intents using the new connect screen. |
| Database Tuning Advisor | Fixed an issue that generated an initialization error when running Database Tuning Advisor on the Japanese version of SSMS. |
| Error messages | Fixed help links in several error dialogs that generated 404 errors. See SQL Server error 4815 documentation link returns 404 (error message body during CSV import). |
| General | Fixed a stack overflow crash that occurred when mousing over a nested query. |
| Object Explorer | Fixed an issue that prevented some users from viewing Agent details despite having the proper permissions. |
| Query Data Store | Fixed an issue that displayed an incorrect value for Stale Threshold when Custom capture mode was initially enabled. |
| Results Grid | Fixed an issue that truncated the toolstrip labels in some languages. See Visibility counts completed rows. |
| Schema Compare (preview) | Fixed an issue that did not show comment-only differences immediately before a CREATE VIEW in the diff viewer. See Schema Compare Preview fails to display comment-only differences in front of create views. |
| Schema Compare (preview) | Fixed an issue that caused Schema Compare to show no differences between different database schemas. See Schema compare shows no differences between different database schemas. |
| Schema Compare (preview) | Fixed a bug that ignored comments regardless of the Ignore Comments setting. See Compare Schemas ignores comment differences regardless of Ignore Comments setting. |
| Schema Compare (preview) | Fixed an issue that made SQL stored procedure bodies that differ semantically appear in the diff view as though they were reformatted, even though applying the change preserved the original formatting in the target database. See When comparing stored procedures in Schema Compare, they are reformatted. |
| Schema Compare (preview) | Fixed an issue that incorrectly highlighted whitespace differences in the Schema Compare diff viewer. See Schema Compare incorrectly flags differences in whitespace in table comparison which is due to how SSMS formats the CREATE TABLE script. |
| Security | Fixed a potential security issue when replaying traces that invoke stored procedures with table-valued parameters via RPC. |
| Security | Addressed vulnerabilities CVE-2025-70873, CVE-2026-11822, and CVE-2026-11824. See SSMS SQLite library needs updating. |
| SQL Agent | Fixed an issue that required users to have EXECUTE permission on xp_instance_regread to view or run SQL Server Agent jobs. See SQL Agent blocks AD groups from viewing jobs without xp_instance_regread access. |
| SQL Formatter (preview) | Fixed an issue that merged CONSTRAINT lines into the preceding commented line. See SQL Formatter merges CONSTRAINT line into preceding -- comment. |
| Theme | Fixed an issue that caused the SSMS theme to revert to Cool Breeze after restarting. See SSMS theme setting reverts from Dark to Cool Breeze after restart. |
| Toolbar | Fixed an issue that caused several toolbar icons to disappear. See SSMS toolbar icons missing for query controls and execution plan buttons. |
22.8.2
- Release number: 22.8.2
- Release date: July 28, 2026
What's new in 22.8.2
| Feature | Details |
|---|---|
| Visual Studio | Updated to Visual Studio 18.8.2 [12023.21]. |
Bug fixes
| Feature | Description |
|---|---|
| GitHub Copilot in SSMS | Fixed an issue that caused inline chat to fail with the error There was a problem completing your request. Please try again. |
22.8.1
- Release number: 22.8.1
- Release date: July 22, 2026
What's new in 22.8.1
| Feature | Details |
|---|---|
| Visual Studio | Updated to Visual Studio 18.8.1 [12016.197]. |
22.8.0
- Release number: 22.8.0
- Release date: July 14, 2026
What's new in 22.8.0
| Feature | Details |
|---|---|
| Database DevOps (preview) | Added SQL projects system database package references (master, msdb) to Solution Explorer. |
| Database Properties | Added the Auto Index Compaction option to the Database Properties and New Database dialogs. |
| GitHub Copilot in SSMS Agent Mode (preview) | Added several skills, including: statistics assessments, geo DR, wait category analysis, slow query investigation, IO pressure, active connections, resource usage, and memory issues. |
| Libraries | Updated MSOLEDBSQL MSI to 19.4.2. |
| Results Grid | Updated the Save Results Grid behavior to default to the last file type used. |
| Schema Compare | Added a label to the schema compare results Group By button, displaying "Action", "Schema", or "Type". |
| Visual Studio | Updated to Visual Studio 18.8.0 [12009.203]. |
Bug fixes in 22.8.0
| Feature | Description |
|---|---|
| Execution Plans | Fixed an issue that caused parts of a branched query to be omitted when you select Edit Query Text. See SSMS's Edit Query Text doesn't show contents of all IF branches in a query. |
| GitHub Copilot in SSMS Agent Mode (preview) | Fixed several bugs that generated various error messages, including ISharedTelemetryNull, ProxyTimeoutOnly, TokenManagerProxy, and ICopilotInteractionServiceNull. |
| Import/Export Wizard | Fixed an issue with the SQL Server Import/Export Wizard that generated an error when the data source was Microsoft OLE DB Driver 19 for SQL Server. |
| Localization | Fixed the Czech translation for Select Top and Edit Top N Rows. See Czech translation is horrible AI translation in SSMS 22. |
| Migration Assistant | Fixed an issue that caused the Migration Assessment wizard to crash. See Migration assessment fails with same error across multiple machines. |
| Object Explorer Details | Fixed a bug that caused various rendering issues when scrolling the Object Explorer details window after a refresh. See Object Explorer Details pane eventually goes blank. |
| Schema Compare | Restored syntax coloring in the diff viewer. |
| SQL Formatter | Fixed a bug that caused invalid syntax in scripts that had leading commas. See SQL Formatter reformats leading commas to invalid SQL. |
| SQL Formatter | Fixed an error that combined block comments with adjacent single line comments. See SQL Formatter merges block comment into - comment, causing Msg 102. |
| SQL Formatter | Fixed an issue where the entire editor was eligible for formatting when in SQLCMD mode. Scripts containing SQLCMD syntax can be formatted with non-SQLCMD syntax highlighted. See SSMS SQL formatter fails to parse scripts with SQLCMD Mode commands. |
| Query Shortcuts | Fixed an issue that caused the query shortcuts menu in Tools > Options > Keyboard > Query Shortcuts to be disabled. See Query Shortcuts menu is disabled and cannot add new shortcuts. |
| Query Tabs | Fixed a regression that caused renamed query tabs to revert to their default tab name after executing a query. See SSMS query tab execution resets renamed tab title to original name. |
| Registered Servers | Fixed an unhandled exception error that was thrown when opening the Database Engine group. |
22.7.2
- Release number: 22.7.2
- Release date: June 23, 2026
Bug fixes in 22.7.2
| Feature | Description |
|---|---|
| GitHub Copilot | Fixed an HTTP 401 request error that occurred when the access token became stale. |
| GitHub Copilot in SSMS | Fixed an issue where GitHub Copilot fails to open with a RemoteInvocationException error. See Copilot window fails to open in SSMS with StreamJsonRpc.RemoteInvocationException. |
| GitHub Copilot in SSMS Agent Mode (preview) | Fixed an issue where the Syntax Validation Tool could incorrectly execute a query. |
| Visual Studio | Updated to Visual Studio 18.7.2 [11919.86] |
22.7.1
- Release number: 22.7.1
- Release date: June 16, 2026
Bug fixes in 22.7.1
| Feature | Description |
|---|---|
| Query editor | Fixed an issue where large scripts caused the query editor to consume excessive memory, leading to hangs and other performance problems. |
| Visual Studio | Updated to Visual Studio 18.7.1 [11911.148] |
22.7.0
- Release number: 22.7.0
- Release date: June 9, 2026
What's new in 22.7.0
| Feature | Details |
|---|---|
| Authentication | Added support for creating a Windows account on Azure SQL Managed Instance. |
| Database DevOps workload (preview) | Added a target database (platform) selection to the new SQL project dialog. |
| Database DevOps workload (preview) | Added a Create project from database action to the Solution node context menu in Solution Explorer. |
| Database DevOps workload (preview) | Added SQLCMD variable support to the Publish dialog. |
| Database DevOps workload (preview) | Updated the SQL project Properties editor UI to align with the Visual Studio Property Page editor. |
| GitHub Copilot in SSMS Agent Mode (preview) | Agent Mode for GitHub Copilot in SSMS is now available in preview. |
| GitHub Copilot in SSMS | Introduced separate execution context for GitHub Copilot using the database CONSTITUTION.md. For more information, see Execution context for GitHub Copilot in SQL Server Management Studio. |
| Libraries | Updated Microsoft.Data.SqlClient to 6.1.5. |
| Query editor | Added SQL formatting (preview). |
| Schema compare | Added schema comparison (preview) for databases, .dacpac files, and SQL projects. |
| Visual Studio | Updated to Visual Studio 18.7.0 [11903.348] |
Bug fixes in 22.7.0
| Feature | Description |
|---|---|
| Command Line | Fixed an issue where the Connect to Server dialog appeared even when both -S and -d command-line parameters were provided alongside a filename. See Unable to skip the Connect dialog, even with -S and -d parameters, if you pass as filename. |