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 details updates, improvements, and bug fixes for the current version of SQL Server Management Studio 22.
Note
To authenticate to database engines with Microsoft Entra multifactor authentication (MFA), including Azure Analysis Services, install the latest version of SQL Server Management Studio (SSMS).
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.0.0
Download SQL Server Management Studio (SSMS) 22
- Release number: 22.0.0
- Release date: November 11, 2025
What's new in 22.0.0
| Feature | Details |
|---|---|
| Always Encrypted | Added support for sovereign cloud solutions Bleu and Delos. |
| Arm64 Support | Added initial Windows Arm64 support for core SSMS 22 scenarios, including connecting and querying. See Known Issues for a list of scenarios that are still unsupported. |
| Connection dialog | Added Fabric browsing to the Browse tab. |
| Connection Dialog | The modern dialog is the default connection dialog. |
| Connection Dialog | Added a Reset button to clear the fields in the Connection Properties section. |
| Database Tuning Advisor (DTA) | Improved DTA functionality including better tuning coverage to queries with temp tables, table variables, triggers, improved index tuning quality, and general scalability and concurrency. |
| Edit Data | Added support for Vector data type to Edit Data. |
| Execution Plans | Added the ability to open an execution plan in a new tab. When viewing an Execution Plan, right-click to bring up the menu and select Show Execution Plan in New Tab. See SSMS Right Click To Open Execution Plans In A New Tab. |
| GitHub Copilot in SSMS (Preview) | Added GitHub Copilot in SQL Server Management Studio (Preview), available from the AI Assistance workload in the Visual Studio Installer. |
| GitHub Copilot in SSMS | Added support for model selection within chat. |
| GitHub Copilot in SSMS | Improved responses for SQL Server 2025 (17.x) features. |
| GitHub Copilot in SSMS (Preview) | Introduced support for the SSMS responder when using Ask Copilot within Feature Search. |
| Indexes | Added options to create Vector and JSON indexes. Right-click Indexes > New Index > JSON Index... or Vector Index... |
| IntelliSense | Added support for CURRENT_TIMEZONE_ID syntax, see SSMS 21 does not recognize CURRENT_TIMEZONE_ID function. |
| IntelliSense | Added support for ANSI concatenation using the ||= operator. |
| IntelliSense | Added support for AI_GENERATE_EMBEDDINGS syntax. |
| IntelliSense | Added support for regular expression functions REGEXP_MATCHES and REGEXP_SPLIT_TO_TABLE. |
| IntelliSense | Added IntelliSense support for VECTOR_SEARCH, CREATE VECTOR INDEX, AUTOSEEDING_SYSTEM_DATABASES, REUSE_SYSTEM_DATABASES, AND CREATE JSON INDEX. |
| JSON Viewer | Added the ability to view JSON data from the results grid. See JSON column view like in Azure Data Studio. |
| Libraries | Updated Server Management Objects (SMO) to version 17.100.73. |
| Libraries | Updated DacFx to version 170.0.97. |
| Linked Server Wizard | Introduced a streamlined creation wizard for linked servers, including new encryption model options. |
| Managed Instance Link | Updated the authentication control to align with the one used elsewhere in SSMS. |
| Object Explorer | Introduced display information for dimension and base type parameters for vector data types in Object Explorer. |
| Query Editor | Added information section to the Rename Tabs dialog to provide information about said functionality. |
| Query Hint Recommendation Tool (Preview) | Added the Query Hint Recommendation tool (Preview) component under Individual Components > Code Tools in the Visual Studio Installer. |
| Query Plans | Added support for JSON and Vector index operations. |
| Query Store | Improved Find Query and Run Query buttons in the Tracked Queries report. |
| Results Grid | Introduced Zoom support for grid results, see Zoom the results area independently. |
| Scripting | Added scripting support for tables with Vector columns. |
| Snippets | Added numerous new snippet files, including snippets for creating various index types, creating and altering external models for AI embeddings, and managing security and schema objects. |
| SQL Server Integration Services (SSIS) | Reinstated SQL Server Integration Services (SSIS) capabilities, including SSISDB catalog management, automated execution of SSIS packages, and the Import Export Wizard. |
| Startup commands | Removed -G and -E options (replaced by -A). |
| Table Designer | Added support for Vector data type to Table Designer. |
| Themes | Introduced new themes and removed the Blue (SSMS) theme. |
| Theming | Expanded dark theme support to include the Connect to Azure Storage dialog, and the Registered Servers Export, Import, and Move Registered Server dialogs. |
| Visual Studio | Updated to Visual Studio 18.0.0 Insiders [11201.2]. |
Bug fixes in 22.0.0
| Feature | Description |
|---|---|
| Activity Monitor | Resolved various context menu issues for Recent Expensive Queries and Active Expensive Queries. See Activity Monitor Failed to retrieve Execution Plan data. |
| Analysis Services | Resolved error Object reference not set to an instance of an object. (Microsoft.VisualStudio.Design) when browsing OLAP cubes. See SSMS 21 Error browsing OLAP cubes. |
| Analysis Services | Resolved error Could not load file or assembly 'Microsoft.Data.ConnectionUI.Dialog, Version=17.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. See Browse MDM models generates an error. |
| Authentication | Introduced a new menu option in Help > Clear Entra ID Token Cache to fix an issue that prevented users were recently added to an Entra ID group from being able to login. See Unable to login when recently been added to an EntraID group. |
| Available Databases | Resolved an issue that generated the error Parse error at line: 1, column: 5: Incorrect syntax near 'NOEXEC'. when switching between a SQL database and a Data Warehouse on the same server. See Issue switching between DW and SQL database in SSMS21. |
| Connection Dialog | Fixed an issue where the Application Name field in Advanced Properties wasn't being inherited. See New Query from Object Explorer Does Not Inherit App Name from Highlighted Database. |
| Database Properties | Fixed an issue that blocked the ability to change compatibility level for users with ALTER permissions. See Database compatibility level drop down disabled but query works. |
| Database Properties | Fixed validation for MAXDOP and LEDGER_DIGEST_STORAGE_ENDPOINT in Database Scoped Configurations tab. |
| Find/Replace | Restored ability to use Ctrl+C in the Find/Replace dialog after opening a saved .sql file. See Copy (Ctrl+C) does not work in Find/Replace dialog. |
| General UI | Resolved behavior for selected dialogs that would appear behind the main windows when opened. |
| General UI | Fixed issue that generated the error Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project. You must save the unsaved document(s) before cutting or copying them. when using Ctrl+C in the Quick Find dialog (Ctrl+F). |
| Generate Scripts Wizard | Resolved an Object reference not set to an instance of an object error thrown when trying to select options on the Set Scripting Option menu. See Advance option on generate script button click throwing error in SSMS 2022 Preview 3. |
| GitHub Copilot in SSMS (Preview) | Updated Copilot Badge Learn More menus to reference SSMS documentation. |
| GitHub Copilot in SSMS (Preview) | Fixed unexpected hang in chat window or SSMS. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot. |
| GitHub Copilot in SSMS (Preview) | Addressed bug where Copilot could generate broken queries where whitespace was incorrectly ignored. |
| GitHub Copilot in SSMS (Preview) | Updated the unsaved query editor name to match what's displayed on the editor tab. |
| GitHub Copilot in SSMS (Preview) | Fixed invalid file name error when selecting Add to new file for a query in the chat window. |
| GitHub Copilot in SSMS (Preview) | Fixed an issue with an empty chat window that hangs. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot. |
| GitHub Copilot in SSMS (Preview) | Improved task execution reliability. |
| Object Explorer | Resolved an error that was generated when dragging table objects from the Object Explorer to the Query Editor. |
| Object Explorer | Resolved an issue that prevented direct scroll bar navigation from working properly. See Direct scroll bar navigation via Shift-click does not work for Object Explorer and Results Grid. |
| PowerShell | Fixed a bug that generated an error when attempting to start PowerShell from the Object Explorer context menu. |
| Query Editor | Resolved an issue where the "Include column headers" option wasn't properly applied in new query windows. See Copying query results does not include headers, even when the "Include column headers" option is enabled. |
| Query Editor | Resolved a behavior that prevented scrolling of the query editor pane when the results pane was in focus. See Query window pane does not mouse wheel scroll up if results window pane is selected. |
| Query Store | Addressed incorrect sizing with Configure Regressed Queries dialog. See "Configure regressed queries" dialog goes off the screen vertically on 1920x1080 monitor. |
| Reports | Addressed a bug that caused an arithmetic overflow error in the Object Execution Statistics and Batch Execution Statistics reports when execution_count exceeded the int data type limit. |
| Results Grid | Resolved an issue that prevented direct scroll bar navigation from working properly. See Direct scroll bar navigation via Shift-click does not work for Object Explorer and Results Grid. |
| Solution Explorer | Resolved an error that was generated when opening a folder that was closed but had files that were open. See SSMS 21 Preview - error while opening a folder in Windows 11. |
| Status Bar | Fixed an issue that caused color contrast issues when certain colors were selected. See Query Summary Row, Text Illegible, Accessibility Issue. |
| Status Bar | Reinstated line and column numbers in the status bar. See In SSMS21 I can't find column number after clicking cell in grid results. |
| T-SQL Language Settings | Fixed a bug that caused some T-SQL language settings to persist between SSMS sessions. |
Known issues
For more information, see Known issues in SQL Server Management Studio.
Support or troubleshooting
Sometimes, things can go wrong. If your SSMS installation fails, see Troubleshoot installation and upgrade issues for SQL Server Management Studio for step-by-step guidance.
You can reference the SSMS Developer Community site for other known issues (filter on Tooling under Groups) and to provide feedback to the product team.