SQL Server Management Studio

What's new in this version:

- Added support for sovereign cloud solutions Bleu and Delos
- 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
- Added Fabric browsing to the Browse tab
- The modern dialog is the default connection dialog
- Added a Reset button to clear the fields in the Connection Properties section
- Improved DTA functionality including better tuning coverage to queries with temp tables, table variables, triggers, improved index tuning quality, and general scalability and concurrency
- Added support for Vector data type to Edit Data
- 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
- Added GitHub Copilot in SQL Server Management Studio (Preview), available from the AI Assistance workload in the Visual Studio Installer
- Added support for model selection within chat
- Improved responses for SQL Server 2025 (17.x) features
- Introduced support for the SSMS responder when using Ask Copilot within Feature Search
- Added options to create Vector and JSON indexes. Right-click Indexes > New Index > JSON Index... or Vector Index..
- Added support for CURRENT_TIMEZONE_ID syntax, see SSMS 21 does not recognize CURRENT_TIMEZONE_ID function
- Added support for ANSI concatenation using the ||= operator
- Added support for AI_GENERATE_EMBEDDINGS syntax
- Added support for regular expression functions REGEXP_MATCHES and REGEXP_SPLIT_TO_TABLE
- Added IntelliSense support for VECTOR_SEARCH, CREATE VECTOR INDEX, AUTOSEEDING_SYSTEM_DATABASES, REUSE_SYSTEM_DATABASES, AND CREATE JSON INDEX
- Added the ability to view JSON data from the results grid. See JSON column view like in Azure Data Studio
- Updated Server Management Objects (SMO) to version 17.100.73
- Updated DacFx to version 170.0.97
- Introduced a streamlined creation wizard for linked servers, including new encryption model options
- Updated the authentication control to align with the one used elsewhere in SSMS
- Introduced display information for dimension and base type parameters for vector data types in Object Explorer
- Added information section to the Rename Tabs dialog to provide information about said functionality
- Added the Query Hint Recommendation tool (Preview) component under Individual Components > Code Tools in the Visual Studio Installer
- Added support for JSON and Vector index operations
- Improved Find Query and Run Query buttons in the Tracked Queries report
- Introduced Zoom support for grid results, see Zoom the results area independently
- Added scripting support for tables with Vector columns
- 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
- Reinstated SQL Server Integration Services (SSIS) capabilities, including SSISDB catalog management, automated execution of SSIS packages, and the Import Export Wizard
- Removed -G and -E options (replaced by -A)
- Added support for Vector data type to Table Designer
- Introduced new themes and removed the Blue (SSMS) theme
- Expanded dark theme support to include the Connect to Azure Storage dialog, and the Registered Servers Export, Import, and Move Registered Server dialogs
- Updated to Visual Studio 18.0.0 Insiders [11201.2]

Fixed:
- Resolved various context menu issues for Recent Expensive Queries and Active Expensive Queries. See Activity Monitor Failed to retrieve Execution Plan data
- 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.
- 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.
- 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
- 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
- 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
- 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
- Fixed validation for MAXDOP and LEDGER_DIGEST_STORAGE_ENDPOINT in Database Scoped Configurations tab
- 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
- Resolved behavior for selected dialogs that would appear behind the main windows when opened
- 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)
- 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
- Updated Copilot Badge Learn More menus to reference SSMS documentation
- Fixed unexpected hang in chat window or SSMS. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot
- Addressed bug where Copilot could generate broken queries where whitespace was incorrectly ignored
- Updated the unsaved query editor name to match what's displayed on the editor tab
- Fixed invalid file name error when selecting Add to new file for a query in the chat window
- Fixed an issue with an empty chat window that hangs. See SSMS 22 Preview hangs at Modern Connection Dialog after installing GitHub Copilot
- Improved task execution reliability
- Resolved an error that was generated when dragging table objects from the Object Explorer to the Query Editor
- 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
- Fixed a bug that generated an error when attempting to start PowerShell from the Object Explorer context menu
- 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
- 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
- Addressed incorrect sizing with Configure Regressed Queries dialog. See "Configure regressed queries" dialog goes off the screen vertically on 1920x1080 monitor
- 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
- 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
- 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
- Fixed an issue that caused color contrast issues when certain colors were selected. See Query Summary Row, Text Illegible, Accessibility Issue
- Reinstated line and column numbers in the status bar. See In SSMS21 I can't find column number after clicking cell in grid results
- Fixed a bug that caused some T-SQL language settings to persist between SSMS sessions