SQL Server Management Studio (SSMS) 发行说明Release notes for SQL Server Management Studio (SSMS)

适用于: 是SQL Server 是Azure SQL 数据库 是Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: YesSQL Server YesAzure SQL Database YesAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

本文提供有关 SSMS 的当前和以前版本的更新、改进和 bug 修复的详细信息。This article provides details about updates, improvements, and bug fixes for the current and previous versions of SSMS.

18.518.5

  • 下载:下载 SSMS 18.5Download: Download SSMS 18.5
  • 生成号:15.0.18330.0Build number: 15.0.18330.0
  • 发行日期:2020 年 4 月 7 日Release date: April 07, 2020

中文(简体) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

SSMS 18.5 是 SSMS 的最新正式发布 (GA) 版本。SSMS 18.5 is the latest general availability (GA) release of SSMS. 如果需要 SSMS 的早期版本,请参阅 SSMS 的早期版本If you need a previous version of SSMS, see previous SSMS releases.

18.5 是 18.4 的更新版本,包含以下新项和缺陷修复。18.5 is an update to 18.4 with the following new items and bug fixes.

18.5 中的新变化What's new in 18.5

新建项New item 详细信息Details
Analysis ServicesAnalysis Services 现已开始支持 Analysis Services 中的 Power BI 终结点(Azure Analysis Services 的匹配功能)。Added support for Power BI endpoint in Analysis Services - matching functionality of Azure Analysis Services.
Analysis ServicesAnalysis Services 探查器:现已开始支持 Analysis Services 跟踪定义 15.1。Profiler: added support for Analysis Services Trace Definition 15.1.
数据分类Data Classification 向 VA 扫描结果视图添加了按钮,单击此但能可转到“数据分类”窗格,从而修正数据分类规则。Added a button to the VA scan result view, in order to remediate data classification rule by going to the data classification pane.
数据分类Data Classification 现已开始支持“数据分类”中的敏感度级别。Added support for sensitivity rank in Data Classification.
超大规模Hyperscale 现已开始支持向 SQL Azure 超大规模导入数据层应用程序 (.bacpac) 。Added support for Import Data-Tier Application (.bacpac) to SQL Azure HyperScale.
Integration ServicesIntegration Services 支持在 MI 代理作业中通过文件系统执行 SSIS 包。Support executing SSIS Package from file system in MI Agent Job.
Integration ServicesIntegration Services 在将已启用 Azure 的 DTExec 配置为在 Azure-SSIS Integration Runtime 上调用 SSIS 包执行方面进行了用户友好改进。Made user-friendly improvements in configuring Azure-enabled DTExec to invoke SSIS package executions on Azure-SSIS Integration Runtime.
Integration ServicesIntegration Services 支持连接 Azure-SSIS Integration Runtime,以及管理或执行包存储中的 SSIS 包。Support connecting Azure-SSIS integration runtime and managing or executing SSIS packages in package stores.
Integration ServicesIntegration Services 支持将本地 SSIS 代理作业迁移到 ADF 管道和触发器。Support migrating on-premises SSIS agent jobs to ADF pipelines and triggers.
Integration ServicesIntegration Services 改进了从 SSIS DB 导出 SSIS 项目的用户体验。Made an improvement for the user experience of exporting SSIS projects from SSIS DB. 旧版导出加载和升级了 SSIS 项目中的包,相比之下,新版独立导出不会加载和升级 SSIS 项目中的包。Compared with the old Export, which loaded and upgraded packages in the SSIS project, the new version-independent Export won't load and upgrade packages in the SSIS project. 而是将包保留在项目中,就像它们在 SSIS DB 中一样,不同之处在于将保护级别更改为 EncryptSensitiveWithUserKey。Instead, it keeps packages in the projects as they are in SSIS DB except changing protection level to EncryptSensitiveWithUserKey.
SMO/脚本SMO/Scripting 向 View 对象添加了新属性 DwMaterializedViewDistribution。Added new DwMaterializedViewDistribution property to View object.
SMO/脚本SMO/Scripting 已取消支持功能限制 (此预览功能已从本地 SQL Azure 和 SQL 中删除)。Removed support for Feature Restriction (this preview feature has been removed from SQL Azure and SQL on-prem).
SMO/脚本SMO/Scripting 添加了“笔记本” ,可作为“生成脚本”向导的目标。Added Notebook as a destination for Generate Scripts wizard.
SMO/脚本SMO/Scripting 添加了对按需 SQL 的支持 。Added support for SQL On Demand.
SMO/脚本SMO/Scripting SQL 评估 API -“平台”、“名称”和“engineEdition”字段现在可以包含常规的逗号分隔列表(“平台” :[Windows , Linux ]),而不仅仅包含正则表达式(“平台” :/Windows|Linux/ )SQL Assessment API - Platform, Name, and engineEdition fields can now contain usual comma-separated lists (platform: [Windows, Linux]), not only regular expressions (platform: /Windows|Linux/)
SMO/脚本SMO/Scripting SQL 评估 API - 添加了 13 条评估规则。SQL Assessment API - Added 13 assessment rules. 如需了解更多详情,请转到 GitHubFor more details, go to GitHub).

18.5 中的缺陷修复Bug fixes in 18.5

新项New Item 详细信息Details
可访问性Accessibility SSIS ADF/新建计划 - 修复了以下问题:在讲述人的扫描模式下,“新建计划” 向导下的焦点顺序不符合逻辑。SSIS ADF / New Schedule: fixed an issue where the focus order is not logical in the scan mode of narrator under New Schedule wizard.
可访问性Accessibility 延伸数据库向导 - 修复了以下问题:屏幕阅读器在提供查询表的相关信息时不提示表名称。Stretch database wizard: fixed an issue where the screen reader does not inform about the name of the query table when providing information about the table.
Analysis ServicesAnalysis Services 修复了使用 AAD 连接在 AS 中编写脚本时的缓存连接。Fix cached connection when scripting in AS with AAD connection.
AlwaysOnAlways On 修复了以下问题:第一个添加到 AlwaysOn AG 的数据库无法正确联接。Fixed an issue where the first database added to Always On AG does not join correctly.
AlwaysOnAlways On 修复了以下问题:在连接到大数据群集终结点后,如果尝试显示仪表板,会看到错误消息。Fixed an issue where an error was displayed when trying to display the dashboard when connected to a Big Data Cluster endpoint.
审核Auditing 修复了以下问题:如果存储帐户的根文件夹中有名称为空的文件夹,“审核日志合并”窗口发生故障。Fixed an issue where the Audit logs merges window crashes when there's a folder with an empty name in the root folder of the storage account.
审核Auditing 修复了以下问题:如果容器的根目录中的项过多,“审核日志合并”窗口不会显示所有服务器。Fixed an issue where the Audit logs merge window doesn't show all servers when there are too many items in the root of the container.
数据分类Data Classification 修复了以下问题:对于包含大量表的数据库,“数据分类” 向导不会打开。Fixed an issue where the Data Classification wizard won't open for databases with large number of tables.
数据分类Data Classification 现在,在验证过程中,我们对每个标签/infoType 强制执行不同的 GUID,并强制执行 GUID 的结构。We are now enforcing different GUIDs for every label/infoType and GUID's structure in the validation process.
数据分类Data Classification 删除了 SqlServer2019 中的分类流程。Remove classification process in SqlServer2019.
数据分类Data Classification 更正了旧验证测试(添加了级别、删除了非法属性 InformationTypes ),并为前两个点添加了新测试。Correcting the previous validation tests (adding rank, removing the illegal property InformationTypes) and adding new ones for the first two points.
数据分类Data Classification “已分类列”表正上方的按钮现在按预期最小化建议面板。The button just above the classified columns table now minimizes the recommendations panel, as it says.
常规 SSMSGeneral SSMS 更新了 MSODBC 和 MSOLEDB 驱动程序的版本。Updating the version of MSODBC and MSOLEDB drivers.
常规 SSMSGeneral SSMS 解决了 SSMS 中至少两个常见源的挂起和故障问题。Addressed at least two common sources hangs and crashes in SSMS.
常规 SSMSGeneral SSMS 解决了在选择“浏览”按钮时“还原” 对话框挂起的另一种情况。Addressed one more case where Restore dialog hangs when selecting the Browse button.
常规 SSMSGeneral SSMS 修复了 SQL 按需的“新建数据库 GUI” 。Fixed New Database GUI for SQL On Demand.
常规 SSMSGeneral SSMS 修复了 SQL 按需的“新建外部表...” 和“新建外部数据源...”模板 。Fixed New External Table... and New External Data Source... templates for SQL On Demand.
常规 SSMSGeneral SSMS 修复了 SQL 按需的数据库属性、连接属性、报表隐藏和重命名。Fixed database properties, connection properties, hiding reports and rename for SQL On Demand.
常规 SSMSGeneral SSMS Always Encrypted:修复了以下问题:在选择启用了 enclave 的新密钥时,密钥名称下拉列表变成只读列表。Always Encrypted: Fixed an issue where the key name dropdown becomes read-only on selecting new enclave enabled key.
常规 SSMSGeneral SSMS 清理了“数据库属性选项” 网格,其中显示两个“其他类别” 。Cleaned up the Database Property Options grid, which was showing two Miscellaneous Categories.
常规 SSMSGeneral SSMS 修复了以下问题:滚动条从“数据库属性选项”网格的中间开始滚动。Fixed an issue where the scroll bar started from middle in "Database Properties Options" grid.
常规 SSMSGeneral SSMS 修复了以下问题:在连接到 Analysis Services 服务器后,如果打开 .sql 文件,会导致 SSMS 发生故障。Fixed an issue that was causing SSMS to crash when opening .sql file while connected to Analysis Services server.
常规 SSMSGeneral SSMS “连接”对话框 - 修复了以下问题:无法取消选中“记住密码”。Connection Dialog: fixed an issue where unchecking the "Remember Password" does not work.
常规 SSMSGeneral SSMS 修复了以下问题:始终记住与服务器/用户关联的凭据。Fixed an issue where credentials associated to Server/Users are always remembered. 请参阅 UserVoice 37875172See UserVoice 37875172.
常规 SSMSGeneral SSMS 修复了以下问题:“编辑器”窗口有时无法正常刷新。Fixed issue where occasionally Editor windows was not properly refreshed. 为此,可以在“工具”>“选项”>“环境”中禁用硬件加速 。This is achieved by disabling the hardware acceleration in Tools > Options > Environment. 请参阅 UserVoice 37474042See UserVoice 37474042.
常规 SSMSGeneral SSMS 修复了以下问题:无法通过代理进行 Azure Active Directory 身份验证。Fixed an issue where Azure Active Directory authentication was not working through a proxy.
高 DPI/缩放High DPI/Scaling 修复了以下问题:“索引属性” 上的控件可能会错误呈现(按钮重叠网格)。Fixed an issue where the controls on the Index properties could be incorrectly rendered (buttons overlapping grid). 请参阅 UserVoice 36030424See UserVoice 36030424.
高 DPI/缩放High DPI/Scaling 修复了“数据库属性” 对话框中的多个问题,此对话框可能会在 4K 监视器上显示剪裁的控件。Fixed multiple issues in Database Properties dialog, which might show clipped controls on 4K monitors.
高 DPI/缩放High DPI/Scaling 修复了 4k 显示器上的“发布和订阅”向导。Fixed Publication and Subscription Wizards on 4k displays.
高 DPI/缩放High DPI/Scaling 在“新建审核服务器规范”页上进行了次要修复。Minor fix on New Audit Server Specification page.
高 DPI/缩放High DPI/Scaling 修复了“高可用性”向导中的 4k 显示器问题。Fixed 4k display issue on High Availability Wizard.
高 DPI/缩放High DPI/Scaling 修复了以下问题:当缩放比例为 125% 时,用户无法在“Xevent 会话”向导的“Xevent 新建会话”窗口和“设置会话事件筛选器”中添加目标。Fixed an issue where the user was not able to add a target in an Xevent New Session window + Set Session Event Filters in Xevent Session Wizard when display scaling at 125%.
高 DPI/缩放High DPI/Scaling 修复了以下问题:当缩放比例大于 100% 时,“将数据库备份到 URL” UI 上的控件无法呈现。Fixing an issue where controls on the Backup Database to URL UI render out of sight under scaling above 100%.
导入平面文件Import flat file 更新了“平面文件导入”向导,为“允许 NULL”列提供了全部选中的选项。Updated Flat File Import Wizard to allow check all for the allow null column. 请参阅 UserVoice 38027137See UserVoice 38027137.
“对象资源管理器”Object Explorer 修复了以下问题:当连接字符串用于在“连接”对话框进行连接时,对象资源管理器可能会显示不正确的信息。Fixed an issue where Object Explorer could display incorrect information when connection strings are used to connect in Connection Dialog.
“对象资源管理器”Object Explorer 修复了以下问题:对于包含数千个(超过 20,000 个)表的数据库,OE 在展开表时的速度缓慢。Fixed an issue where OE was slow in expanding tables for databases with several thousands tables (20k+).
查询存储 UIQuery Store UI 修复了以下问题:(对于“等待时间” 指标)作为每个单独等待类别的执行计数总和的 TRC 报表计算执行计数不正确。Fixed TRC report calculate execution count (for wait time metric) as the sum of execution counts for each individual wait category, which is incorrect. 但对于查询的单个执行,将为查询等待的每个等待类别都注册它。But for a single execution of query it will be registered for each of the wait category the query waited for. 因此,如果 TRC 只是跨等待类别计算它的总和,则会导致执行计数膨胀。So, if TRC just sums it across the wait category it will bloat the execution count. 实际上,它应是跨 wait_category 的最大值。Actually it should be the Max across the wait_category.
查询存储 UIQuery Store UI 修复了以下问题:当结果集按 top x 进行筛选时,TRC 详细视图返回的数据不正确。Fixed TRC detailed view returns incorrect data when result set is filtered on top x. 之所以会这样是因为,查询使用了多个公用表表达式,这些表达式随后联接在一起,以创建最终结果集。This happens because the query uses multiple common table expressions, which are then joined together to create the final result set. 如果 top x 被推送到 CTE 中,有时可能会筛选掉所需的行。If top x is pushed into CTE, it sometimes can filters out the required rows. 这有时可能会导致结果集具有不确定性。This can sometimes make the result set non-deterministic. 解决方法是,不要将 top x 子句推送到 CTE。The fix is to not push top x clause to CTEs.
查询存储 UIQuery Store UI 修复了以下问题:网格或图表视图中的“计划摘要”需要上次查询执行等待时间。Fixed Plan summary in both - grid or chart view needs last query execution wait time. 缺少此列会破坏查询。Absence of this column is breaking the query. 此更改集会将这一列添加到等待统计信息 CTE。This change set will add this column to the wait stats CTE.
显示计划ShowPlan 改进了 SSMS 如何显示包含多个执行的运算符的估计行计数:(1) 已将 SSMS 中的“估计行数” 修改为“每执行的估计行数”;(2) 新增了属性“所有执行的估计行数” ;(3) 已将属性“实际行数” 修改为“所有执行的实际行数” 。Improved how SSMS displays estimated row counts for operators with multiple executions: (1) Modified Estimated Number of Rows in SSMS to "Estimated Number of Rows Per Execution"; (2) Added a new property Estimated Number of Rows for All Executions; (3) Modify the property Actual Number of Rows to Actual Number of Rows for All Executions.
SQL 代理SQL Agent 修复了以下问题:尝试编辑 SQL 代理作业步骤可能会导致 SSMS UI 冻结。Fixed an issue where trying to edit a SQL Agent job step could have resulted in the SSMS UI freezing. SSMS 现在允许查看(“查看” 按钮)名称已标记化的 output_file(至少对于SQL 代理支持的且在运行时未确定的简单宏/标记是这样)。SSMS is now allowing viewing (View button) an output_file whose name is tokenized (at least for the simple macros/tokens supported by SQL Agent that are not determined at runtime). 此外,当用户无权访问文件时,SSMS 并没有禁用“查看”按钮(就 SQL 权限而言)。Also SSMS is not disabling the "View" button when the user does not have access to the file (as far as SQL permissions go). 请参阅 UserVoice 39063124See UserVoice 39063124.
SQL 代理SQL Agent 修复了“作业步骤”页上的 Tab 键顺序。Fixed the tab ordering on the Job Step page.
SQL 代理SQL Agent 反转了“作业步骤”页上的“下一步”和“上一步”按钮的位置,让它们按逻辑顺序排列。Reversed the position of the "Next" and "Previous" buttons on the Job Step page to put them in a logical order.
SQL 代理SQL Agent 调整了“作业计划”窗口,使其不剪裁 UI。Adjusted the Job Schedule window to not clip the UI.
SMO/脚本SMO/Scripting 修复了 SQL 按需的数据库脚本。Fixed database scripting for SQL On Demand.
SMO/脚本SMO/Scripting 删除了显式 sqlvariant 强制转换(SqlOnDemand 的非法 T-SQL 语法),这修复了 SqlOnDemand 的脚本。Removing explicit sqlvariant cast (illegal T-SQL syntax for SqlOnDemand) which fixes scripting for SqlOnDemand.
SMO/脚本SMO/Scripting 修复了以下问题:跳过 SQL Azure 索引上的 FILLFACTOR。Fixed an issue where FILLFACTOR on indexes for SQL Azure was skipped.
SMO/脚本SMO/Scripting 修复了与为外部对象编写脚本相关的问题。Fixed an issue related to scripting External objects.
SMO/脚本SMO/Scripting 修复了以下问题:“生成脚本” 不允许针对 SQL DB 选择扩展属性的脚本选项。Fixed an issue where Generate Scripts was not allowing choosing the scripting option for Extended Properties against SQL DB. 同时,还修复了此类扩展属性的脚本。Also, fixed the scripting of such extended properties.
SMO/脚本SMO/Scripting SQL 评估 API - XTPHashAvgChainBuckets 规则中的帮助链接不正确。SQL Assessment API - Wrong help link in XTPHashAvgChainBuckets rule.
XEvent UIXEvent UI 修复了以下问题:将鼠标悬停在网格中的项之上即选中这些项。Fixed an issue here items in the grid where being selected on hovering. 请参阅 UserVoice 38262124UserVoice 37873921See UserVoice 38262124 and UserVoice 37873921.

已知问题 (18.5)Known issues (18.5)

  • 无法从计算机 B 修改通过在计算机 A 上运行的 SSMS 创建的数据库关系图(SSMS 崩溃)。Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). 如需了解更多详情,请参阅 UserVoice 37992649See UserVoice 37992649 for more details.

  • 导入或导出 Integration Services 中的包或导出 Azure-SSIS Integration Runtime 中的包时,包含脚本任务/组件的包的脚本丢失。When importing or exporting packages in Integration Services or exporting packages in Azure-SSIS Integration Runtime, scripts are lost for packages containing script tasks/components. 解决方法是,删除文件夹 C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild 。A workaround is to remove the folder C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\MSBuild.

  • “新建服务器审核规范”对话框可能会导致 SSMS 发生故障,并显示访问冲突错误。New Server Audit Specification dialog may cause SSMS to crash with an access violation error.

  • 需要将使用 SMO 的 SSMS 扩展重新编译为,定目标到新的 SMO v160(包将在 SSMS 18.5 发布后立即在 Nuget.org 上提供)SSMS Extensions using SMO would need to be recompiled targeting the new SMO v160 (package will be available on Nuget.org right after SSMS 18.5 is released)

可参考 UserVoice 了解其他已知问题,并向产品团队提供反馈。You can reference UserVoice for other known issues and to provide feedback to the product team.

SSMS 的早期版本Previous SSMS releases

通过选择相关部分中的下载链接下载以前的 SSMS 版本。Download previous SSMS versions by selecting the download link in the related section.

SSMS 版本SSMS version 生成号Build number 发布日期Release date
18.418.4 15.0.18206.015.0.18206.0 2019 年 11 月 4 日November 04, 2019
18.3.118.3.1 15.0.18183.015.0.18183.0 2019 年 10 月 2日October 02, 2019
18.218.2 15.0.18142.015.0.18142.0 2019 年 7 月 25 日July 25, 2019
18.118.1 15.0.18131.015.0.18131.0 2019 年 6 月 11 日June 11, 2019
18.018.0 15.0.18118.015.0.18118.0 2019 年 4 月 24 日April 24, 2019
17.9.117.9.1 14.0.17289.014.0.17289.0 2018 年 11 月 21 日November 21, 2018
16.5.316.5.3 13.0.16106.413.0.16106.4 2017 年 1 月 30 日January 30, 2017

18.418.4

下载 下载 SSMS 18.4download Download SSMS 18.4

  • 版本号:18.4Release number: 18.4
  • 生成号:15.0.18206.0Build number: 15.0.18206.0
  • 发行日期:2019 年 11 月 4 日Release date: November 04, 2019

中文(简体) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

18.4 是对 18.3.1 的更新,添加了以下新项并修复了以下 bug。18.4 is an update to 18.3.1 with the following new items and bug fixes.

新建项New item 详细信息Details
数据分类Data Classification 添加了对用于数据分类的自定义信息保护策略的支持。Added support for custom information protection policy for data classification.
查询存储Query Store 在对话框属性中添加了“每个查询的最大计划数”值 。Added the Max Plan per query value in the dialog properties.
查询存储Query Store 添加了对新的自定义捕获策略的支持。Added support for the new Custom Capture Policies.
查询存储Query Store 向查询存储的“数据库属性” 选项添加了“等待统计信息捕获模式”。Added Wait Statistics Capture Mode to the Query Store Database Properties options.
SMO/脚本SMO/Scripting SQL DW 中的具体化视图的支持脚本。Support Script of materialized view in SQL DW.
SMO/脚本SMO/Scripting 添加了对按需 SQL 的支持 。Added support for SQL On Demand.
SMO/脚本SMO/Scripting SQL 评估 API - 添加了 50 条评估规则(请参阅 GitHub 上的详细信息)。SQL Assessment API - Added 50 assessment rules (see details on GitHub).
SMO/脚本SMO/Scripting SQL 评估 API - 添加了基本数学表达式以及与规则条件的比较。SQL Assessment API - Added base math expressions and comparisons to rules conditions.
SMO/脚本SMO/Scripting SQL 评估 API - 添加了对 RegisteredServer 对象的支持。SQL Assessment API - Added support for RegisteredServer object.
SMO/脚本SMO/Scripting SQL 评估 API - 更新了以 JSON 格式存储规则的方式,还更新了应用替代项/自定义项的机制。SQL Assessment API - Updated way how rules are stored in the JSON format and also updated the mechanism of applying overrides/customizations.
SMO/脚本SMO/Scripting SQL 评估 API - 更新了规则以支持 Linux 上的 SQL。SQL Assessment API - Updated rules to support SQL on Linux.
SMO/脚本SMO/Scripting SQL 评估 API - 更新了规则集 JSON 格式并添加了架构版本。SQL Assessment API - Updated the ruleset JSON format and added SCHEMA version.
SMO/脚本SMO/Scripting SQL 评估 API - 更新了 cmdlet 输出以提高建议的可读性。SQL Assessment API - Updated cmdlets output to improve readability of recommendations.
XEvent 探查器XEvent Profiler 向 XEvent 探查器会话添加了 error_reported 事件 。Added error_reported event to XEvent Profiler sessions.

18.4 中的 bug 修复Bug fixes in 18.4

新项New Item 详细信息Details
Analysis ServicesAnalysis Services 修复了多维数据库的 DAX 脚本编辑器未在 IntelliSense 中显示表的问题。Fixed an issue where the DAX Script editor for multi-dimensional databases didn't show tables in the IntelliSense.
Analysis ServicesAnalysis Services 使用 DAX 分析程序转换为引擎字符串。Use DAX Parser to convert to an Engine string. 这适用于国际分隔符、十进制和空白。This is for international separators, decimal, and whitespace.
Always EncryptedAlways Encrypted 修复了声明验证不区分大小写的问题 。Fixed an issue where the claim validation wasn't case insensitive.
Always EncryptedAlways Encrypted 修复了错误/警告报告未正常运行的问题。Fixed an issue where error/warning reporting wasn't properly working.
复制数据库向导Copy Database Wizard 修复了此对话框呈现中的各种截断和布局问题。Fixed assorted truncation and layout issues in the rendering of this dialog.
常规 SSMSGeneral SSMS 修复了一个长期未解决的问题,即当还指定了 SQL 文件时,SSMS 不遵从在命令行中传递的连接信息。Fixed a long outstanding issue where SSMS wasn't honoring the connection info passed at the command line when SQL files were also specified.
常规 SSMSGeneral SSMS 修复了尝试在“复制筛选器”对象上显示安全对象时 SSMS 中的故障。Fixed a crash in SSMS while trying to display Securables on "Replication Filter" objects.
常规 SSMSGeneral SSMS 通过让 SSMS 查看凭据缓存,减轻了 -P 命令行选项的删除:如果找到所需凭据,则会使用它建立连接。Mitigated the removal of the -P command-line option by having SSMS look at its cache of credentials: if the required credential were found, the connection would be established using it.
导入平面文件Import flat file 修复了导入平面文件 功能未正确处理文本限定符的问题。Fixed an issue where Import Flat File functionality not handling text qualifiers correctly.
“对象资源管理器”Object Explorer 修复了在对象资源管理器中删除 Azure SQL 数据库会显示错误消息的问题。Fixed an issue where dropping an Azure SQL Database in Object Explorer was showing an incorrect message.
查询结果Query Results 修复了在 SSMS 18.3.1 中引入的一个问题,即网格会稍微绘制得窄一点,并在每列中最长的字符串末尾显示“...” 。Fixing an issue introduced in SSMS 18.3.1, where grids are drawn slightly too narrow and show ... at the end of the longest string in every column.
复制工具Replication Tools 修复了在尝试编辑 SQL 代理作业时导致应用程序引发错误(“无法加载文件或程序集...”)的问题。Fixed an issue that was causing the application to throw an error ("couldn't load file or assembly…") when trying to edit SQL Agent jobs.
SMO/脚本SMO/Scripting 修复了其排序规则是 Japanese_BIN2 的 SQL DW 的“编写表脚本为...” Fixed an issue when Script Table As… 无法正常运行的问题。for SQL DW whose collation is Japanese_BIN2 wasn't working.
SMO/脚本SMO/Scripting 修复了 ScriptAlter() 在服务器上结束语句执行的问题。Fixed an issue where ScriptAlter() ended up executing the statements on the server.
SQL 代理SQL Agent 修复了代理操作员 UI 在操作员名称在 UI 中进行了更改时不更新名称,也不会对它编写脚本的问题。Fixed an issue where the agent operator UI would not update the operator name when it was changed in the UI, nor is it scripted. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.

已知问题 (18.4)Known issues (18.4)

  • 无法从计算机 B 修改通过在计算机 A 上运行的 SSMS 创建的数据库关系图(SSMS 崩溃)。Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.

  • 在多个查询窗口之间切换时会出现重绘问题。There are redraw issues when switching between multiple query windows. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details. 此问题的解决方法是在“工具”>“选项” 下禁用硬件加速。A workaround for this issue is to disable hardware acceleration under Tools > Options.

可参考 UserVoice 了解其他已知问题,并向产品团队提供反馈。You can reference UserVoice for other known issues and to provide feedback to the product team.

18.3.118.3.1

下载 下载 SSMS 18.3.1download Download SSMS 18.3.1

  • 版本号:18.3.1Release number: 18.3.1
  • 生成号:15.0.18183.0Build number: 15.0.18183.0
  • 发行日期:2019 年 10 月 2日Release date: October 02, 2019

中文(简体) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

18.3.1 是对 18.2 的更新,添加了以下新项并修复了以下 bug。18.3.1 is an update to 18.2 with the following new items and bug fixes.

18.3 1 的新增功能What's new in 18.3.1

新建项New item 详细信息Details
数据分类Data Classification 向列属性 UI 添加数据分类信息(信息类型 、信息类型 ID 、敏感度标签 和敏感度标签 ID 未在 SSMS UI 中公开)。Add Data Classification information to column properties UI (Information Type, Information Type ID, Sensitivity Label, and Sensitivity Label ID aren't exposed in the SSMS UI).
Intellisense/编辑器Intellisense/Editor 更新了对最近添加到 SQL Server 2019 中的功能(例如,“ALTER SERVER CONFIGURATION” )的支持。Updated support for features recently added to SQL Server 2019 (for example, ALTER SERVER CONFIGURATION).
Integration ServicesIntegration Services 添加新的选择菜单项 Tools > Migrate to Azure > Configure Azure-enabled DTExec,该菜单项将 Azure-SSIS Integration Runtime 上的 SSIS 包执行作为 ADF 管道中的“执行 SSIS 包”活动调用。Add a new selection menu item Tools > Migrate to Azure > Configure Azure-enabled DTExec that invokes SSIS package executions on Azure-SSIS Integration Runtime as Execute SSIS Package activities in ADF pipelines.
SMO/脚本SMO/Scripting 添加了对 Azure SQL DW 唯一约束的支持脚本的支持。Added support for Support scripting of Azure SQL DW unique constraint.
SMO/脚本SMO/Scripting 数据分类Data Classification
添加了对 SQL 版本 10 (SQL 2008) 及更高版本的支持。- Added support for SQL version 10 (SQL 2008) and higher.
- 为 SQL 版本 15 (SQL 2019) 和更高版本以及 Azure SQL DB 添加了新的敏感度属性“rank”。- Added new sensitivity attribute 'rank' for SQL version 15 (SQL 2019) and higher and Azure SQL DB.
SMO/脚本SMO/Scripting SQL 评估 API - 向规则集格式添加了版本控制。SQL Assessment API - Added versioning to ruleset format.
SMO/脚本SMO/Scripting SQL 评估 API - 添加了新的检查。SQL Assessment API - Added new checks.
SMO/脚本SMO/Scripting SQL 评估 API - 添加了对 Azure SQL 数据库托管实例的支持。SQL Assessment API - Added support for Azure SQL Database Managed Instance.
SMO/脚本SMO/Scripting SQL 评估 API - 更新了 cmdlet 的默认视图,将结果作为表格显示。SQL Assessment API - Updated default view of cmdlets to display results as a table.

18.3.1 中的 bug 修复Bug fixes in 18.3.1

新项New Item 详细信息Details
Analysis ServicesAnalysis Services 修复了 MDX 查询编辑器中的缩放问题。Fix scaling issue in MDX Query Editor.
Analysis ServicesAnalysis Services 修复了 XEvent UI 中阻止户创建新会话的问题。Fixed an issue in XEvent UI that prevents the users from being able to create a new session.
到 SQL Azure 的数据库部署Database Deployment to SQL Azure 修复了导致此功能无法正常运行的问题(在 DacFx 中)。Fixed an issue (in DacFx) which was causing this feature not to work.
常规 SSMSGeneral SSMS 修复了导致 SSMS 在 XEvent 查看器使用排序功能时崩溃的问题。Fixed an issue, which was causing SSMS to crash when using the sorting feature in the XEvent viewer.
常规 SSMSGeneral SSMS 修复了 SSMS 还原数据库可能无限期挂起的长期未解决的问题。Fixed long outstanding issues where SSMS Restore database may hang indefinitely.
有关更多详细信息,请参阅 UserVoice 项目:See UserVoice items for more details:
还原数据库 -“选择备份设备”加载缓慢Restore Database - Select Backup Devices Slow to Load.
SSMS 2016 在数据库还原对话框中运行缓慢SSMS 2016 very slow in the database restore dialogs.
还原数据库速度缓慢Restoring database is slow.
单击“...”还原数据库时设备挂起Restore Database from Device HANGS on clicking "...".
常规 SSMSGeneral SSMS 修复了所有登录名的默认语言显示为阿拉伯语的问题。Fixed an issue where the default language for all logins was shown as Arabic.
有关更多详细信息,请参阅 UserVoice 项目:SSMS 18.2 默认语言显示错误See UserVoice item for more details: SSMS 18.2 default language display bug.
常规 SSMSGeneral SSMS 修复了难以看到“查询选项”对话框(当用户右键单击 T-SQL 编辑器窗口时)的问题 。Fixed the hard to see the dialog for Query Options (when the user right-clicks on the T-SQL editor window) by making it resizable.
常规 SSMSGeneral SSMS 现在可以在“工具”>“选项”>“查询执行”>“SQL Server”>“高级”>“显示完成时间”下配置“结果网格/文件”(在 SSMS 18.2 中引入)中显示的“完成时间”消息 。The Completion time message visible in the Result Grid/File (introduced in SSMS 18.2) is now configurable under Tools > Options > Query Execution > SQL Server > Advanced > Show completion time.
常规 SSMSGeneral SSMS 在连接对话框中,将“Active Directory - 密码”和“Active Directory - 集成”分别替换为“Azure Active Directory - 密码”和“Azure Active Directory - 集成” 。In the connection dialog, replaced Active Directory - Password and Active Directory - Integrated with Azure Active Directory - Password and Azure Active Directory - Integrated, respectively.
常规 SSMSGeneral SSMS 修复了以下问题:当用户位于 UTC 偏移量为负的 TZ 中时,用户无法使用 SSMS 配置对 SQL Azure 托管实例的审核。Fixed an issue that prevents users from being able to use SSMS to configure auditing on SQL Azure-Managed Instances when located in a TZ with negative UTC offset.
常规 SSMSGeneral SSMS 修复了 XEvent UI 中将鼠标悬停在网格上导致行被选中的问题。Fixing an issue in XEvent UI where hovering over the grid was causing rows to be selected.
有关更多详细信息,请参阅 UserVoice 项目:SSMS 扩展事件 UI 在鼠标悬停时选择操作See UserVoice item for more details: SSMS Extended Events UI Selects Actions on Hover.
导入平面文件Import flat file 通过让用户在简单或丰富数据类型检测之间进行选择,修复了“导入平面文件”未导入所有数据的问题。Fixed the issue where Import Flat File wasn't importing all data by letting the user choose between a simple or rich data type detection.
有关更多详细信息,请参阅 UserVoice 项目:SSMS“导入平面文件”未能导入所有数据See UserVoice item for more details: SSMS Import Flat File fails to import all data.
Integration ServicesIntegration Services 为 SSIS 操作报表添加新的操作类型 StartNonCatalogExecutionAdd new operation type StartNonCatalogExecution for SSIS Operation report.
Integration ServicesIntegration Services 修复了 Azure 数据工厂管道中由 Azure 启用的实用工具 DTExec 导致的问题,以使用正确参数类型。Fixed an issue in the Azure Data Factory pipelines generated by Azure-enabled DTExec utility to use the correct parameter type. (18.3.1 明确了这一点)(explicit for 18.3.1)
SMO/脚本SMO/Scripting 修复了使用 SMO.Server.SetDefaultInitFields(true) 时导致 SMO 在提取属性时引发错误的问题。Fixed an issue, which was causing SMO to throw errors when fetching properties when SMO.Server.SetDefaultInitFields(true) was being used.
查询存储 UIQuery Store UI 修复了在“跟踪查询”视图中选择“执行计数”指标时 Y 轴无法缩放的问题 。Fixed an issue where the Y-axis didn't scale when Execution Count Metric was selected in Tracked Query View.
漏洞评估Vulnerability Assessment 禁用了 Azure SQL DB 的清除和批准基线。Disabled clearing and approving baseline for Azure SQL DBs.

已知问题 (18.3.1)Known issues (18.3.1)

  • 无法从计算机 B 修改通过在计算机 A 上运行的 SSMS 创建的数据库关系图(SSMS 崩溃)。Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.

  • 在多个查询窗口之间切换时会出现重绘问题。There are redraw issues when switching between multiple query windows. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details. 此问题的解决方法是在“工具”>“选项”下禁用硬件加速。A workaround for this issue is to disable hardware acceleration under Tools > Options.

可参考 UserVoice 了解其他已知问题,并向产品团队提供反馈。You can reference UserVoice for other known issues and to provide feedback to the product team.

18.218.2

下载 下载 SSMS 18.2download Download SSMS 18.2

  • 版本号:18.2Release number: 18.2
  • 生成号:15.0.18142.0Build number: 15.0.18142.0
  • 发行日期:2019 年 7 月 25 日Release date: July 25, 2019

中文(简体) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

18.2 是对 18.1 的更新,添加了以下新项并修复了以下 bug。18.2 is an update to 18.1 with the following new items and bug fixes.

18.2 的新增功能What's new in 18.2

新项New Item 详细信息Details
Integration Services (SSIS)Integration Services (SSIS) Azure 中 SSIS 包计划程序的性能优化。Perf optimization for SSIS package scheduler in Azure.
Intellisense/编辑器Intellisense/Editor 添加了对数据分类的支持。Added support for Data Classification.
OPTIMIZE_FOR_SEQUENTIAL_KEYOPTIMIZE_FOR_SEQUENTIAL_KEY 添加了 IntelliSense 支持。Added Intellisense support.
OPTIMIZE_FOR_SEQUENTIAL_KEYOPTIMIZE_FOR_SEQUENTIAL_KEY 可以在数据库引擎内启用优化,有助于提高索引中高并发插入的吞吐量。Turns on an optimization within the database engine that helps improve throughput for high-concurrency inserts into the index. 此选项旨在用于易发生最后一页插入争用的索引,常见于有顺序键(如标识列、序列或日期/时间列)的索引。This option is intended for indexes that are prone to last-page insert contention, typically seen with indexes that have a sequential key such as an identity column, sequence, or date/time column. 有关更多详细信息,请参阅 CREATE INDEXSee CREATE INDEX for more details.
查询执行或结果Query Execution or Results 在消息中添加了一个完成时间,以跟踪给定查询执行完毕的时间 。Added a Completion time in the messages to track when a given query completed its execution.
查询执行或结果Query Execution or Results 允许显示更多数据(结果转换为文本)以及将其存储在单元中(结果转换为网格)。Allow more data to be displayed (Result to Text) and stored in cells (Result to Grid). 对于这两种情况,SSMS 当前最多支持 200 万个字符(之前分别为 25.6 万和 6.4 万)。SSMS now allows up to 2M characters for both (up from 256 K and 64 K, respectively). 这还解决了用户无法从网格单元中获取超过 43680 个字符的问题。This also addressed the issue of users not able to grab more than 43680 chars from the cells of the grid.
显示计划ShowPlan 在启用了内联标量 UDF 特性 (ContainsInlineScalarTsqludfs) 的情况下,在 QueryPlan 中添加了新的属性。Added a new attribute in QueryPlan when inline scalar UDF feature is enabled (ContainsInlineScalarTsqludfs).
SMOSMO 添加了对 SQL 评估 API 的支持。Added support for SQL Assessment API. 有关详细信息,请参阅 SQL 评估 APIFor more information, see SQL Assessment API.

18.2 中的 bug 修复Bug fixes in 18.2

新项New Item 详细信息Details
可访问性Accessibility 更新了按 F3 时可排序的 XEvent UI(网格)。Updated the XEvent UI (the grid) to be sortable by pressing F3.
AlwaysOnAlways On 修复了在尝试删除可用性组 (AG) 时 SSMS 引发错误的问题Fixed an issue where SSMS was throwing an error when trying to delete an Availability Group (AG)
AlwaysOnAlways On 修复了将副本配置为“同步”、使用读取扩展 AG(群集类型 = NONE)时,SSMS 显示错误的故障转移向导的问题。Fixed an issue where SSMS was presenting the wrong failover wizard when replicas are configured as Synchronous when using read scale AGs (cluster type=NONE). 现在,SSMS 显示针对 Force_Failover_Allow_Data_Loss 选项的向导,这是群集类型 NONE 可用性唯一允许的向导Now, SSMS presents the wizard for Force_Failover_Allow_Data_Loss option, which is the only one allowed for cluster-type NONE Availability
AlwaysOnAlways On 修复了向导将允许的同步数限制为三个的问题Fixed an issue where the wizard was restricting the number of allowed synchronizations to three
数据分类Data Classification 修复了尝试查看 CompatLevel 级别低于 150 的数据库的数据分类报告时,SSMS 引发“索引(从零开始)必须大于或等于零”错误 。Fixed an issue where SSMS was throwing an Index (zero-based) must be greater than or equal to zero error when trying to view data classification reports on databases with CompatLevel less than 150.
常规 SSMSGeneral SSMS 修复了用户无法通过鼠标滚轮水平滚动结果窗格的问题。Fixed an issue where the user was unable to horizontal scroll Results pane via mouse wheel. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
常规 SSMSGeneral SSMS 更新了“活动监视器”,使其忽略良性等待类型 SQLTRACE_WAIT_ENTRIES Updated Activity Monitor to ignore benign wait types SQLTRACE_WAIT_ENTRIES
常规 SSMSGeneral SSMS 修复了某些颜色选项(“文本编辑器”>“编辑器”选项卡和状态栏)未持久化的问题 。Fixed an issue where some color options (Text Editor > Editor Tab and Status Bar) weren't persisted. 请参阅 UserVoiceSee UserVoice
常规 SSMSGeneral SSMS 在连接对话框中,将“Azure Active Directory - 含 MFA 支持的通用身份验证”替换为了“Azure Active Directory - 含 MFA 的通用身份验证”(功能相同,但希望能够减少混淆) 。In the connection dialog, replaced Azure Active Directory - Universal with MFA support with Azure Active Directory - Universal with MFA (functionality is the same, but hopefully it's less confusing).
常规 SSMSGeneral SSMS 更新了 SSMS,使其在创建 Azure SQL 数据库时使用正确的默认值。Updated SSMS to use correct default values when creating an Azure SQL Database.
常规 SSMSGeneral SSMS 修复了当服务器为 SQL Linux 容器时,用户无法从注册服务器中的节点启动 PowerShell 的问题 。Fixed an issue where the user wasn't able to Start PowerShell from a node in Register Servers when the server is a SQL Linux container.
导入平面文件Import Flat File 修复了从 SSMS 18.0 升级到 18.1 后,“导入平面文件”无法正常运行的问题 。Fixed an issue where Import Flat File wasn't working after upgrading from SSMS 18.0 to 18.1. 请参阅 UserVoiceSee UserVoice
导入平面文件Import Flat File 修复了标头包含 Unicode 字符的 .csv 文件中“导入平面文件向导报告重复或无效的列”的问题 。Fixed an issue where Import Flat File Wizard was reporting a duplicate or invalid column on a .csv file with headers with Unicode characters.
“对象资源管理器”Object Explorer 修复了在连接到 SQL Express 时,某些菜单项(例如 SQL Server“导入和导出向导”)缺失或禁用的问题 。Fixed an issue where some menu items (for example, SQL server Import and Export Wizard) were missing or disabled when connected to SQL Express. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
“对象资源管理器”Object Explorer 修复了将对象从对象资源管理器拖动到编辑器时导致 SSMS 故障的问题。Fixed an issue, which was causing SSMS to crash when an object is dragged from Object Explorer to the editor. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
“对象资源管理器”Object Explorer 修复了重命名数据库导致对象资源管理器中显示错误数据库名称的问题。Fixed an issue where renaming databases was causing incorrect database names to show up in Object Explorer. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
“对象资源管理器”Object Explorer 修复了一个长期未解决的问题,即对于设置为使用 Windows 不再支持的排序规则的数据库,尝试展开其对象资源管理器中的“表”节点时会触发错误(并且用户无法展开其表) 。Fixed a long outstanding issue where trying to expand the Tables node in Object Explorer for a database, which is set to use a collation that isn't supported by Windows anymore triggers an error (and the user can't expand their tables). 此类排序规则的一个示例是 Korean_Wansung_Unicode_CI_AS。An example of such collation would be Korean_Wansung_Unicode_CI_AS.
注册服务器Register Servers 修复了在注册服务器使用“Active Directory - 集成”或“Azure Active Directory - 含 MFA 的通用身份验证”的情况下,尝试针对多个服务器发出查询(在注册服务器的“组”下)因 SSMS 无法连接而无法正常工作的问题 。Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the Registered Server uses either Active Directory - Integrated or Azure Active Directory - Universal with MFA didn't work because SSMS failed to connect.
注册服务器Register Servers 修复了在注册服务器使用“Active Directory - 密码”或“SQL 身份验证”,且用户选择不记住密码的情况下,尝试针对多个服务器发出查询(在注册服务器的“组”下)可能导致 SSMS 故障的问题 。Fixed an issue where trying to issue a query against multiple servers (under a Group in Registered Servers) when the registered server uses either Active Directory - Password or SQL Auth and the user chose not to remember the password would cause SSMS to crash.
报表Reports 修复了“磁盘使用情况”报告中的问题,即当数据文件有大量盘区时,报告失败 。Fixed an issue in Disk Usage reports where the report was failing to when data files had a vast number of extents.
复制工具Replication Tools 修复了复制监视器无法与 AG 中的发布服务器数据库和分发服务器一起使用的问题(以前曾在 SSMS 17.x 中修复过此问题)Fixed an issue where Replication Monitor wasn't working with publisher DB in AG and distributor in AG (this was previously fixed in SSMS 17.x
SQL 代理SQL Agent 修复了在添加、插入、编辑或删除作业步骤时,焦点重置到第一行而不是活动行的问题。Fixed an issue that when Adding, inserting, editing, or removing job steps, was causing focus to be reset the first row instead of the active row. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SMO/脚本SMO/Scripting 修复了“CREATE OR ALTER”不对包含扩展属性的对象编写脚本的问题 。Fixed an issue where CREATE OR ALTER wasn't scripting objects that had extended properties on them. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SMO/脚本SMO/Scripting 修复了 SSMS 无法正确编写 CREATE EXTERNAL LIBRARY 的脚本的问题。Fixed an issue where SSMS wasn't able to script CREATE EXTERNAL LIBRARY correctly. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SMO/脚本SMO/Scripting 修复了尝试对包含几千个表的数据库运行“生成脚本”导致进度对话框似乎卡滞的问题 。Fixed an issue where trying to run the Generate Scripts against a database with a few thousand tables (was causing the progress dialog to appear to be stuck.
SMO/脚本SMO/Scripting 修复了 SQL 2019 中编写外部表的脚本不起作用的问题 。Fixed an issue where scripting of External Table on SQL 2019 didn't work.
SMO/脚本SMO/Scripting 修复了 SQL 2019 中编写外部数据源的脚本不起作用的问题 。Fixed an issue where scripting of External Data Source on SQL 2019 didn't work. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SMO/脚本SMO/Scripting 修复了面向 Azure SQL DB 时,未编写列扩展属性脚本的问题。**Fixed an issue where * extended properties* on columns weren't scripted when targeting Azure SQL DB. 有关更多详细信息,请参阅 stackoverflowSee stackoverflow for more details.
SMO/脚本SMO/Scripting 最后一页插入:SMO - 添加属性“Index.IsOptimizedForSequentialKey” Last-page insert: SMO - Add property Index.IsOptimizedForSequentialKey
SSMS 安装程序SSMS Setup 缓解了 SSMS 安装程序错误地阻止安装 SSMS 报告不匹配语言的问题。在某些异常情况下(例如中止的安装程序或错误地卸载以前的 SSMS 版本),这可能是一个问题。有关更多详细信息,请参阅 UserVoiceMitigated an issue where SSMS setup was incorrectly blocking the installation of SSMS reporting mismatching languages. This could have been an issue in some abnormal situations, like an aborted setup or an incorrect uninstall of a previous version of SSMS. See UserVoice for more details.
XEvent 探查器XEvent Profiler 修复了关闭查看器时出现的故障。Fixed a crash when the viewer is being closed.

已知问题 (18.2)Known issues (18.2)

  • 无从在计算机 B 中修改从在计算机 A 上运行的 SSMS 创建的数据库关系图(这会导致 SSMS 出现故障)。Database Diagram created from on an SSMS running on machine A cannot be modified from machine B (it would crash SSMS). 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.

  • 在多个查询窗口之间切换时会出现重绘问题。There are redraw issues when switching between multiple query windows. 请参阅 UserVoiceSee UserVoice. 此问题的解决方法是在“工具” > “选项” 下禁用硬件加速。A workaround for this issue is to disable hardware acceleration under Tools > Options.

  • 对于在网格、文本或文件中显示的 SSMS 结果中可以查看的数据大小,存在限制。There's a limitation on the size of the data you see from SSMS results shown in grid, text, or file.

  • 在对象资源管理器中删除 Azure SQL 数据库时接收错误出现问题,但实际上会成功接收。There's an issue with receiving an error when deleting an Azure SQL Database in Object Explorer, but it actually succeeds.

  • 不管登录名的实际默认语言设置如何,SQL 登录名的默认语言在“登录属性”对话框中都可能显示为阿拉伯语。The default language for SQL logins may display as Arabic in the Login Properties dialog, regardless of the actual default language set for the login. 若要查看给定登录名的实际默认语言,请使用 T-SQL 从 master.sys.server_principles 选择登录名的 default_language_name 。To view the actual default language for a given login, use T-SQL to select the login's default_language_name from master.sys.server_principles.

18.118.1

下载 下载 SSMS 18.1download Download SSMS 18.1

  • 版本号:18.1Release number: 18.1
  • 生成号:15.0.18131.0Build number: 15.0.18131.0
  • 发行日期:2019 年 6 月 11 日Release date: June 11, 2019

中文(简体) | 中文(繁体) | 英语(美国) | 法语 | 德语 | 意大利语 | 日语 | 朝鲜语 | 葡萄牙语(巴西) | 俄语 | 西班牙语Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

18.1 是对 18.0 的一个小更新,修复了以下新项和 bug。18.1 is a small update to 18.0 with the following new item and bug fixes.

18.1 的新增功能What's new in 18.1

新建项New item 详细信息Details
数据库关系图Database diagrams SSMS 中再现数据库关系图Database diagrams were added back into SSMS.
SSBDIAGNOSE.EXESSBDIAGNOSE.EXE SQL Server 诊断(命令行工具)已添加回 SSMS 包。The SQL Server Diagnose (command-line tool) was added back into the SSMS package.
Integration Services (SSIS)Integration Services (SSIS) 支持 Azure 中的计划 SSIS 包,该包位于 Azure 中的 SSIS 目录或系统文件中。Support for scheduling SSIS package, located in SSIS Catalog in Azure or File System, in Azure. 启动新建计划对话框中有三个项,新计划... There are three entries for launching the New Schedule dialog, New Schedule… 右键单击 Azure 中 SSIS 目录中的 SSIS 包时会显示菜单项,“在 Azure 中安排执行 SSIS 包”菜单项,位于“工具”菜单项下的“迁移到 Migrate”菜单项下,以及右键单击 Azure SQL 数据库托管实例中的 SQL Server 代理下的作业文件夹时显示的“在 Azure 中安排执行 SSIS” 。menu item is shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and "Schedule SSIS in Azure" shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Database managed instance.

18.1 中的 bug 修复Bug fixes in 18.1

新项New Item 详细信息Details
可访问性Accessibility 改进了代理作业 UI 的辅助功能。Improved accessibility of the Agent Job UI. ''
可访问性Accessibility 通过添加“自动刷新”按钮的可访问名称,同时添加智能可访问名称,该名称会帮助用户了解其按的是何按钮以及按下该按钮所产生的影响,从而改进了“Stretch 监视器”页面上的辅助功能 。Improved accessibility on the Stretch Monitor page by adding an accessible name for Auto Refresh button and also adding an intelligent Accessible Name that helps users know not only what button they're on but the impact of pressing it.
ADS 集成ADS integration 修复了尝试使用 ADS 注册服务器时 SSMS 可能出现崩溃的问题。Fixed a possible crash in SSMS when trying to use the ADS registered servers.
数据库设计器Database designer 添加了对 Latin1_General_100_BIN2_UTF8 排序规则的支持(在 SQL Server 2019 CTP3.0 中可用)Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL Server 2019 CTP3.0)
数据分类Data classification 防止将敏感度标签添加到历史记录表中的列,这是不受支持的。Prevent adding sensitivity labels to columns in the history table, which isn't supported.
数据分类Data classification 解决了有关错误处理兼容级别(服务器与数据库)的问题。Addressed issue related to incorrect handling of compatibility level (server vs. database).
数据库设计器Database designer 添加了对 Latin1_General_100_BIN2_UTF8 排序规则的支持(在 SQL2019 CTP3.0 中可用)。Added support for Latin1_General_100_BIN2_UTF8 collation (available in SQL2019 CTP3.0).
常规 SSMSGeneral SSMS 修复了以下问题:索引中伪列脚本不正确。Fixed an issue where scripting of pseudo columns in an index was incorrect.
常规 SSMSGeneral SSMS 修复了“登录属性”页面中的问题:单击“添加凭据”按钮可能会引发空引用异常 。Fixed an issue in the Login properties page where clicking on the Add Credential button could throw a Null Reference Exception.
常规 SSMSGeneral SSMS 修复了“索引属性”页面中显示的 money 列大小。Fixed money column size display in the index properties page.
常规 SSMSGeneral SSMS 修复了以下问题:在 SQL 编辑器窗口中,SSMS 未遵循“工具/选项”中的 Intellisense 设置 。Fixed an issue where SSMS wasn't honoring the Intellisense settings from Tools/Options in the SQL editor window.
常规 SSMSGeneral SSMS 修复了以下问题:SSMS 未遵循“帮助”设置(联机与脱机)。Fixed an issue where SSMS wasn't honoring the Help settings (online vs. offline).
高 DPIHigh DPI 修复了不受支持的查询选项的错误对话框中的控件布局。Fixed layout of controls in error dialogs for unsupported query options.
高 DPIHigh DPI 修复了 SSMS 的某些本地化版本上“新建可用性组”页面中控件的布局 。Fixed layout of controls in New Availability Group page, which is on some localized version of SSMS.
高 DPIHigh DPI 修复了“新建作业计划”页面的布局 。Fixed layout of New Job Schedule page. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
导入平面文件Import flat file 修复了以下问题:在导入期间,行可能会在无任何通知的情况下丢失。Fixed in an issue where rows could be silently lost during the import.
Intellisense/编辑器Intellisense/editor 减少了流向 IntelliSense 的 Azure SQL 数据库的基于 SMO 的查询流量。Reduced SMO-based query traffic to Azure SQL Databases for IntelliSense.
Intellisense/编辑器Intellisense/editor 修复了在键入 T-SQL 以创建用户时显示的工具提示中的语法错误。Fixed grammatical error in the tooltip displayed when typing T-SQL to create a user. 此外,修复了错误消息以区分用户和登录名。Also, fixed the error message to disambiguate between users and logins.
日志查看器Log Viewer 修复了以下问题:即使双击对象资源管理器中旧的存档符号,SSMS 也始终打开当前服务器(或代理)日志。Fixed an issue where SSMS always opens the current server (or agent) log, even if double-clicking an older archive sign in the Object Explorer. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SSMS 安装SSMS setup 修复了以下问题:当安装日志路径包含空格时导致 SSMS 安装失败。Fixed the issue that was causing SSMS setup to fail when the setup log path contained spaces. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SSMS 安装SSMS setup 修复了以下问题:SSMS 在显示初始屏幕后立即退出。Fixed an issue where SSMS was exiting immediately after showing the splash screen.
有关更多详细信息,请参阅以下站点:UserVoiceSSMS 拒绝启动数据库管理员See these sites for more details: UserVoice, SSMS Refuses to Start, and Database Administrators.
对象资源管理器Object explorer 解除了在 Linux 上连接到 SQL 时对“启用 PowerShell”的启用限制 。Lifted restriction on enabling start PowerShell when connected to SQL on Linux.
对象资源管理器Object explorer 修复了以下问题:在尝试展开 Polybase/横向扩展组节点时(连接到计算节点时)导致 SSMS 崩溃。Fixed an issue that was causing SSMS to crash when trying to expand the Polybase/Scale-out Group node (when connected to a compute node).
对象资源管理器Object explorer 修复了以下问题:即使在禁用给定索引后,“禁用”菜单项仍然处于启用状态 。Fixed an issue where the Disabled menu item was still enabled, even after disabling a given Index. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
报表Reports 将报表更正为以 KB 为单位显示 GrantedQueryMemory(SQL 性能仪表板报表)。Correcting report to display GrantedQueryMemory in KB (SQL Performance Dashboard report). 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
报表Reports 改进了对 Always-On 方案中日志块的跟踪。Improved the tracing of the log block in Always-On scenarios.
显示计划ShowPlan 在显示计划架构中添加了新的显示计划元素 SpillOccurred 。Added new showplan element SpillOccurred to showplan schema.
显示计划ShowPlan 向显示计划架构添加了远程读取(ActualPageServerReads、ActualPageServerReadAheads、ActualLobPageServerReads、ActualLobPageServerReadAheads) 。Added remote reads (ActualPageServerReads, ActualPageServerReadAheads ActualLobPageServerReads, ActualLobPageServerReadAheads) to showplan schema.
SMO/脚本SMO/scripting 避免在非图形表的脚本编写期间查询边缘约束。Avoid querying edge constraints during scripting for non-graph tables.
SMO/脚本SMO/scripting 删除了在使用数据分类编写列的脚本时,对敏感度分类的约束 。Removed constraint on sensitivity classification when scripting columns with Data classification.
SMO/脚本SMO/scripting 修复了以下问题:生成数据时图形表上的“生成脚本”失败。Fixed an issue where "Generate Script" on a graph table fails when generating data. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SMO/脚本SMO/scripting 修复了以下问题:EnumObjects() 方法无法获取同义词的架构名称。Fixed an issue where the EnumObjects() method wasn't fetching schema name for a Synonym.
SMO/脚本SMO/scripting 修复了以下问题:在 UIConnectionInfo.LoadFromStream() 中未读取 AdvancedOptions 部分(未指定密码时) 。Fixed an issue in UIConnectionInfo.LoadFromStream() where the AdvancedOptions section wasn't read (when a password wasn't specified).
SQL 代理SQL Agent 修复了以下问题:在使用“作业属性”窗口时导致 SSMS 崩溃。Fixed an issue that was causing SSMS to crash while working with a Job Properties window. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.
SQL 代理SQL Agent 修复了以下问题:“作业步骤属性”中的“查看”按钮不会始终处于启用状态,从而阻止查看给定作业步骤的输出 。Fixed an issue where the "View" button on the Job-Step Properties wasn't always enabled, thus preventing viewing the output of a given job step.
XEvent UIXEvent UI 在 XEvents 列表中添加了“Package”列,以区分具有相同名称的事件。Added "Package" column to XEvents list to disambiguate events with identical names.
XEvent UIXEvent UI 向 XEventUI 添加了缺少的“EXTERNAL LIBRARY”类类型映射。Added missing "EXTERNAL LIBRARY" class type mapping to XEventUI.

已知问题 (18.1)Known issues (18.1)

  • 用户在将对象资源管理器中的表对象拖动到查询编辑器时可能收到错误。Users may see an error when dragging a table object from the Object Explorer into the Query Editor. 我们已注意到此问题并计划在下一版本中提供修补程序。We are aware of the issue, and the fix is planned for the next release.

  • 关闭 SSMS 18.1 之后,“选项”->“文本编辑器”->“编辑器选项卡”和“状态栏”->“状态栏布局和颜色”下的“组连接”和“单服务器连接”颜色选项将消失 。The Group connections and Single-server connections color options under the Options -> Text Editor -> Editor Tab and Status Bar -> Status Bar Layout and Colors do not persist after closing SSMS 18.1. 重新打开 SSMS 后,“状态栏布局和颜色”选项会还原为默认设置(白色)。After you reopen SSMS, the Status Bar Layout and Colors option revert to default (white).

  • 对于在网格、文本或文件中显示的 SSMS 结果中可以查看的数据大小,存在限制。There is a limitation on the size of the data you see from SSMS results shown in the grid, text, or file.

  • 无法从计算机 B 修改通过在计算机 A 上运行的 SSMS 创建的数据库关系图(SSMS 崩溃)。Database Diagram created from SSMS running on machine A cannot be modified from machine B (SSMS crashes). 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details.

18.018.0

下载 下载 SSMS 18.0download Download SSMS 18.0

  • 版本号:18.0Release number: 18.0
  • 生成号:15.0.18118.0Build number: 15.0.18118.0
  • 发行日期:2019 年 4 月 24 日Release date: April 24, 2019

中文(简体)| 中文(繁体)| 英语(美国)| 法语| 德语| 意大利语| 日语| 朝鲜语| 葡萄牙语(巴西)| 俄语| 西班牙语Chinese (Simplified)| Chinese (Traditional)| English (United States)| French| German| Italian| Japanese| Korean| Portuguese (Brazil)| Russian| Spanish

18.0 的新增功能What's new in 18.0

新建项New item 详细信息Details
支持 SQL Server 2019Support for SQL Server 2019 SSMS 18.0 是第一个可以完全识别 SQL Server 2019 (compatLevel 150) 的版本 。SSMS 18.0 is the first release that is fully aware of SQL Server 2019 (compatLevel 150).
支持 SQL Server 2019Support for SQL Server 2019 支持 SQL Server 2019 和 SQL 托管实例中的“BATCH_STARTED_GROUP”和“BATCH_COMPLETED_GROUP”。Support for "BATCH_STARTED_GROUP" and "BATCH_COMPLETED_GROUP" in SQL Server 2019 and SQL managed instance.
支持 SQL Server 2019Support for SQL Server 2019 SMO:添加了对 UDF 内联的支持。SMO: Added support for UDF Inlining.
支持 SQL Server 2019Support for SQL Server 2019 GraphDB:在 Graph TC 序列的显示计划中添加标志。GraphDB: Add a flag in showplan for Graph TC Sequence.
支持 SQL Server 2019Support for SQL Server 2019 Always Encrypted:添加了对 AEv2/Enclave 的支持。Always Encrypted: added support for AEv2 / Enclave.
支持 SQL Server 2019Support for SQL Server 2019 Always Encrypted:用户单击“选项”按钮以启用/配置 Enclave 支持时,连接对话框将显示新的“Always Encrypted”选项卡。Always Encrypted: connection dialog has a new tab "Always Encrypted" when the user clicks on the "Options" button to enable/configure Enclave support.
减小了 SSMS 下载大小Smaller SSMS download size 当前大小约为 500 MB,约为 SSMS 17.x 捆绑包的一半。The current size is ~500 MB, approximately half of the SSMS 17.x bundle.
SSMS 基于 Visual Studio 2017 独立 ShellSSMS is based on the Visual Studio 2017 Isolated Shell 新的 shell(SSMS 基于 Visual Studio 2017 15.9.11)解锁了 SSMS 和 Visual Studio 中的所有辅助功能修复程序,并包含最新的安全修复程序。The new shell (SSMS is based on Visual Studio 2017 15.9.11) unlocks all the accessibility fixes that went into both SSMS and Visual Studio, and includes the latest security fixes.
SSMS 辅助功能改进SSMS accessibility improvements 我们进行了大量的工作以解决所有工具(SSMS、DTA 和探查器)中的辅助功能问题Much work went in to address accessibility issues in all the tools (SSMS, DTA, and Profiler)
SSMS 现可安装在自定义文件夹中SSMS can now be installed in a custom folder 此选项在命令行(适用于无人参与安装)和设置 UI 中均可用。This option is available from both the command line (useful for unattended installation) and the setup UI. 从命令行中,将此额外参数传递给 SSMS-Setup-ENU.exe: SSMSInstallRoot=C:\MySSMS18 默认情况下,SSMS 的新安装位置为:%ProgramFiles(x86)%\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exe。From the command line, pass this extra argument to the SSMS-Setup-ENU.exe: SSMSInstallRoot=C:\MySSMS18 By default, the new install location for SSMS is: %ProgramFiles(x86)%\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exe. 这并不意味着 SSMS 为多实例。This does not mean that SSMS is multi-instance.
SSMS 允许使用 OS 语言以外的其他语言进行安装SSMS allows installing in a language other than the OS language 已解除阻止混合语言设置。The block on mixed languages setup has been lifted. 例如,可以在法语版 Windows 上安装 SSMS 德语版。You can, for example, install SSMS German on a French Windows. 如果 OS 语言与 SSMS 语言不匹配,则用户需要通过“工具” > “选项” > “国际设置”更改语言,否则 SSMS 会显示英语 UI 。If the OS language does not match the SSMS language, the user needs to change the language under Tools > Options > International Settings, otherwise SSMS shows the English UI.
SSMS 与 SQL 引擎不再共享组件SSMS no longer shares components with the SQL Engine 我们为避免与 SQL 引擎共享组件付出了大量努力,共享组件通常会导致可维护性问题(一方强制改写另一方安装的文件)。Much effort went in to avoid sharing components with SQL Engine, which often resulted in serviceability issues (one clobbering the files installed by the other).
SSMS 需要 NetFx 4.7.2 或更高版本SSMS requires NetFx 4.7.2 or greater 我们将最低要求从 NetFx4.6.1 升级到 NetFx4.7.2:这让我们能够利用新框架公开的新功能。We upgraded our minimum requirement from NetFx4.6.1 to NetFx4.7.2: this allows us to take advantage of the new functionality exposed by the new framework.
迁移 SSMS 设置的功能Ability to migrate SSMS settings 当 SSMS 18 首次启动时,系统会提示用户迁移 17.x 设置。When SSMS 18 is started for the first time, the user is prompted to migrate the 17.x settings. 用户设置文件现存储为纯 XML 文件,从而提高了可移植性并且可能允许编辑。The user setting files are now stored as a plain XML file, thus improving portability and possibly allowing editing.
支持高 DPISupport for High DPI 现默认启用高 DPI。High DPI is now enabled by default.
SSMS 附带 Microsoft OLE DB 驱动程序SSMS ships with the Microsoft OLE DB driver 有关详细信息,请参阅下载适用于 SQL Server 的 Microsoft OLE DB 驱动程序For details, see Download Microsoft OLE DB Driver for SQL Server.
Windows 8 不支持 SSMS。SSMS isn't supported on Windows 8. Windows 10 和 Windows Server 2016 需要 1607 (10.0.14393) 或更高版本Windows 10 and Windows Server 2016 require version 1607 (10.0.14393) or later 由于 NetFx 4.7.2 上新的依赖项,SSMS 18.0 不会安装在 Windows 8、较旧版本的 Windows 10 和 Windows Server 2016 上。Due to the new dependency on NetFx 4.7.2, SSMS 18.0 does not install on Windows 8 and older versions of Windows 10 and Windows Server 2016. SSMS 安装程序会阻止这些系统。SSMS setup blocks those systems. 仍然支持 Windows 8.1。Windows 8.1 is still supported.
SSMS 不再添加到 PATH 环境变量SSMS is no longer added to the PATH environment variable SSMS.EXE 的路径(以及常规工具)不再添加到路径中。Path to SSMS.EXE (and tools in general) isn't added to the path anymore. 用户可以手动添加它,也可以在新式 Windows 计算机上使用“开始”菜单添加。Users can either manually add it, or if on a modern Windows computer, use on the Start menu.
不再需要包 ID 来开发 SSMS 扩展Package IDs are no longer needed to develop SSMS Extensions 以前 SSMS 仅选择性地加载已知包,因此需要开发人员注册其自己的包。In the past, SSMS was selectively loading only well-known packages, thus requiring developers to register their own package. 这种情况不会再出现。This is no longer the case.
常规 SSMSGeneral SSMS 在 SSMS 中公开文件组的 AUTOGROW_ALL_FILES 配置选项。Exposing AUTOGROW_ALL_FILES config option for Filegroups in SSMS.
常规 SSMSGeneral SSMS 从 SSMS GUI 中删除了有风险的“轻型池”和“优先级提升”选项。Removed risky 'lightweight pooling' and 'priority boost' options from SSMS GUI. 有关详细信息,请参阅优先级提升详细信息 - 以及不建议这样做的原因For details, see Priority boost details – and why it's not recommended.
常规 SSMSGeneral SSMS 用于创建文件的新建菜单和键绑定:Ctrl+Alt+N 。New menu and key bindings to creates files: CTRL+ALT+N. CTRL + N 继续创建一个新查询 。CTRL+N continues to create a new query.
常规 SSMSGeneral SSMS 用户现在可以使用“新防火墙规则”对话框指定规则名称,而不是代表用户自动生成一个规则名称 。New Firewall Rule dialog now allows the user to specify a rule name, instead of automatically generating one on behalf of the user.
常规 SSMSGeneral SSMS 特别针对 v140+ T-SQL 改进了编辑器中的 IntelliSense。Improved IntelliSense in Editor especially for v140+ T-SQL.
常规 SSMSGeneral SSMS 在 SSMS UI 中的排序规则对话框上为 UTF-8 添加了支持。Added support in SSMS UI for UTF-8 on collation dialog.
常规 SSMSGeneral SSMS 为连接对话框 MRU 密码切换到了“Windows 凭据管理器”。Switched to "Windows Credential Manager" for connection dialog MRU passwords. 这将解决一个长期未解决的问题,即密码的持久性并非始终可靠。This addresses a long outstanding issue where persistence of passwords wasn't always reliable.
常规 SSMSGeneral SSMS 通过确保在预期监视器上弹出越来越多的对话框和窗口,改进了对多监视器系统的支持。Improved support for multi-monitor systems by making sure that more and more dialogs and windows pop up on the expected monitor.
常规 SSMSGeneral SSMS 在“服务器属性”对话框的“新建数据库设置”页中公开了“备份校验和默认”服务器配置。Exposed the 'backup checksum default' server configuration in the new Database Settings page of the Server Properties Dialog. 有关详细信息,请参阅 https://feedback.azure.com/forums/08035-sql-server/suggestions/34634974For details, see https://feedback.azure.com/forums/08035-sql-server/suggestions/34634974.
常规 SSMSGeneral SSMS 在“配置 SQL Server 错误日志”下公开了“错误日志文件的最大大小”。Exposed "maximum size for error log files" under "Configure SQL Server Error Logs". 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/33624115For details, see https://feedback.azure.com/forums/908035/suggestions/33624115.
常规 SSMSGeneral SSMS 在“工具”菜单下添加了“迁移到 Azure”– 我们集成了数据库迁移助手和 Azure 数据库迁移服务,提供快速便捷的访问,帮助加快迁移到 Azure 的过程。Added "Migrate to Azure" under Tools menu – We have integrated Database Migration Assistant and Azure Database Migration Service to provide quick and easy access to help accelerate your migrations to Azure.
常规 SSMSGeneral SSMS 添加了逻辑,提示用户在使用“更改连接”时提交打开的事务。Added logic to prompt the user to commit open transactions when "Change connection" is used.
Azure Data Studio 集成Azure Data Studio integration 添加了启动/下载 Azure Data Studio 的菜单项。Added menu item to start/download Azure Data Studio.
Azure Data Studio 集成Azure Data Studio integration 向对象资源管理器添加了“启动 Azure Data Studio”菜单项。Added "Start Azure Data Studio" menu item to Object Explorer.
Azure Data Studio 集成Azure Data Studio integration 右键单击 OE 中的数据库节点时,将向用户显示上下文菜单,以在 Azure Data Studio 中运行查询或创建新笔记本。When right-clicking on a database node in OE, the user is presented with context menus to either run a query or create a new notebook in Azure Data Studio.
Azure SQL 支持Azure SQL support SLO/Edition/MaxSize 数据库属性现在接受自定义名称,方便支持 Azure SQL 数据库的未来版本。SLO/Edition/MaxSize database properties now accept custom names, making it easier to support future editions of Azure SQL Databases.
Azure SQL 支持Azure SQL support 添加了对 vCore SKU(常规用途和业务关键)的支持:Gen4_24 和所有 Gen5。Added support for vCore SKUs (General Purpose and Business Critical): Gen4_24 and all the Gen5.
Azure SQL 托管实例Azure SQL managed instance 连接到 Azure SQL 托管实例时,在 SMO 和 SSMS 中添加了新的“AAD 登录”作为新登录类型。Added new "AAD logins" as a new login type in SMO and SSMS when connected to an Azure SQL managed instance.
AlwaysOnAlways On 在 SSMS Always On 仪表板中重新处理 RTO(估计恢复时间)和 RPO(估计的数据丢失)。Rehash RTO (estimated recovery time) and RPO (estimated data loss) in SSMS Always on Dashboard. 请参阅 https://docs.microsoft.com/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups 中更新后的文档。See the updated documentation at https://docs.microsoft.com/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups.
Always EncryptedAlways Encrypted “连接到服务器”对话框中新“Always Encrypted”选项卡的“启用 Always Encrypted”复选框现在提供为数据库连接启用/禁用 Always Encrypted 的简便方法。The Enable Always Encrypted checkbox in the new Always Encrypted tab in the Connect to Server dialog now provides an easy way to enable/disable Always Encrypted for a database connection.
具有安全 Enclave 的 Always EncryptedAlways Encrypted with secure enclaves 已在 SQL Server 2019 中进行多项增强来支持具有安全 Enclave 的 Always Encrypted:“连接到服务器”对话框(新的“Always Encrypted”选项卡)中指定 Enclave 证明 URL 的文本字段。Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019: A text field for specifying enclave attestation URL in the Connect to Server dialog (the new Always Encrypted tab). “新列主密钥”对话框中用于控制新列主密钥是否允许 Enclave 计算的新复选框。The new checkbox in the New Column Master Key dialog to control whether a new column master key allows enclave computations. 其他 Always Encrypted 密钥管理对话框现在可公开列主密钥允许 Enclave 计算的信息。Other Always Encrypted key management dialogs now expose the information on which column master keys allow enclave computations.
审核文件Audit Files 已将身份验证方法从基于存储帐户密钥更改为基于 Azure AD 的身份验证。Changed authentication method from Storage Account Key based to Azure AD-based authentication.
数据分类Data Classification 重新组织了数据分类任务菜单:将子菜单添加到了数据库任务菜单中,并添加了从菜单中打开报表而无需先打开分类数据窗口的选项。Reorganized data classification task menu: added sub menu to the database tasks menu and added an option to open the report from the menu without opening the classify data window first.
数据分类Data Classification 向 SMO 添加了新功能“数据分类”。Added new feature 'Data classification' to SMO. 列对象公开新属性:SensitivityLabelName、SensitivityLabelId、SensitivityInformationTypeName、SensitivityInformationTypeId 和 IsClassified(只读)。Column object exposes new properties: SensitivityLabelName, SensitivityLabelId, SensitivityInformationTypeName, SensitivityInformationTypeId, and IsClassified (read-only). 有关详细信息,请参阅 ADD SENSITIVITY CLASSIFICATION (Transact-SQL)For more information, see ADD SENSITIVITY CLASSIFICATION (Transact-SQL)
数据分类Data Classification 向“数据分类”浮出控件添加了新的“分类报表”菜单项。Added new "Classification Report" menu item to the "Data Classification" flyout.
数据分类Data Classification 更新了建议。Updated recommendations.
数据库兼容性级别升级Database Compatibility Level Upgrade 在“数据库名称” > “任务” > “数据库升级”下添加了一个新选项。Added a new option under Database name > Tasks > Database Upgrade. 此选项将启动新的查询优化助手 (QTA),引导用户完成以下过程 :在升级数据库兼容性级别之前,收集性能基线。This starts the new Query Tuning Assistant (QTA) to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level. 升级到所需数据库兼容性级别。Upgrading to the desired database compatibility level. 对同一工作负荷收集第二轮性能数据。Collecting a second pass of performance data over the same workload. 检测工作负荷回归并提供测试建议,以提高工作负荷性能。Detect workload regressions, and provide tested recommendations to improve workload performance. 这类似于在查询存储使用方案中记录的数据库升级过程,最后一步(QTA 不依赖之前已知的良好状态来生成建议)除外。This is close to the database upgrade process documented in query store usage scenarios, except for the last step where QTA does not rely on a previously known good state to generate recommendations.
数据层应用程序向导Data-tier Application Wizard 添加了对使用图形表导入/导出数据层应用程序的支持。Added support to Import/Export data-tier application with graph tables.
平面文件导入向导Flat File Import Wizard 添加了用于通知用户导入可能已导致列重命名的逻辑。Added logic to notify the user that an import may have resulted in a renaming of the columns.
Integration Services (SSIS)Integration Services (SSIS) 添加了支持,使客户能够在 Azure 政府云中的 Azure-SSIS IR 上安排 SSIS 包。Added support to allow customers to schedule SSIS packages on Azure-SSIS IRs that are in Azure Government cloud.
Integration Services (SSIS)Integration Services (SSIS) 通过 SSMS 使用 Azure SQL 托管实例的 SQL 代理时,可以在 SSIS 代理作业步骤中配置参数和连接管理器。When you use SQL Agent of Azure SQL managed instance via SSMS, you can configure parameter and connection manager in SSIS agent job step.
Integration Services (SSIS)Integration Services (SSIS) 连接到 Azure SQL DB/托管实例时,可以使用“default”作为初始数据库与它进行连接 。When connecting to Azure SQL DB/managed instance, you can connect to it with default as initial db.
Integration Services (SSIS)Integration Services (SSIS) 在“Integration Services 目录”节点下添加了“在 Azure 数据工厂中尝试 SSIS”的新条目项,此条目项可用于启动“Integration Runtime 创建向导”并快速创建“Azure-SSIS Integration Runtime” 。Added a new entry item Try SSIS in Azure Data Factory under "Integration Services Catalogs" node, which can be used to launch the "Integration Runtime Creation Wizard" and create "Azure-SSIS Integration Runtime" quickly.
Integration Services (SSIS)Integration Services (SSIS) 在目录创建向导中添加了“创建 SSIS IR”按钮,该按钮可用于启动“Integration Runtime 创建向导”并快速创建“Azure-SSIS Integration Runtime” 。Added Create SSIS IR button in "Catalog Creation Wizard," which can be used to launch the "Integration Runtime Creation Wizard" and create "Azure-SSIS Integration Runtime" quickly.
Integration Services (SSIS)Integration Services (SSIS) ISDeploymentWizard 现支持命令行模式下的 SQL 身份验证、Azure Active Directory 集成身份验证和 Azure Active Directory 密码身份验证。ISDeploymentWizard now supports SQL Auth, Azure Active Directory Integrated Auth, and Azure Active Directory Password Auth in command-line mode.
Integration Services (SSIS)Integration Services (SSIS) 部署向导现支持创建和部署到 Azure 数据工厂 SSIS Integration Runtime。Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS Integration Runtime.
对象脚本Object Scripting 编写对象脚本时,为“CREATE OR ALTER”添加了新的菜单项。Add new menu items for "CREATE OR ALTER" when scripting objects.
查询存储Query Store 向图表 Y 轴上显示的数字添加千位分隔符,改善了部分报表(资源总消耗)的可用性。Improved usability of some reports (Overall Resource Consumptions) by adding thousands of separators to numbers displayed on the Y-axis of the charts.
查询存储Query Store 添加了新的查询等待统计信息报表。Added a new Query Wait Statistics report.
查询存储Query Store 在“跟踪查询”视图中添加了“执行计数”指标。Added "Execution Count" metric to "Tracked Query" View.
复制工具Replication Tools 在复制监视器和 SSMS 中添加了对非默认端口规范功能的支持。Added support for non-default port specification feature in Replication Monitor and SSMS.
显示计划ShowPlan 如果可用,则在显示计划运算符节点下添加实际运行时间、实际行与估计行。Added actual time elapsed, actual vs. estimated rows under ShowPlan operator node if they're available. 这使实际计划看起来与实时查询统计信息计划一致。This makes the actual plan look consistent with Live Query Stats plan.
显示计划ShowPlan 为显示计划单击“编辑查询”按钮时修改了工具提示并添加了注释,以向用户表明如果查询超过 4000 个字符,则 SQL 引擎可能会截断该显示计划。Modified tooltip and added comment when clicking on Edit Query Button for a ShowPlan, to indicate to user that the ShowPlan might be truncated by the SQL engine if the query is over 4000 characters.
显示计划ShowPlan 添加了显示“Materializer 运算符(外部选择)”的逻辑。Added logic to display the "Materializer Operator (External Select)".
显示计划ShowPlan 添加新的显示计划属性 BatchModeOnRowStoreUsed 以轻松识别正在使用“行存储的批处理模式扫描”功能的查询。Add new showplan attribute BatchModeOnRowStoreUsed to easily identify queries that are using the " batch-mode scan on rowstores" feature. 每当查询执行行存储的批处理模式扫描时,都会将新属性 (BatchModeOnRowStoreUsed="true") 添加到 StmtSimple 元素。Anytime a query performs batch-mode scan on rowstores, a new attribute (BatchModeOnRowStoreUsed="true") gets added to StmtSimple element.
显示计划ShowPlan 为 DW ROLLUP 和 CUBE 添加了对 LocalCube RelOp 的显示计划支持。Added Showplan Support to LocalCube RelOp for DW ROLLUP and CUBE.
显示计划ShowPlan 适用于 Azure SQL 数据仓库中新的 ROLLUP 和 CUBE 聚合功能的新 LocalCube 运算符。New LocalCube operator for the new ROLLUP and CUBE aggregation feature in Azure SQL Data Warehouse.
SMOSMO 为可恢复索引创建扩展 SMO 支持。Extend SMO Support for Resumable Index Creation.
SMOSMO 在 SMO 对象(“PropertyMissing”)上添加了新事件以帮助应用程序作者更快地检测 SMO 性能问题。Added new event on SMO objects ("PropertyMissing") to help application authors to detect SMO performance issues sooner.
SMOSMO 公开了 Configuration 对象上新的 DefaultBackupChecksum 属性,该属性映射到“备份校验和默认值”服务器配置。Exposed new DefaultBackupChecksum property on the Configuration object, which maps to the "backup checksum default" server configuration.
SMOSMO 公开了 Server 对象上新的 ProductUpdateLevel 属性,该属性映射到正在使用的 SQL 版本(例如 CU12 和 RTM)的服务级别上。Exposed new ProductUpdateLevel property on the Server object, which maps to the servicing level for the version of SQL in use (for example, CU12, RTM).
SMOSMO 公开了 Database 对象上新的 LastGoodCheckDbTime 属性,该属性映射到“lastgoodcheckdbtime”数据库属性上。Exposed new LastGoodCheckDbTime property on Database object, which maps to "lastgoodcheckdbtime" database property. 如果该属性不可用,则返回默认值“1900/1/1 凌晨 12:00:00”。If such property isn't available, a default value of 1/1/1900 12:00:00 AM is be returned.
SMOSMO 将 RegSrvr.xml 文件(注册服务器配置文件)的位置移动到了“%AppData%\Microsoft\SQL Server Management Studio”(未进行版本控制,因此可以跨 SSMS 版本共享)。Moved location for RegSrvr.xml file (Registered Server configuration file) to "%AppData%\Microsoft\SQL Server Management Studio" (unversioned, so it can be shared across versions of SSMS).
SMOSMO 添加了“云见证”作为新的仲裁类型,以及作为新的资源类型。Added "Cloud Witness" as a new quorum type and as a new resource ty'e.
SMOSMO 在 SMO 和 SSMS 中添加了对“边缘约束”的支持。Added support for "Edge Constraints" in both SMO and SSMS.
SMOSMO 同时在 SMO 和 SSMS 中为“边缘约束”添加了级联删除。Added cascade delete support to "Edge Constraints" in both SMO and SSMS.
SMOSMO 添加了对数据分类“读写”权限的支持。Added support for data classification "read-write" permissions.
漏洞评估Vulnerability Assessment 在 Azure SQL DW 上启用了漏洞评估任务菜单。Enabled Vulnerability Assessment tasks menu on Azure SQL DW.
漏洞评估Vulnerability Assessment 更改了在 Azure SQL 托管实例服务器上运行的漏洞评估规则集,以便“漏洞评估”扫描结果与 Azure SQL DB 中的保持一致。Change the set of vulnerability assessment rules that are run on Azure SQL managed instance servers, so that "Vulnerability Assessment" scan results can be consistent with the ones in Azure SQL DB.
漏洞评估Vulnerability Assessment “漏洞评估”现在支持 Azure SQL DW。"Vulnerability Assessment" now supports Azure SQL DW.
漏洞评估Vulnerability Assessment 添加了新的导出功能,以将漏洞评估扫描结果导出为 Excel。Added a new exporting feature to export the vulnerability assessment scan results to Excel.
XEvent 查看器XEvent Viewer XEvent 查看器:启用了显示计划窗口以获取更多 XEvent。XEvent Viewer: enabled showplan window for more XEvents.

18.0 中的 bug 修复Bug fixes in 18.0

新建项New item 详细信息Details
故障与冻结Crashes and freezes 修复了与 GDI 对象相关的常见 SSMS 故障源。Fixed a source of common SSMS crashes related to GDI objects.
故障与冻结Crashes and freezes 修复了选择"脚本作为创建/更新/删除"(已删除 SMO 对象的不必要提取)时挂起和性能不佳的一个常见源。Fixed a common source of hangs and poor performance when selecting "Script as Create/Update/Drop" (removed unnecessary fetches of SMO objects).
故障与冻结Crashes and freezes 修复了在启用 ADAL 跟踪期间使用 MFA 连接到 Azure SQL DB 时的挂起现象。Fixed a hang when connecting to an Azure SQL DB using MFA while ADAL traces are enabled.
故障与冻结Crashes and freezes 修复了从活动监视器中调用时实时查询统计信息中的挂起(或感知到的挂起)(在使用 SQL Server 身份验证但未设置“持久性安全信息”时显示的问题)。Fixed a hang (or perceived hang) in Live Query Statistics when invoked from Activity Monitor (the issue manifested when using SQL Server authentication with no "Persist Security Info" set).
故障与冻结Crashes and freezes 修复了在对象资源管理器中选择“报表”时可能表现在高延迟连接或资源的临时不可访问性上的挂起。Fixed a hang when selecting "Reports" in Object Explorer, which could manifest on high latency connections or temporary non-accessibility of the resources.
故障与冻结Crashes and freezes 修复了尝试使用中央管理服务器和 Azure SQL Server 时 SSMS 中出现的故障。Fixed a crash in SSMS when trying to use Central Management Server and Azure SQL servers. 有关详细信息,请参阅使用中央管理服务器时 SMSS 17.5 应用程序出现错误和故障For details, see SMSS 17.5 application error and crash when using Central Management Server.
故障与冻结Crashes and freezes 通过优化检索 IsFullTextEnabled 属性的方式,修复了对象资源管理器中的挂起现象。Fixed a hang in Object Explorer by optimizing the way IsFullTextEnabled property is retrieved.
故障与冻结Crashes and freezes 通过避免生成检索数据库属性的不必要查询,修复了“复制数据库向导”中的挂起现象。Fixed a hang in "Copy Database Wizard" by avoiding to build unnecessary queries to retrieve Database properties.
故障与冻结Crashes and freezes 修复了编辑 T-SQL 时导致 SSMS 挂起/故障的问题。Fixed an issue that was causing SSMS to hang/crash while editing T-SQL.
故障与冻结Crashes and freezes 缓解了编辑大型 T-SQL 脚本时 SSMS 变得无响应的问题。Mitigated an issue where SSMS was becoming unresponsive when editing large T-SQL scripts.
故障与冻结Crashes and freezes 修复了处理查询返回的大数据集时 SSMS 内存不足的问题。Fixed an issue that was causing SSMS to run out of memory when handling the large datasets returned by queries.
常规 SSMSGeneral SSMS 修复了“已注册服务器”的连接中未传递“ApplicationIntent”的问题。Fixed an issue there the "ApplicationIntent" wasn't passed along in connections in "Registered Servers".
常规 SSMSGeneral SSMS 修复了在高 DPI 监视器上未正确呈现“新 XEvent 会话向导 UI”表单的问题。Fixed an issue where the "New XEvent Session Wizard UI" form wasn't rendered properly on High DPI monitors.
常规 SSMSGeneral SSMS 修复了尝试导入 bacpac 文件的问题。Fixed an issue where trying to import a bacpac file.
常规 SSMSGeneral SSMS 修复了尝试显示数据库 (FILEGROWTH > 2048 GB) 属性时引发算术溢出错误的问题。Fixed an issue where trying to display the properties of a database (with FILEGROWTH > 2048 GB) was throwing an arithmetic overflow error.
常规 SSMSGeneral SSMS 解决了性能仪表板报表报告在子报表中找不到 PAGELATCH 和 PAGEIOLATCH 等待的问题。Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that couldn't found in subreports.
常规 SSMSGeneral SSMS 另一轮修复,通过在正确的监视器中打开对话框,使 SSMS 能更好地识别多监视器。Another round of fixes to make SSMS more multi-monitor aware by having it open dialog in the correct monitor.
Analysis Services (AS)Analysis Services (AS) 修复了 AS Xevent UI 的“高级设置”被剪辑的问题。Fixed an issue where the "Advanced Settings" to the AS XEvent UI was clipped.
Analysis Services (AS)Analysis Services (AS) 修复了 DAX 分析引发“找不到文件”异常这一问题。Fixed an issue where DAX parsing throws file not found exception.
Azure SQL DatabaseAzure SQL Database 修复了连接到 Azure SQL 数据库中的用户数据库而不是主数据库时,Azure SQL 数据库查询窗口中未正确填充数据库列表的问题。Fixed an issue where the database list wasn't populated correctly for Azure SQL Database query window when connected to a user database in Azure SQL DB instead of to master.
Azure SQL DatabaseAzure SQL Database 修复了无法向 Azure SQL 数据库添加“时态表”的问题。Fixed an issue where it wasn't possible to add a "Temporal Table" to an Azure SQL Database.
Azure SQL DatabaseAzure SQL Database 在 Azure 的菜单统计信息下启用了“统计信息属性”子菜单选项,因为它已受到相当长一段时间的完全支持。Enabled the Statistics properties sub menu option under menu Statistics in Azure, since it has been fully supported for quite some time now.
Azure SQL - 常规支持Azure SQL - General Support 修复了阻止用户显示 Azure 订阅(如果存在超出 50 个)的常用 Azure UI 控件中的问题。Fixed issues in common Azure UI control that was preventing the user from displaying Azure subscriptions (if there were more than 50). 此外,排序已更改为按名称而不是按订阅 ID。Also, the sorting has been changed to be by name rather by Subscription ID. 例如,尝试从 URL 还原备份时,用户可能会遇到此情况。The user could run into this one when trying to restore a backup from URL, for example.
Azure SQL - 常规支持Azure SQL - General Support 修复了在常用 Azure UI 控件中枚举订阅时可能会引发“索引已超出范围”的问题。Fixed an issue in common Azure UI control when enumerating subscriptions, which could yield an "Index was out of range. 必须为非负数且小于集合大小。”Must be non-negative and less than the size of the collection." 错误的订阅时常用 Azure UI 控件中的问题。error when the user had no subscriptions in some tenants. 例如,尝试从 URL 还原备份时,用户可能会遇到此情况。The user could run into this one when trying to restore a backup from URL, for example.
Azure SQL - 常规支持Azure SQL - General Support 解决了服务级别目标被硬编码使得 SSMS 难以支持更新版 Azure SQL SLO 的问题。Fixed issue where Service Level Objectives were hardcoded, thus making it harder for SSMS to support newer Azure SQL SLOs. 现在,用户可以登录 Azure 并允许 SSMS 检索所有适用的 SLO 数据(版本和最大大小)Now, the user can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size)
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 改进/优化了对托管实例的支持:已禁用 UI 中不支持的选项和用于处理 URL 审核目标的“查看审核日志”选项的修复。Improved/polished the support for managed instances: disabled unsupported options in UI and a fix to the View Audit Logs option to handle URL audit target.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support “生成和发布脚本”向导脚本不支持的 CREATE DATABASE 子句。"Generate and Publish scripts" wizard scripts unsupported CREATE DATABASE clauses.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 为托管实例启用了实时查询统计信息。Enable Live Query Statistics for managed instances.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 数据库属性 -> 文件错误编写了 ALTER DB ADD FILE 脚本。Database properties->Files was incorrectly scripting ALTER DB ADD FILE.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了即使选择某些其他计划类型时仍选择 ONIDLE 计划的 SQL 代理计划程序的回归。Fixed regression with SQL Agent scheduler where ONIDLE scheduling was chosen even when some other scheduling type was chosen.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 调整 MAXTRANSFERRATE、MAXBLOCKSIZE 以在 Azure 存储上进行备份。Adjusting MAXTRANSFERRATE, MAXBLOCKSIZE for doing backups on Azure Storage.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 在还原操作之前编写结尾日志备份的问题(这在 CL 上不受支持)。The issue where tail log backup is scripted before RESTORE operation (this isn't supported on CL).
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 创建数据库向导未正确编写 CREATE DATABASE 语句。Create database wizard not scripting correctly CREATE DATABASE statement.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 连接到托管实例时,对 SSMS 中的 SSIS 包进行特殊处理。Special handling of SSIS packages within SSMS when connected to managed instances.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了连接到托管实例时尝试使用“活动监视器”显示错误的问题。Fixed an issue where an error was displayed while trying to use "Activity Monitor" when connected to managed instances.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 改进了对 AAD 登录(SSMS 资源管理器中)的支持。Improved support for AAD Logins (in SSMS Explorer).
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 改进了 SMO 文件组对象的脚本编写。Improved scripting of SMO Filegroups objects.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 改进了凭据的 UI。Improved UI for credentials.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 添加了对逻辑复制的支持。Added support for Logical Replication.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了导致右键单击数据库并选择“导入数据层应用程序”失败的问题。Fixed an issue, which was causing right-clicking on a database and choosing 'Import data-tier application' to fail.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了导致右键单击“TempDB”会显示错误的问题。Fixed an issue, which was causing right-clicking on a "TempDB" to show errors.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了对 SMO 中的 ALTER DB ADD FILE 语句编写脚本导致生成的 T-SQL 脚本为空的问题。Fixed an issue where trying to scripting ALTER DB ADD FILE statement in SMO was causing the generated T-SQL script to be empty.
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 改进了托管实例服务器特定属性(硬件生成、服务层、使用和保留的存储)的显示。Improved display of managed instances server-specific properties (hardware generation, service tier, storage used and reserved).
Azure SQL DB 托管实例支持Azure SQL DB managed instance support 修复了编写数据库脚本(“脚本作为创建...”)没有编写额外文件组和文件脚本的问题。Fixed an issue where scripting of a database ("Script as Create...") wasn't scripting extra filegroups and files. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/37326799For details, see https://feedback.azure.com/forums/908035/suggestions/37326799.
备份/还原/附加/分离数据库Backup/Restore/Attach/Detach DB 修复了 .mdf 文件的物理文件名与原始文件名不匹配时用户无法附加数据库的问题。Fixed an issue where the user was unable to attach a database when physical filename of .mdf file does not match the original filename.
备份/还原/附加/分离数据库Backup/Restore/Attach/Detach DB 修复了 SSMS 可能找不到有效的还原计划或可能找到的还原计划并非最优的问题。Fixed an issue where SSMS might not find a valid restore plan or might find one, which is suboptimal. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32897752For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897752.
备份/还原/附加/分离数据库Backup/Restore/Attach/Detach DB 修复了“附加数据库”向导不显示已重命名的辅助文件的问题。Fixed issue where the "Attach Database" wizard wasn't displaying secondary files that were renamed. 现在,会显示文件并添加了相关注释(例如“找不到”)。Now, the file is displayed, and a comment about it is added (for example "Not Found"). 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/32897434For details, see https://feedback.azure.com/forums/908035/suggestions/32897434.
复制数据库向导Copy Database Wizard 生成脚本/传输/复制数据库向导尝试创建一个表,其内存中表不强制将 ansi_padding 设置为 on。Generate scripts/Transfer/Copy Database Wizard try to create a table with an in memory table doesn't force ansi_padding on.
复制数据库向导Copy Database Wizard SQL Server 2017 和 SQL Server 2019 上的传输数据库任务/复制数据库向导中断。Transfer Database task/Copy Database Wizard broken on SQL Server 2017 and SQL Server 2019. """"
复制数据库向导Copy Database Wizard 先创建生成脚本/传输/复制数据库向导脚本表,再创建关联的外部数据源。Generate scripts/Transfer/Copy Database Wizard script table creation before creation of associated external data source.
连接对话框Connection dialog 启用了通过按 DEL 键从以前的用户名列表中删除用户名。Enabled the removal of usernames from previous username list by pressing the DEL key. 有关详细信息,请参阅允许从 SSMS 登录窗口删除用户For details, see Allow deletion of users from SSMS login window.
DAC 导入向导DAC Import Wizard 修复了使用 AAD 连接时 DAC 导入向导失效的问题。Fixed an issue DAC Import Wizard wasn't working when connected using AAD.
数据分类Data Classification 修复了在数据分类窗格中保存分类时,其他数据分类窗格在其他数据库中打开的问题。Fixed an issue when saving classifications in the data classification pane while there are another data classification panes open on other databases.
数据层应用程序向导Data-tier Application Wizard 解决了由于对服务器的访问受限(例如,无法访问同一服务器上的所有数据库),用户无法导入数据层应用程序 (.dacpac) 的问题。Fixed an issue where the user wasn't able to import a Data-tier Application (.dacpac) due to limited access to the server (for example, no access to all the databases on the same server).
数据层应用程序向导Data-tier Application Wizard 解决了当许多数据库碰巧托管在同一 Azure SQL 服务器上时导致导入速度非常缓慢的问题。Fixed an issue, which was causing the import to be extremely slow when many databases happened to be hosted on the same Azure SQL server.
外部表External Tables 在模板、SMO、IntelliSense 和属性网格中添加了对 Rejected_Row_Location 的支持。Added support for Rejected_Row_Location in template, SMO, intellisense, and property grid.
平面文件导入向导Flat File Import Wizard 修复了“导入平面文件向导”未正确处理双引号(转义)的问题。Fixed an issue where the "Import Flat File Wizard" wasn't handling double quotes correctly (escaping). 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/32897998For details, see https://feedback.azure.com/forums/908035/suggestions/32897998.
平面文件导入向导Flat File Import Wizard 修复了(在使用不同浮点分隔符的区域设置上)错误处理浮点类型的问题。Fixed an issue where related to incorrect handling of floating-point types (on locales that use a different delimiter for floating points).
平面文件导入向导Flat File Import Wizard 修复了与值为 0 或 1 时的导入位数相关的问题。Fixed an issue related to importing of bits when values are 0 or 1. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32898535For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898535.
平面文件导入向导Flat File Import Wizard 修复了浮点 数据类型输入为 null 问题。Fixed an issue where the float data-type were entered as nulls.
平面文件导入向导Flat File Import Wizard 修复了导入向导无法处理负十进制值的问题。Fixed an issue where the import wizard wasn't able to process negative decimal values.
平面文件导入向导Flat File Import Wizard 修复了向导无法从单列 CSV 文件导入的问题。Fixed an issue where the wizard wasn't able to import from single column CSV files.
平面文件导入向导Flat File Import Wizard 修复了已存在目标表时平面文件导入不允许更改目标表的问题。Fixed issue where Flat File Import does not allow changing destination table when table is already existing. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186.
帮助查看器Help Viewer 改进了有关使用联机/脱机模式的逻辑(仍然有一些问题需要解决)。Improved logic around honoring the online/offline modes (there may still be a few issues that need to be addressed).
帮助查看器Help Viewer 修复了使用联机/脱机设置的“查看帮助”。Fixed the "View Help" to honor the online/offline settings. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32897791For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897791.
高可用性和灾难恢复 (HADR)High Availability Disaster Recovery (HADR)
可用性组 (AG)Availability Groups (AG)
修复了“故障转移可用性组”向导中角色始终显示为“正在解析”的问题。Fixed an issue where roles in "Fail Over Availability Groups" wizard was always displayed as "Resolving".
高可用性和灾难恢复 (HADR)High Availability Disaster Recovery (HADR)
可用性组 (AG)Availability Groups (AG)
修复了 SSMS 在“可用性组仪表板”中显示的警告遭截断的问题。Fixed an issue where SSMS was showing truncated warnings in "AG Dashboard".
Integration Services (IS)Integration Services (IS) 修复了同一台计算机上安装有 SQL Server 2019 和 SSMS 18.0 时部署向导无法连接到 SQL Server 的 SxS 问题。Fixed a SxS issue that deployment wizard fails to connect to sql server when SQL Server 2019 and SSMS 18.0 are installed on the same machine.
Integration Services (IS)Integration Services (IS) 修复了在设计维护计划时,不能编辑维护计划任务的问题。Fixed an issue that maintenance plan task can't be edited when designing the maintenance plan.
Integration Services (IS)Integration Services (IS) 修复了重命名部署下的项目时部署向导卡住的问题。Fixed an issue that the deployment wizard gets stuck if the project under deployment is renamed.
Integration Services (IS)Integration Services (IS) 启用了 Azure-SSIS IR 计划功能中的环境设置。Enabled environment setting in Azure-SSIS IR schedule feature.
Integration Services (IS)Integration Services (IS) 修复了当客户帐户属于多个租户时 SSIS Integration Runtime 创建向导停止响应的问题。Fixed an issue that SSIS Integration Runtime Creation Wizard stops responding when the customer account belongs to more than 1 tenant.
作业活动监视器Job Activity Monitor 修复了使用作业活动监视器(通过筛选器)时的故障。Fixed crash while using Job Activity Monitor (with filters).
“对象资源管理器”Object Explorer 修复了 SSMS 在 OE 中尝试展开“管理”节点(错误配置 DataCollector)时引发“对象无法从 DBNull 转换为其他类型”异常的问题。Fixed an issue where SSMS was throwing an "Object cannot be cast from DBNull to other types" exception when trying to expand "Management" node in OE (misconfigured DataCollector).
“对象资源管理器”Object Explorer 修复了在调用“Edit Top N…”之前 OE 未转义引号会导致设计混淆的问题。Fixed an issue where OE wasn't escaping quotes before invoking the "Edit Top N..." causing the designer to get confused.
“对象资源管理器”Object Explorer 修复了无法从 Azure 存储树中启动“导入数据层应用程序”向导的问题。Fixed an issue where the "Import Data-Tier application" wizard was failing to launch from the Azure Storage tree.
“对象资源管理器”Object Explorer 修复了 TLS/SSL 复选框的状态不持久的“数据库邮件配置”问题。Fixed an issue in "Database Mail Configuration" where the status of the TLS/SSL checkbox wasn't persisted. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32895541For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32895541.
“对象资源管理器”Object Explorer 修复了尝试使用 is_auto_update_stats_async_on 还原数据库时 SSMS 灰显选项并关闭现有连接的问题。Fixed an issue where SSMS grayed out option to close existing connections when trying to restore database with is_auto_update_stats_async_on.
“对象资源管理器”Object Explorer 修复了在 OE 中的节点上右键单击的问题(例如,右键单击“表”并希望执行某个操作,比如通过转到“筛选器”>“筛选器设置”筛选表,但筛选器设置窗体可能未显示在 SSMS 当前处于活动状态屏幕上)。Fixed an issue where right-clicking on nodes in OE the (for example "Tables" and wanting to perform an action such as filtering tables by going to Filter > Filter Settings, the filter settings form can appear on the other screen than where SSMS is currently active). 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/34284106For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/34284106.
“对象资源管理器”Object Explorer 修复了尝试重命名对象时 Delete 键在对象资源管理器中不工作这一长期未解决的问题。Fixed a long outstanding issue where the DELETE key wasn't working in OE while trying to rename an object. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/33073510https://feedback.azure.com/forums/908035/suggestions/32910247 和其他重复项。For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/33073510, https://feedback.azure.com/forums/908035/suggestions/32910247 and other duplicates.
“对象资源管理器”Object Explorer 显示现有数据库文件的属性时,大小显示在列“大小 (MB)”而不是“初始大小 (MB)”下,这是创建新数据库时显示的内容。When displaying the properties of existing database files, the size appears under a column "Size (MB)" instead of "Initial Size (MB)" which is what is displayed when creating a new database. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32629024For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32629024.
“对象资源管理器”Object Explorer 由于当前版本的 SSMS 中不支持此类表,已禁用“图形表”的“设计”上下文菜单项。Disabled the "Design" context-menu item on "Graph Tables" since there is no support for those tables in the current version of SSMS.
“对象资源管理器”Object Explorer 修复了高 DPI 监视器不呈现“新建作业计划”对话框的问题。Fixed an issue where the "New Job Schedule" dialog wasn't rendering properly on High DPI monitors. 有关详细信息,请参阅 https://feedback.azure.com/admin/v3/suggestions/35541262For details, see https://feedback.azure.com/admin/v3/suggestions/35541262.
“对象资源管理器”Object Explorer 修复了在对象资源管理器详细信息中显示数据库大小(“大小 (MB)”)的问题并改进了显示方式:仅 2 位小数并使用千位分隔符格式。Fixed/improved the way an issue where a database size ("Size (MB)") is displayed in Object Explorer details: only 2 decimal digits and formatted using the thousands separator. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/34379308For details, see https://feedback.azure.com/forums/908035/suggestions/34379308.
“对象资源管理器”Object Explorer 修复了创建“空间索引”因“要完成此操作,请设置 PartitionScheme 属性”等错误而失败的问题。Fixed an issue that was causing the creation of a "Spatial Index" to fail with an error like "To accomplish this action, set property PartitionScheme".
“对象资源管理器”Object Explorer 在对象资源管理器中进行了一些小的性能改进,以尽可能避免发出额外的查询。Minor performance improvements in Object Explorer to avoid issuing extra queries, when possible.
“对象资源管理器”Object Explorer 扩展了重命名所有架构对象的数据库时请求确认的逻辑(可配置该设置)。Extended logic to request confirmation when renaming a database to all the schema objects (the setting can be configured).
“对象资源管理器”Object Explorer 在对象资源管理器筛选中添加了正确的转义。Added proper escaping in Object Explorer filtering. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/36678803For details, see https://feedback.azure.com/forums/908035/suggestions/36678803.
“对象资源管理器”Object Explorer 修复/改进了对象资源管理器详细信息中的视图,以显示带适当分隔符的数字。Fixed/improved the view in Object Explorer Details to show numbers with proper separators. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/32900944For details, see https://feedback.azure.com/forums/908035/suggestions/32900944.
“对象资源管理器”Object Explorer 修复了连接到 SQL Express 时“表”节点上的上下文菜单(以前缺少“新建”浮出控件、图形表未正确列出,并且缺少由系统控制版本的表)。Fixed context menu on "Tables" node when connected to SQL Express, where the "New" fly-out was missing, Graph tables were incorrectly listed, and System-Versioned table was missing. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/37245529For details, see https://feedback.azure.com/forums/908035/suggestions/37245529.
对象脚本Object Scripting 整体性能改进 - 生成 WideWorldImporters 的脚本与 SSMS 17.7 相比需要一半时间。Overall perf improvements - Generate Scripts of WideWorldImporters takes half the time compared to SSMS 17.7.
对象脚本Object Scripting 当编写对象脚本时,将省略具有默认值的 DB 作用域配置。When scripting objects, DB Scoped configuration, which has default values are omitted.
对象脚本Object Scripting 编写脚本时不生成动态 T-SQL。Don't generate dynamic T-SQL when scripting. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32898391For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898391.
对象脚本Object Scripting 在 SQL Server 2016 及更早版本中对表编写脚本时,省略图形语法“as edge”和“as node”。Omit the graph syntax "as edge" and "as node" when scripting a table on SQL Server 2016 and earlier.
对象脚本Object Scripting 修复了使用 AAD 和 MFA 连接到 Azure SQL 数据库时数据库对象脚本编写失败的问题。Fixed an issue where scripting of database objects was failing when connecting to an Azure SQL DB using AAD with MFA.
对象脚本Object Scripting 修复了在 Azure SQL 数据库上使用 GEOMETRY_AUTO_GRID/GEOGRAPHY_AUTO_GRID 编写空间索引脚本时引发错误的问题。Fixed an issue where trying to script a spatial index with GEOMETRY_AUTO_GRID/GEOGRAPHY_AUTO_GRID on an Azure SQL DB was throwing an error.
对象脚本Object Scripting 修复了即使“对象资源管理器”脚本设置已设为与源匹配也仍然导致(Azure SQL 数据库的)数据库脚本始终以本地 SQL 为目标的问题。Fixed an issue, which was causing the database scripting (of an Azure SQL Database) to always target an on-prem SQL, even if the "Object Explorer" scripting settings were set to match the source.
对象脚本Object Scripting 修复了尝试对 SQL DW 数据库中的表(包含生成错误 T-SQL 语句的聚集索引和非聚集索引)编写脚本时出现的问题。Fixed an issue where trying to script a table in a SQL DW database involving clustered and nonclustered indexes was generating incorrect T-SQL statements.
对象脚本Object Scripting 修复了尝试对 SQL DW 数据库中的表(包含生成错误 T-SQL 语句[重复语句]的“聚集列存储索引”和“聚集索引”)编写脚本时出现的问题。Fixed an issue where trying to script a table in a SQL DW database with both "Clustered Columnstore Indexes" and "Clustered Indexes" was generating incorrect T-SQL (duplicate statements).
对象脚本Object Scripting 修复了没有范围值(SQL DW 数据库)的分区表脚本的编写问题。Fixed Partitioned table scripting with no range values (SQL DW databases).
对象脚本Object Scripting 修复了用户无法编写审核/审核规范 SERVER_PERMISSION_CHANGE_GROUP 脚本的问题。Fixed an issue where the user would be unable to script an audit/audit specification SERVER_PERMISSION_CHANGE_GROUP.
对象脚本Object Scripting 修复了用户无法对 SQL DW 中的统计信息编写脚本的问题。Fix and issue where the user is unable to script statistics from SQL DW. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32897296For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897296.
对象脚本Object Scripting 修复了在“出错时继续编写脚本”设置为 false 时,“生成脚本向导”显示具有脚本编辑错误的错误表的问题。Fixed an issue where the "Generate script wizard" shows incorrect table having scripting error when "Continue scripting on Error" is set to false.
对象脚本Object Scripting 改进了 SQL Server 2019 上的脚本生成。Improved script generation on SQL Server 2019.
探查器Profiler 将“聚合表重写查询”事件添加到了探查器事件。Added "Aggregate Table Rewrite Query" event to Profiler events.
查询数据存储Query Data Store 修复了可能引发“DocumentFrame (SQLEditors)”异常的问题。Fixed an issue where a "DocumentFrame (SQLEditors)" exception could be thrown.
查询数据存储Query Data Store 修复了尝试在内置查询存储报表中设置自定义时间间隔时,用户无法对开始/结束时间间隔选择 AM 或 PM 的问题。Fixed an issue when trying to set a custom time interval in the build-in Query Store reports the user wasn't able to select AM or PM on the start/end interval.
结果网格Results Grid 修复了导致高对比度模式(所选行号不可见)的问题。Fixed an issue that was causing the in High Contrast mode (selected line numbers not visible).
结果网格Results Grid 修复了单击网格时导致出现“索引超出范围”异常的问题。Fixed an issue, which resulted in an "Index out of range" exception when clicking on the grid.
结果网格Results Grid 解决了网格结果背景色被忽略的问题。Fixed an issue where the grid result background color was being ignored. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/32895916For details, see https://feedback.azure.com/forums/908035/suggestions/32895916.
显示计划ShowPlan 有多个线程时,新的内存授予运算符属性显示错误。New memory grant operator properties display incorrectly when there is more than one thread.
显示计划ShowPlan 在实际执行 xml 计划的 RunTimeCountersPerThread 中添加以下 4 个属性:HpcRowCount(由 hpc 设备处理的行数)、HpcKernelElapsedUs(正在使用的内核执行的运行时间等待)、HpcHostToDeviceBytes(已从主机传输到设备的字节数)和 HpcDeviceToHostBytes (已从设备传输到主机的字节数)。Add the following 4 attributes in RunTimeCountersPerThread of actual execution xml plan: HpcRowCount (Number of rows processed by a hpc device), HpcKernelElapsedUs (elapsed time wait for kernel execution in use), HpcHostToDeviceBytes (bytes transferred from host to device), and HpcDeviceToHostBytes (bytes transferred from device to host).
显示计划ShowPlan 修复了类似计划节点在错误位置突出显示的问题。Fixed an issue where the similar plan nodes are highlighted in the wrong position.
SMOSMO 修复了 SMO/ServerConnection 未正确处理基于 SqlCredential 的连接的问题。Fixed an issue where SMO/ServerConnection didn't SqlCredential-based connections correctly. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/33698941For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/33698941.
SMOSMO 修复了使用 SMO 编写的应用程序在多个线程上试图枚举来自同一服务器的数据库时遇到错误(即使在每个线程上使用单独的 SqlConnection 实例)的问题。Fixed an issue where an application written using SMO would encounter an error if it tried to enumerate databases from the same server on multiple threads even though it uses separate SqlConnection instances on each thread.
SMOSMO 修复了从外部表传输的性能回归问题。Fixed performance regression in Transfer from External Tables.
SMOSMO 修复了导致 SMO 在定位 Azure 时泄露 SqlConnection 实例的 ServerConnection 线程安全问题。Fixed issue in ServerConnection thread-safety, which was causing SMO to leak SqlConnection instances when targeting Azure.
SMOSMO 修复了在尝试还原名称中带有大括号的数据库时导致 StringBuilder.FormatError 的问题。Fixed an issue, which was causing a StringBuilder.FormatError when trying to restore a database, which had curly braces in its name.
SMOSMO 修复了 SMO 中的 Azure 数据库默认为所有字符串比较应用不区分大小写的排序规则,而不是针对数据库使用指定的排序规则的问题。Fixed an issue where Azure databases in SMO were defaulting to Case-Insensitive collation for all string comparisons instead of using the specified collation for the database.
SSMS 编辑器SSMS Editor 修复了还原默认颜色的“SQL 系统表”意外将颜色设置为暗黄绿色,而不是默认的绿色,使其难以在白色背景上读取的问题。Fixed an issue where "SQL System Table" where restoring the default colors was chancing the color to lime green, rather than the default green, making it hard to read on a white background. 有关详细信息,请参阅还原 SQL 系统表的错误默认颜色For details, see Restoring wrong default color for SQL System Table. 此问题在 SSMS 的非英文版本上仍然存在。The issue still persists on non-English versions of SSMS.
SSMS 编辑器SSMS Editor 修复了在使用 AAD 身份验证连接到 Azure SQL DW 时 IntelliSense 不工作的问题。Fixed issue where intellisense wasn't working when connected to Azure SQLDW using AAD authentication.
SSMS 编辑器SSMS Editor 修复了用户缺少对 master 数据库的访问权限时,Azure 中的 IntelliSense 问题 。Fixed intellisense in Azure when user lacks access to master database.
SSMS 编辑器SSMS Editor 修复了目标数据库排序规则区分大小写时损坏的用于创建“时态表”的代码片段。Fixed code snippets to create "temporal tables", which were broken when the collation of the target database was case-sensitive.
SSMS 编辑器SSMS Editor 新 TRANSLATE 函数当前由 intellisense 识别。New TRANSLATE function now recognized by intellisense. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32898430For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898430.
SSMS 编辑器SSMS Editor 针对 FORMAT 内置函数改进了 IntelliSense。Improved intellisense on FORMAT built-in function. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32898676For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898676.
SSMS 编辑器SSMS Editor LAG 和 LEAD 当前被识别为内置函数。LAG and LEAD are now recognized as built-in functions. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32898757For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898757.
SSMS 编辑器SSMS Editor 修复了使用“ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)”时 IntelliSense 发出警告的问题。Fixed an issue where intellisense was giving a warning when using "ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)".
SSMS 编辑器SSMS Editor 修复了多个系统视图和表值函数未正确着色的问题。Fixed an issue where several system views and table values functions weren't properly colorized.
SSMS 编辑器SSMS Editor 修复了单击“编辑器”选项卡可能导致该选项卡关闭而非获得焦点的问题。Fixed an issue where clicking on editor tabs could cause the tab to be closed instead of getting the focus. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/37291114For details, see https://feedback.azure.com/forums/908035/suggestions/37291114.
SSMS 选项SSMS Options 修复了“工具” > “选项” > “SQL Server 对象资源管理器” > “命令”页未正确调整大小的问题 。Fixed an issue where Tools > Options > SQL Server Object Explorer > Commands page wasn't resizing properly.
SSMS 选项SSMS Options SSMS 现在默认禁用在 XMLA 编辑器中自动下载 DTD - XMLA 脚本编辑器(使用 xml 语言服务)现在因可能存在恶意 xmla 文件而默认阻止自动下载 DTD。SSMS now by default disables automatic download of DTD in XMLA editor -- XMLA script editor (which uses the xml language service) by default now prevents automatically downloading the DTD for potentially malicious xmla files. 这是通过禁用“工具” > “选项” > “环境” > “文本编辑器” > “XML” > “其他” 中的“自动下载 DTD 和架构”设置来控制的。This is controlled by turning off the "Automatically download DTDs and Schemas" setting in Tools > Options > Environment > Text Editor > XML > Miscellaneous.
SSMS 选项SSMS Options 将 Ctrl+D 还原成了 SSMS 早期版本中那样的快捷方式 。Restored CTRL+D to be the shortcut as it used to be in older version of SSMS. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/35544754For details, see https://feedback.azure.com/forums/908035/suggestions/35544754.
表设计器Table Designer 修复了“编辑 200 行”中的故障。Fixed a crash in "Edit 200 rows".
表设计器Table Designer 修复了在连接到 Azure SQL 数据库时设计器允许添加表的问题。Fixed an issue where the designer was allowing to add a table when connected to an Azure SQL Database.
漏洞评估Vulnerability Assessment 修复了扫描结果加载不正确的问题。Fixed an issue where the scan results aren't being loaded properly.
XEventXEvent 已添加两个列“action_name”和“class_type_desc”,将操作 ID 和类类型字段显示为可读字符串。Added two columns "action_name" and "class_type_desc" that show action ID and class type fields as readable strings.
XEventXEvent 已删除 1000000 个事件的事件 XEvent 查看器上限。Removed the event XEvent Viewer cap of 1,000,000 events.
XEvent 探查器XEvent Profiler 修复了连接到 96 核 SQL Server 时无法启动 XEvent 探查器的问题。Fixed an issue where XEvent Profiler failed to launch when connected to a 96-core SQL Server.
XEvent 查看器XEvent Viewer 修复了使用“扩展事件工具栏选项”对事件分组时 XEvent 查看器出现故障的问题。Fixed an issue where XEvent Viewer was crashing when trying to group the events using the "Extended Event Toolbar Options".

18.0 中已弃用和已删除的功能Deprecated and removed features in 18.0

已弃用/已删除的功能Deprecated / Removed Features

  • T-SQL 调试程序T-SQL Debugger
  • 数据库关系图Database Diagrams
  • SSMS 不再安装以下工具:The following tools are no longer installed with SSMS:
    • OSQL.EXEOSQL.EXE
    • DReplay.exeDReplay.exe
    • SQLdiag.exeSQLdiag.exe
    • SSBDiagnose.exeSSBDiagnose.exe
    • bcp.exebcp.exe
    • sqlcmd.exesqlcmd.exe
  • Configuration Manager 工具:Configuration Manager tools:
    • SQL Server 配置管理器和报表服务器配置管理器不再是 SSMS 安装程序的一部分。Both SQL Server Configuration Manager and Reporting Server Configuration Manager aren't part of SSMS setup anymore.
  • DMF 标准策略DMF Standard Policies
    • 策略不再随 SSMS 安装。The policies aren't installed with SSMS anymore. 已将它们迁移到 Git。They are moved to Git. 如果用户需要策略,则能够参与并下载/安装它们。Users are able to contribute and download/install them, if they want to.
  • SSMS 命令行选项 - P 已删除SSMS command-line option -P removed
    • 出于安全考虑,已删除命令行上指定明文密码的选项。Due to security concerns, the option to specify clear-text passwords on the command line was removed.
  • 删除了生成脚本并发布到 Web 服务的功能Generate Scripts > Publish to Web Service removed
    • 从 SSMS UI 中删除了此已弃用的功能。This deprecated feature was removed from the SSMS UI.
  • 在对象资源管理器中删除了“维护 > 旧版”节点。Removed node "Maintenance > Legacy" in Object Explorer.
    • 将不再能够访问陈旧的“数据库维护计划”和“SQL Mail”节点。The old "Database Maintenance Plan" and "SQL Mail" nodes won't be accessible anymore. 新式“数据库邮件”和“维护计划”节点继续照常工作。The modern "Database Mail" and "Maintenance Plans" nodes continue to work as usual.

已知问题 (18.0)Known issues (18.0)

  • 安装版本 18.0 时可能会遇到以下问题:无法运行 SQL Server Management Studio。You might encounter an issue installing version 18.0, where you cannot run SQL Server Management Studio. 如果遇到此问题,请按照 SSMS2018 - 已安装,但不运行一文中的步骤进行操作。If you encounter this issue, follow the steps from the SSMS2018 - Installed, but not run article.

  • 对于在网格、文本或文件中显示的 SSMS 结果中可以查看的数据大小,存在限制There is a limitation on the size of the data you see from SSMS results shown in grid, text, or file

  • 在多个查询窗口之间切换时会出现重绘问题。There are redraw issues when switching between multiple query windows. 有关更多详细信息,请参阅 UserVoiceSee UserVoice for more details. 此问题的解决方法是在“工具”>“选项”下禁用硬件加速。A workaround for this issue is to disable hardware acceleration under Tools > Options.

17.9.117.9.1

下载 下载 SSMS 17.9.1download Download SSMS 17.9.1

  • 版本号:17.9.1Release number: 17.9.1
  • 生成号:14.0.17289.0Build number: 14.0.17289.0
  • 发行日期:2018 年 11 月 21 日Release date: November 21, 2018

17.9.1 是对 17.9 的一个小更新,修复了以下 bug:17.9.1 is a small update to 17.9 with the following bug fixes:

17.9.1 中的 bug 修复Bug fixes in 17.9.1

  • 修复了在使用带有 SQL 查询编辑器的“Azure Active Directory - 通用且具有 MFA 支持”身份验证时,用户可能会遇到关闭连接并在每次查询调用时重新打开连接的问题。Fixed an issue where users may experience their connection being closed and reopened with each query invocation when using "Azure Active Directory - Universal with MFA support" authentication with the SQL query editor. 此类关闭连接的副作用包括意外删除全局临时表,有时还会向连接提供新的 SPID。Side effects of the connection closing included global temporary tables being dropped unexpectedly, and sometimes a new SPID given to the connection.
  • 修复了长期未解决的问题,即还原计划无法查找还原计划,或在某些情况下生成低效的还原计划。Fixed a long outstanding issue where restore plan would fail to find a restore plan, or would generate an inefficient restore plan under certain conditions.
  • 修复了“导入数据层应用程序”向导中的问题,该问题在连接到 Azure SQL 数据库时可能出现错误。Fixed an issue in the "Import Data-tier Application" wizard, which could result in an error when connected to an Azure SQL Database.

备注

如果安装在以下平台中,非英语本地化版本的 SSMS 17.x 需要 KB 2862966 安全更新程序包:Windows 8、Windows 7、Windows Server 2012 和 Windows Server 2008 R2。Non-English localized releases of SSMS 17.x require the KB 2862966 security update package if installing on: Windows 8, Windows 7, Windows Server 2012, and Windows Server 2008 R2.

中文(简体)| 中文(繁体)| 英语(美国)| 法语| 德语| 意大利语| 日语| 朝鲜语| 葡萄牙语(巴西)| 俄语| 西班牙语Chinese (Simplified)| Chinese (Traditional)| English (United States)| French| German| Italian| Japanese| Korean| Portuguese (Brazil)| Russian| Spanish

卸载并重装 SSMS 17.xUninstall and reinstall SSMS 17.x

如果安装 SSMS 时遇到问题,并且标准的卸载和重装无法解决问题,可以先尝试下修复 Visual Studio 2015 IsoShell。If your SSMS installation is having problems, and a standard uninstall and reinstall doesn't resolve them, you can first try repairing the Visual Studio 2015 IsoShell. 如果修复 Visual Studio 2015 IsoShell 不能解决此问题,可以尝试下面的步骤来解决许多偶然的问题:If repairing the Visual Studio 2015 IsoShell doesn't resolve the problem, the following steps have been found to fix many random issues:

  1. 像卸载任意应用程序那样卸载 SSMS(使用“应用和功能”、“程序和功能”,具体取决于 Windows 版本) 。Uninstall SSMS the same way you uninstall any application (using Apps & features, Programs, and features, depending on your version of Windows).

  2. 通过提升的 cmd 提示符卸载 Visual Studio 2015 IsoShell :Uninstall Visual Studio 2015 IsoShell from an elevated cmd prompt:

    PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"

    vs_isoshell.exe /Uninstall /Force /PromptRestart

  3. 像卸载任何应用程序那样卸载 Microsoft Visual C++ 2015 可再发行组件。Uninstall Microsoft Visual C++ 2015 Redistributable the same way you uninstall any application. 如果计算机上有 x86 和 x64,则卸载它们。Uninstall both x86 and x64 if they're on your computer.

  4. 通过提升的 cmd 提示符重装 Visual Studio 2015 IsoShell :Reinstall Visual Studio 2015 IsoShell from an elevated cmd prompt:

    PUSHD "C:\ProgramData\Package Cache\FE948F0DAB52EB8CB5A740A77D8934B9E1A8E301\redist"

    vs_isoshell.exe /PromptRestart

  5. 重装 SSMS。Reinstall SSMS.

  6. 如果当前不是最新版本的话,则升级到最新版本的 Visual C++ 2015 可再发行组件Upgrade to the latest version of the Visual C++ 2015 Redistributable if you're not currently up to date.

16.5.316.5.3

下载 下载 SSMS 16.5.3download Download SSMS 16.5.3

  • 版本号:16.5.3Release number: 16.5.3
  • 生成号:13.0.16106.4Build number: 13.0.16106.4
  • 发行日期:2017 年 1 月 30 日Release date: January 30, 2017

中文(简体)| 中文(繁体)| 英语(美国)| 法语| 德语| 意大利语| 日语| 朝鲜语| 葡萄牙语(巴西)| 俄语| 西班牙语Chinese (Simplified)| Chinese (Traditional)| English (United States)| French| German| Italian| Japanese| Korean| Portuguese (Brazil)| Russian| Spanish

16.5.3 中的 bug 修复Bug fixes in 16.5.3

  • 修复了 SSMS 16.5.2 中引入的问题,即当表具有多个稀疏列时,导致“表”节点扩展。Fixed an issue introduced in SSMS 16.5.2, which was causing the expansion of the 'Table' node when the table had more than one sparse column.

  • 用户可以部署包含 OData 连接管理器的 SSIS 包,这些包连接到 SSIS 目录的 Microsoft Dynamics AX/CRM Online 资源。Users can deploy SSIS packages containing OData Connection Manager, which connect to a Microsoft Dynamics AX/CRM Online resource to SSIS catalog. 有关详细信息,请参阅 OData 连接管理器For more information, For details, see OData Connection Manager.

  • 为现有表配置 Always Encrypted 功能失败,在不相关的对象上出错。Configuring Always Encrypted on an existing table fails with errors on unrelated objects. 连接 ID 3103181Connect ID 3103181

  • 为现有数据库配置 Always Encrypted 功能时,多个架构无法正常运行。Configuring Always Encrypted for an existing database with multiple schemas doesn't work. 连接 ID 3109591Connect ID 3109591

  • 由于数据库包含引用系统视图的视图,Always Encrypted、“已加密列”向导失败。The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. 连接 ID 3111925Connect ID 3111925

  • 使用 Always Encrypted 功能进行加密时,错误处理加密后刷新模块出现错误。When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.

  • “打开最近的文件”菜单不显示最近保存的文件。 Open recent menu doesn't show recently saved files. 连接 ID 3113288Connect ID 3113288

  • 右键单击表的索引(通过远程 (Internet) 连接)时,SSMS 运行缓慢。SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection). 连接 ID 3114074Connect ID 3114074

  • 解决了 SQL 设计器滚动条的问题。Fixed an issue with the SQL Designer scrollbar. 连接 ID 3114856Connect ID 3114856

  • 表的上下文菜单暂时挂起Context menu for tables momentarily hangs

  • SSMS 偶尔在活动监视器中引发异常和崩溃。SSMS occasionally throws exceptions in Activity Monitor and crashes. 连接 ID 697527Connect ID 697527

  • SSMS 2016 崩溃,显示错误“由于在 IP 71AF8579 (71AE0000) 的 .NET 运行时出现内部错误,进程终止,退出代码 80131506”SSMS 2016 crashes with error "The process was terminated due to an internal error in the .NET Runtime at IP 71AF8579 (71AE0000) with exit code 80131506"

其他下载Additional Downloads

有关所有 SQL Server Management Studio 下载的列表,请搜索 Microsoft 下载中心For a list of all SQL Server Management Studio downloads, search the Microsoft Download Center.

有关最新版本的 SQL Server Management Studio,请参阅 下载 SQL Server Management Studio (SSMS)For the latest release of SQL Server Management Studio, For details, see Download SQL Server Management Studio (SSMS).