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

适用对象:yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

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

18.0 (GA),2019 年 4 月18.0 (GA), April 2019

下载:    下载 SSMS 18.0 (GA)Download:     Download SSMS 18.0 (GA)
生成号:    15.0.18118.0Build number:     15.0.18118.0
发布日期:    2019 年 4 月 24 日Release date:     April 24, 2019

现已发布 SSMS 18.0 通用版本 (GA)。The general availability (GA) release of SSMS 18.0 is available. 如果需要 SSMS 的早期版本,请参阅 SSMS 的早期版本If you need a previous version of SSMS, see previous SSMS releases.

18.0 (GA) 中的新增功能What's new in 18.0 (GA)

新项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 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:From the command line, pass this extra argument to the SSMS-Setup-ENU.exe:
SSMSInstallRoot = C:\MySSMS18SSMSInstallRoot=C:\MySSMS18
默认情况下,SSMS 的新安装位置为:%ProgramFiles(x86)%\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exeBy 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 将显示英语用户界面。If the OS language does not match the SSMS language, the user needs to change the language under Tools > Options > International Settings, otherwise SSMS will show 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 will be 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 is not 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 will block on 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) is not 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 will continue 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 was not 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/34634974。For 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/33624115。For 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 recently added 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 updated documentation at https://docs.microsoft.com/sql/database-engine/availability-groups/windows/monitor-performance-for-always-on-availability-groups.
始终加密Always 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:Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019 preview:
“连接到服务器”对话框(新的“Always Encrypted”选项卡)中指定 Enclave 证明 URL 的文本字段。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.
审核文件Audit Files 对已知的审核操作列表进行了更新以包含 FEATURE RESTRICTION ADD/CHANGE GROUP/DROP。Updated list of known audit actions to include FEATURE RESTRICTION ADD/CHANGE GROUP/DROP.
数据分类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 > 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 separator 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 are available. 这将使实际计划看起来与实时查询统计信息计划一致。This will make 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 is not available, a default value of 1/1/1900 12:00:00 AM will 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 type.
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 will 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 (GA) 中的 bug 修复Bug fixes in 18.0 (GA)

新项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 SSSM 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 big datasets returned by queries.
常规 SSMSGeneral SSMS 修复了“已注册服务器”的连接中未传递“ApplicationIntent”的问题。Fixed an issue there the "ApplicationIntent" was not passed along in connections in "Registered Servers".
常规 SSMSGeneral SSMS 修复了在高 DPI 监视器上未正确呈现“新 XEvent 会话向导 UI”表单的问题。Fixed in issue where the "New XEvent Session Wizard UI" form was not rendered properly on High DPI monitors.
常规 SSMSGeneral SSMS 修复了尝试导入 bacpac 文件的问题。Fixed an issue where trying to import a bacpac file.
常规 SSMSGeneral SSMS 修复了尝试显示数据库 (FILEGROWTH > 2048GB) 属性时引发算术溢出错误的问题。Fixed an issue where trying to display the properties of a database (with FILEGROWTH > 2048GB) 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 could not 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 was not 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 was not 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 a "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 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 is not 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...") was not scripting extra filegroups and files. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/37326799。For 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 sub-optimal. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32897752。For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32897752.
备份/还原/附加/分离数据库Backup/Restore/Attach/Detach DB 修复了“附加数据库”向导不显示已重命名的辅助文件的问题。Fixed issue where the "Attach Database" wizard was not displaying secondary files that were renamed. 现在,会显示文件并添加关于文件的注释(例如“找不到”)。Now, the file is displayed and a comment about it is is added (e.g. "Not Found"). 有关详细信息,请参阅 https://feedback.azure.com/forums/908035/suggestions/32897434。For 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 was not 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 was not able to import a Data-tier Application (.dacpac) due to limited access to the server (e.g. 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" was not handling double quotes correctly (escaping). 请参阅 https://feedback.azure.com/forums/908035/suggestions/32897998。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/32898535。For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/32898535.
平面文件导入向导Flat File Import Wizard 修复了浮点数输入为 null 的问题。Fixed an issue where floats were entered as nulls.
平面文件导入向导Flat File Import Wizard 修复了导入向导无法处理负十进制值的问题。Fixed an issue where the import wizard was not able to process negative decimal values.
平面文件导入向导Flat File Import Wizard 修复了向导无法从单列 CSV 文件导入的问题。Fixed an issue where the wizard was not able to import from single column CSV files.
平面文件导入向导Flat File Import Wizard 将在 SSMS 17.9 中提供] 修复了已存在目标表时平面文件导入不允许更改目标表的问题。will be in SSMS 17.9] 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/32896186。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/32897791。For 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 will fail 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 deployment wizard will 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 tenants.
作业活动监视器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 was not 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 修复了“数据库邮件配置”中 SSL 复选框的状态不持久的问题。Fixed an issue in "Database Mail Configuration" where the status of the SSL checkbox was not persisted. 请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/32895541。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 修复了在对象资源管理器中右键单击节点的问题(例如“表”,并希望执行某个操作,例如通过转到“筛选器”>“筛选器设置”对表进行筛选,筛选器设置窗体可能显示在与 SSMS 当前处于活动状态的屏幕不同的其他屏幕上)。Fixed an issue where right-clicking on nodes in OE the (e.g. "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/34284106。For details, see https://feedback.azure.com/forums/908035-sql-server/suggestions/34284106.
“对象资源管理器”Object Explorer 修复了尝试重命名对象时 Delete 键在对象资源管理器中不工作这一长期未解决的问题。Fixed a long outstanding issue where the DELETE key was not working in OE while trying to rename an object. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/33073510、 https://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/32629024。For 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 kind of tables in the current version of SSMS.
“对象资源管理器”Object Explorer 修复了高 DPI 监视器不呈现“新建作业计划”对话框的问题。Fixed an issue where the "New Job Schedule" dialog was not rendering properly on High DPI monitors. 有关详细信息,请参阅 https://feedback.azure.com/admin/v3/suggestions/35541262。For 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/34379308。For 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/36678803。For 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/32900944。For 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/37245529。For 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 编写对象脚本时,省略具有默认值的数据库范围配置。When scripting objects, DB Scoped configuration which have 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/32898391。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 a Azure SQL DB was throwing an error.
对象脚本Object Scripting 修复了即使“对象资源管理器”脚本设置已设为与源匹配也仍然导致(Azure SQL 数据库的)数据库脚本始终以本地 SQL 为目标的问题。Fixed an issue which was causing the database scripting (of a 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 non-clustered 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/32897296。For 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 was not 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/32895916。For details, see https://feedback.azure.com/forums/908035/suggestions/32895916.
显示计划ShowPlan 有多个线程时,新的内存授予运算符属性显示错误。New mem 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 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 did not SqlCredential-based connections correctly. 有关详细信息,请参阅 https://feedback.azure.com/forums/908035-sql-server/suggestions/33698941。For 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 very 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 was not 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/32898430。For 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/32898676。For 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/32898757。For 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 were not 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/37291114。For 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 was not resizing properly.
SSMS 选项SSMS Options SSMS 现在默认禁用在 XMLA 编辑器中自动下载 DTD - XMLA 脚本编辑器(使用 xml 语言服务)现在因可能存在恶意 xmla 文件而默认阻止自动下载 DTD。SSMS will now by default disable automatic download of DTD in XMLA editor -- XMLA script editor (which uses the xml language service) will by default now prevent 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/35544754。For 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 are not 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 (GA) 中已弃用和已删除的功能Deprecated and removed features in 18.0 (GA)

已弃用/已删除的功能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 are not part of SSMS setup anymore.
  • DMF 标准策略DMF Standard Policies
    • 策略不再随 SSMS 安装。The policies are not installed with SSMS anymore. 它们将移动到 Git。They will be moved to Git. 用户将能够参与并下载/安装它们,如果他们需要。Users will be 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 really old "Database Maintenance Plan" and "SQL Mail" nodes won't be accessible anymore. 新式“数据库邮件”和“维护计划”节点将继续按照常工作。The modern "Database Mail" and "Maintenance Plans" nodes will continue to work as usual.

SSMS 的早期版本Previous SSMS releases

通过单击以下部分中的标题链接,下载 SSMS 的早期版本:Download previous SSMS versions by clicking the title links in the following sections:

下载 SSMS 17.9.1download 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:

  • 修复了在使用带有 SQL 查询编辑器的“Active Directory - 通用且具有 MFA 支持”身份验证时,用户可能会遇到关闭连接并在每次查询调用时重新打开连接的问题。Fixed an issue where users may experience their connection being closed and reopened with each query invocation when using "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.9download SSMS 17.9

生成号:14.0.17285.0Build number: 14.0.17285.0
发布日期:2018 年 9 月 4 日Release date: September 04, 2018

备注

如果安装在以下平台中,非英语本地化版本的 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

新增功能What's new

常规 SSMSGeneral SSMS

显示计划:ShowPlan:

  • 对特定计划激活后,“图形显示计划”功能现在显示新行模式内存授予反馈特性:MemoryGrantInfo 查询计划 XML 元素中新增了 IsMemoryGrantFeedbackAdjusted 和 LastRequestedMemory。Graphical Showplan now shows the new row mode memory grant feedback attributes when the feature is activated for a specific plan: IsMemoryGrantFeedbackAdjusted and LastRequestedMemory added to the MemoryGrantInfo query plan XML element. 若要详细了解行模式内存授予反馈,请参阅 SQL 数据库中的自适应查询处理 For more on row mode memory grant feedback, For details, see Adaptive query processing in SQL databases.

Azure SQL:Azure SQL:

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

复制监视器:Replication Monitor:

导入平面文件向导:Import Flat File Wizard:

导入/导出数据层应用程序:Import/Export Data-Tier Application:

  • 修复了 DacFx 中的以下问题:处理已定义分区但未编制索引的表时,无法导入 .bacpac,错误消息为“错误 SQL72014: .Net SqlClient 数据提供程序:Msg 9108,级别 16,状态 10,行 1。不支持递增这种类型的统计信息。Fixed an issue (in DacFx) which was causing the import of a .bacpac could fail with a message like "Error SQL72014: .Net SqlClient Data Provider: Msg 9108, Level 16, State 10, Line 1 This type of statistics is not supported to be incremental. ”。" when dealing with tables with partitions defined and no indexes on the table.

Intellisense:Intellisense:

  • 修复了以下问题:结合使用 AAD 和 MFA 时,无法正常使用 IntelliSense 填写。Fixed an issue where intellisense completion was not working when using AAD with MFA.

对象资源管理器:Object Explorer:

  • 修复了以下问题:“筛选器对话框”显示在随机监视器上,而不是显示在运行 SSMS 的监视器上(多监视器系统)。Fixed an issue where the "Filter Dialog" was displayed on random monitors instead of the monitor where SSMS was running (multi-monitor systems).

Azure SQL:Azure SQL:

  • 修复了以下问题:如果在“可用数据库”中枚举数据库,在连接到特定数据库时,在下拉列表中看不到“master”。Fixed an issue related to enumeration of databases in the "Available Databases" where "master" was not displayed in the dropdown when connected to a specific database.
  • 修复了尝试生成脚本(“数据”或“架构和数据”)失败,进而无法通过结合使用 AAD 和 MFA 连接到 Azure SQL 数据库的问题。Fixed an issue where trying to generate a script ("Data" or "Schema and Data") was failing then connected to the Azure SQL Database using AAD with MFA.
  • 修复了视图设计器(视图)中的以下问题:连接到 Azure SQL 数据库时,无法在 UI 中选择“添加表”。Fixed an issue in the View Designer (Views) where it was not possible to select "Add Tables" from the UI when connected to a Azure SQL Database.
  • 修复了以下问题:在 MFA 令牌续订期间,SSMS 查询编辑器静默关闭,并重新打开连接。Fixed an issue where SSMS Query Editor was silently closing and reopening connections during MFA token renewal. 这有助于避免对用户造成未知的负面影响(如关闭事务且永不再次重新打开)。This prevents side effects unbeknownst to the user (like closing a transaction and never reopening again) from happening. 此变更向属性窗口添加令牌到期时间。The change adds the token expiration time to the properties window.
  • 修复了以下问题:SSMS 不对结合使用 AAD 和 MFA 登录的已导入 MSA 帐户强制提示输入密码。Fixed an issue where SSMS was not enforcing password prompts for imported MSA accounts for AAD with MFA login.

活动监视器:Activity Monitor:

  • 修复了导致“实时查询统计信息”在从活动监视器中启动并使用 SQL 身份验证时挂起的问题。Fixed an issue that was causing "Live Query Statistics" to hang when launched from Activity Monitor and SQL Authentication was used.

Microsoft Azure 集成:Microsoft Azure integration:

  • 修复了 SSMS 仅显示前 50 个订阅(“Always Encrypted”对话框、“从 URL 备份/还原”对话框以及其他对话框)的问题。Fixed an issue where SSMS only shows the first 50 subscriptions (Always Encrypted dialogs, Backup/Restore from URL dialogs, and other dialogs).
  • 修复了尝试(在“从 URL 中还原备份”对话框中)登录到不含任何存储帐户的 Microsoft Azure 帐户时,SSMS 引发异常(“索引超出范围”)的问题。Fixed an issue where SSMS was throwing an exception ("Index out of range") while trying to sign in to a Microsoft Azure account that did not have any storage account (in Restore Backup from URL dialog).

对象脚本:Object Scripting:

  • SSMS 现在可避免在编写脚本“删除和创建”时生成动态 T-SQL。When scripting "Drop and Create", SSMS now avoids generating dynamic T-SQL.
  • 编写数据库对象的脚本时,SSMS 现在不生成脚本来设置数据库范围内配置(如果设置为默认值的话)。When scripting a database object, SSMS now does not generate script to set database scoped configurations, if they are set to default values.

帮助:Help:

  • 修复了以下长期未得到解决的问题:“如何使用帮助”未采用联机/脱机模式。Fixed a long outstanding issue where "Help on Help" was not honoring the online/offline mode.
  • 当用户单击“帮助 | 社区项目和示例”时,SSMS 现在会打开默认浏览器,它指向 Git 页,其中不显示由于使用旧浏览器而发出的错误/警告。When clicking on "Help | Community Projects and Samples" SSMS now opens the default browser that points to a Git page and shows no errors/warnings due to old browser being used.

已知问题Known issues

重要

使用带有 SQL 查询编辑器的“Active Directory - 通用且具有 MFA 支持”身份验证时,用户可能会遇到关闭连接并在每次查询调用时重新打开连接的问题。When using Active Directory - Universal with MFA Support authentication with the SQL query editor, users may experience their connection being closed and reopened with each query invocation. 此类闭包的副作用包括意外删除全局临时表,有时会向连接提供新的 SPID。Side effects of such closure include global temporary tables being dropped unexpectedly and sometimes a new SPID being given to the connection. 如果连接上存在打开的事务,则不会发生闭包。This closure will not occur if there is an open transaction on the connection. 若要解决此问题,用户可以在连接参数中设置 persist security info=trueTo work around this issue, users can set persist security info=true in the connection parameters.

下载 SSMS 17.8.1download SSMS 17.8.1

在 17.8 中发现了与配置 SQL 数据库相关的错误,因此 SSMS 17.8.1 取代了 17.8。A bug was discovered in 17.8 related to provisioning SQL databases, so SSMS 17.8.1 replaces 17.8.

生成号:14.0.17277.0Build number: 14.0.17277.0
发布日期:2018 年 6 月 26 日Release date: June 26, 2018

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

新增功能What's new

常规 SSMSGeneral SSMS

数据库属性:Database Properties:

  • 此改进公开了文件组的 AUTOGROW_ALL_FILES 配置选项。This improvement exposes the AUTOGROW_ALL_FILES configuration option for Filegroups. 此新配置选项在“数据库属性”>“文件组”窗口下以每个可用文件组复选框的新列(自动增长所有文件)的形式添加(文件流和内存优化文件组除外)。This new config option is added under the Database Properties > Filegroups window in the form of a new column (Autogrow All Files) of checkboxes for each available Filegroup (except for Filestream and Memory Optimized Filegroups). 用户可以通过切换相应的 Autogrow_All_Files 复选框来为特定文件组启用/禁用 AUTOGROW_ALL_FILES。The user can enable/disable AUTOGROW_ALL_FILES for a particular Filegroup by toggling the corresponding Autogrow_All_Files checkbox. 相应地,在编写数据库脚本为数据库(SQL 2016 及更高版本)创建/生成脚本时,AUTOGROW_ALL_FILES 选项已正确编写脚本。Correspondingly, the AUTOGROW_ALL_FILES option is properly scripted when scripting the database for CREATE / generating scripts for the database (SQL2016 and above).

SQL 编辑器:SQL Editor:

  • 改进了当用户没有主访问权限时 Azure SQL 数据库中 Intellisense 的使用体验。Improved experience with Intellisense in Azure SQL Database when the user doesn't have master access.

脚本:Scripting:

  • 常规性能改进,尤其针对高延迟连接。General performance improvements, especially over high-latency connections.

Analysis Services (AS)Analysis Services (AS)

  • Analysis Services 客户端库和数据提供程序已更新到最新版本,该版本添加了对新 Azure 政府 AAD 颁发机构 (login.microsoftonline.us) 的支持。Analysis Services client libraries and data providers updated to the latest version, which added support for the new Azure Government AAD authority (login.microsoftonline.us).

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

维护计划:Maintenance Plans:

  • 修复了使用 SQL 身份验证编辑维护计划时出现的问题,即在使用 SQL 身份验证时,“通知操作员”任务失败。Fixed an issue when editing maintenance plans with Sql Authentication where "Notify Operator Task" was failing when using SQL authentication.

脚本:Scripting:

  • 修复了 SMO 中的 PostProcess 操作导致资源耗尽和 SQL 登录失败的问题Fixed an issue where PostProcess actions in SMO lead to resource exhaustion and SQL login failures

SMO:SMO:

Always Encrypted:Always Encrypted:

  • 修复了在分区表上启用 Always Encrypted 时导致锁超时错误的问题(在 DacFx 中)Fixed an issue (in DacFx) which was causing a lock timeout error when enabling Always Encrypted on a partitioned table

Analysis Services (AS)Analysis Services (AS)

  • 修复了在表格 Analysis Services 1400 级兼容性模型中修改 OAuth 数据源时出现的问题,该问题导致 OAuth 令牌中的更改未在数据源中更新。Fixed an issue that occurred when modifying an OAuth datasource in a Tabular Analysis Services 1400-level compatibility model, which caused the changes in the OAuth tokens to not get updated in the data source.
  • 修复了在 Analysis Services 表格 1400 级兼容性模型中使用某些无效数据源凭据或编辑不支持在 Power Query 中更改数据源迁移(例如,Oracle)的数据源时可能在 SSMS 中发生的故障。Fixed a crash in SSMS that may have occurred when using some invalid data source credentials or editing data sources that didn't support Change Data Source migration in Power Query (for example, Oracle) in Analysis Services Tabular 1400-level compatibility models.

已知问题Known issues

  • 在“属性”窗口中修改任何文件组属性后,单击“脚本”按钮,生成两个脚本 - 一个脚本带有“USE”语句,另一个脚本带有“USE master”语句。Clicking the Script button after modifying any filegroup property in the Properties window, generates two scripts - one script with a USE statement, and a second script with a USE master statement. 带有 USE master 的脚本错误生成,应该放弃。The script with USE master is generated in error and should be discarded. 运行包含 USE 语句的脚本。Run the script that contains the USE statement.
  • 使用新的“常规用途”或“业务关键”Azure SQL 数据库版本时,部分对话框显示版本无效错误。Some dialogs display an invalid edition error when working with new General Purpose or Business Critical Azure SQL Database editions.
  • 可能会观察到 XEvents 查看器中的一些延迟。Some latency in XEvents viewer may be observed. 这是 .Net Framework 中的已知问题This is a known issue in the .Net Framework. 考虑升级到 NetFx 4.7.2。Consider upgrading to NetFx 4.7.2.

下载 SSMS 17.7download SSMS 17.7

生成号:14.0.17254.0Build number: 14.0.17254.0
发布日期:2018 年 5 月 9 日Release date: May 09, 2018

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

新增功能What's new

常规 SSMSGeneral SSMS

复制监视器:Replication Monitor:

  • 现在,在发布服务器数据库和/或分发服务器数据库属于可用性组的情况下,复制监视器支持注册侦听器。Replication monitor now supports registering a listener for scenarios where publisher database and/or distributor database is part of Availability Group. 现在可以监视发布服务器数据库和/或分发数据库属于 AlwaysOn 的复制环境。You can now monitor replication environments where publisher database and/or distribution database is part of Always On.

Azure SQL 数据仓库:Azure SQL Data Warehouse:

  • 为 Azure SQL 数据仓库的外部表添加了“已拒绝的行位置”支持。Add Rejected Row Location support for External Tables in Azure SQL Data Warehouse.

Integration Services (IS)Integration Services (IS)

  • 为部署到 Azure SQL 数据库的 SSIS 包添加了计划安排功能。Added a scheduling feature for SSIS packages deployed to Azure SQL Database. 本地 SQL Server 和 SQL 数据库托管实例将 SQL Server 代理作为一级作业计划程序,与之不同的是,SQL 数据库并没有内置计划程序。Unlike SQL Server on premises and SQL Database Managed Instance, which have SQL Server Agent as a first-class job scheduler, SQL Database does not have a built-in scheduler. 这项新的 SSMS 功能可提供类似于 SQL Server 代理的熟悉用户界面,用于计划安排部署到 SQL 数据库的包。This new SSMS feature provides a familiar user interface that's similar to SQL Server Agent for scheduling packages deployed to SQL Database. 如果要使用 SQL 数据库承载 SSIS 目录数据库、SSISDB,可使用此 SSMS 功能生成计划 SSIS 包所需的数据工厂管道、活动和触发器。If you're using SQL Database to host the SSIS catalog database, SSISDB, you can use this SSMS feature to generate the Data Factory pipelines, activities, and triggers required to schedule SSIS packages. 然后可在数据工厂中编辑和扩展这些对象。You can then edit and extend these objects in Data Factory. 有关详细信息,请参阅通过 SSMS 计划安排 Azure SQL 数据库上的 SSIS 包执行For more info, For details, see Schedule SSIS package execution on Azure SQL Database with SSMS. 若要了解有关 Azure 数据工厂管道、活动和触发器的详细信息,请参阅 Azure 数据工厂中的管道和活动Azure 数据工厂中的管道执行和触发器To learn more about Azure Data Factory pipelines, activities, and triggers, For details, see Pipelines and activities in Azure Data Factory and Pipeline execution and triggers in Azure Data Factory.
  • 支持在 SQL 代理中计划安排在 SQL 托管实例上执行的 SSIS 包。Support for SSIS package scheduling in SQL Agent on SQL Managed instance. 现在可以创建 SQL 代理作业,在托管实例上执行 SSIS 包。It is now possible to create SQL Agent jobs to execute SSIS packages on the managed instance.

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

维护计划:Maintenance Plan:

Always On:Always On:

  • 修复了 AlwaysOn 延迟仪表板无法与 SQL Server 2012 一起使用的问题。Fixed an issue where Always On Latency Dashboard was not working with SQL Server 2012.

脚本:Scripting:

  • 修复了针对 Azure SQL 数据仓库的存储过程编写脚本不适用于非管理员用户的问题。Fixed an issue where scripting stored procedure against Azure SQL Data Warehouse, is not working for non-admin user.
  • 修复了针对 Azure SQL 数据库编写数据库脚本时不会为 SCOPED CONFIGURATION 属性编写脚本的问题。Fixed an issue where scripting a database against Azure SQL Database was not scripting the SCOPED CONFIGURATION properties.

遥测:Telemetry:

  • 修复了选择退出发送遥测后尝试连接服务器时 SSMS 崩溃的问题。Fixed issue where SSMS crashes then trying to connect to a server, after opting out of sending telemetry.

Azure SQL 数据库:Azure SQL Database:

  • 修复了用户无法设置或更改兼容性级别(下拉列表为空)的问题。Fixed an issue where the user was not able to set or change compatibility level (the drop-down from empty). 若要将兼容性级别设置为 150,用户仍需使用“脚本”按钮并手动编辑脚本。In order to set the compatibility level to 150, the user still needs to use the Script button and manually edit the script.

SMO:SMO:

Intellisense:Intellisense:

  • 性能改进:减少了列数据的 IntelliSense 查询量。Perf improvement: reduced volume of intellisense queries for column data. 处理包含大量列的表时,此功能特别有用。This is especially beneficial when working on tables with huge number of columns.

SSMS 用户设置:SSMS User settings:

  • 修复了不能正确调整选项页大小的问题。Fixed an issue where the options page was not resizing properly.

杂项:Misc:

  • 改进了“统计详细信息”页上文本的显示方式。Improved how text is displayed on Statistics details page.

Integration Services (IS)Integration Services (IS)

  • 实现了对 Azure SQL 数据库托管实例的更好支持。Better support for Azure SQL Database Managed Instance.
  • 修复了用户无法为 SQL Server 2014 或早期版本创建目录的问题。Fixed an issue where the user was unable to create a catalog for SQL Server 2014 or before.
  • 修复了两个有关报表问题:Fixed two issues with reports:
    • 删除了 Azure 服务器的计算机名称。Removed the machine name for Azure servers.
    • 改进了对本地化对象名称的处理方式。Improved handling of localized object name.

已知问题Known issues

使用新的“常规用途”或“业务关键”Azure SQL 数据库版本时,部分对话框显示版本无效错误。Some dialogs display an invalid edition error when working with new General Purpose or Business Critical Azure SQL Database editions.

下载 SSMS 17.6download SSMS 17.6

生成号:14.0.17230.0Build number: 14.0.17230.0
发布日期:2018 年 3 月 20 日Release date: March 20, 2018

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

新增功能What's new

常规 SSMSGeneral SSMS

SQL 数据库托管实例:SQL Database Managed Instance:

  • 添加了对 Azure SQL 数据库托管实例的支持。Added a support for Azure SQL Database Managed Instance. Azure SQL 数据库托管实例提供与本地 SQL Server 近 100% 的兼容性,是一个解决常见安全问题的本机虚拟网络 (VNet) 实现和一个有利于本地 SQL Server 客户的业务模型Azure SQL Database Managed Instance provides near 100% compatibility with SQL Server on-premises, a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for on-premises SQL Server customers.
  • 支持常见管理方案,例如:Support for common management scenarios like:
    • 创建和更改数据库。Create and alter databases.
    • 备份和还原数据库。Back up and restore databases.
    • 导入、导出、提取和发布数据层应用程序。Importing, exporting, extracting, and publishing Data-tier Applications.
    • 查看和更改服务器属性。Viewing and altering Server properties.
    • 完全支持对象资源管理器。Full Object Explorer support.
    • 编写数据库对象的脚本。Scripting database objects.
    • 支持 SQL 代理作业。Support for SQL Agent jobs.
    • 支持链接服务器。Support for Linked Servers.
  • 此处了解有关托管实例的更多信息。Learn more about Managed Instances here.

对象资源管理器:Object Explorer:

  • 添加了设置,以便在从对象资源管理器拖放至查询窗口时,不强制使用括号括住名称。Added settings to not force brackets around names when dragging & dropping from Object Explorer to Query Window. (用户建议 3291193332671051。)(User suggestions 32911933, and 32671051.)

数据分类:Data Classification:

  • 一般改进和 bug 修复。General improvements and bug fixes.

Integration Services (IS)Integration Services (IS)

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

数据分类:Data Classification:

  • 修复了数据分类中的问题,该问题导致显示的新添加的分类包含过时的“信息类型”和“敏感度标签”。Fixed an issue in *Data Classification that was causing newly added classifications to be displayed with stale information type and sensitivity label.
  • 修复了面向设置为区分大小写的排序规则的服务器集时,数据分类不起作用的问题。Fixed an issue where Data Classification was not working when targeting a server set to a case-sensitive collation.

Always On:Always On:

  • 修复了服务器设置为区分大小写的排序规则时,单击“收集延迟数据”可能导致错误的 AG 显示仪表板中的问题。Fixed an issue in AG Show Dashboard where clicking on Collect Latency Data could result in an error when the server was set to a case-sensitive collation.
  • 修复了群集服务关闭时,SSMS 错误地将 AG 报告为分布式的问题。Fixed an issue where SSMS was incorrectly reporting an AG as Distributed when the Cluster service shuts down.
  • 修复了使用“创建可用性组”对话框创建 AG 时需要 ReadOnlyRoutingUrl 的问题。Fixed an issue when creating AG using Create Availability Group dialog the ReadOnlyRoutingUrl is required.
  • 修复了主数据库出现故障,手动故障转移到辅助数据库时引发 NullReferenceException 的问题。Fixed an issue when the primary is down and manually failover to secondary, a NullReferenceException is thrown.
  • 修复了使用备份/还原创建可用性组以在次要副本上初始化数据库时,在默认目录中创建数据库文件的问题。Fixed an issue when creating Availability Group using backup/restore to initialize a database, on the secondary replicas, the database files are created in the default directory. 修复包括:The fix includes:
    • 添加数据/日志目录验证程序。Add the data/log directory validator.
    • 仅在副本位于不同于主要副本的 OS 上时才执行文件重定位操作。Only do the file relocation when the replica is on a different OS to the primary replica.
  • 修复了 SSMS 向导不生成 CLUSTER_TYPE 选项,导致辅助联接失败的问题。Fixed an issue where SSMS wizard doesn't generate CLUSTER_TYPE option, causing secondary join to fail.

安装程序:Setup:

  • 修复了在非默认位置安装 SSMS 时,尝试通过安装“升级包”升级 SSMS 失败的问题。Fixed issue where trying to upgrade SSMS by installing the "upgrade package" was failing when SSMS was installed in a non-default location.

SMO:SMO:

  • 修复了在 SQL Server 2016 及更高版本中编写表的脚本可能需要多达 30 秒(现在减少到了小于 1 秒)的性能问题。Fixed performance issue where scripting tables on SQL Server 2016 and above could take up to 30 seconds (now, it's down to less than 1 second).

对象资源管理器:Object Explorer:

  • 修复了在尝试展开对象资源管理器中的管理节点时,SSMS 可能会引发“不能将对象从 DBNull 强制转换为其他类型”异常的问题。Fixed an issue where SSMS could throw an exception like "Object cannot be cast from DBNull to other types" when trying to expand Management node in Object Explorer.
  • 修复了在用户定义的 PS 配置文件发出输出时,启动 PowerShell 未能检测到 SQLServer 模块的问题。Fixed an issue where Start PowerShell was not detecting the SQLServer module when user-defined PS profile emitted output.
  • 修复了右键单击对象资源管理器中的表或索引节点时,可能发生的间歇性挂起的问题。Fixed an intermittent hang that could occur when right-clicking a Table or Index node in Object Explorer.

数据库邮件:Database Mail:

  • 修复了尝试显示/管理 16 个以上的配置文件时,数据库邮件配置向导引发异常的问题。Fixed an issue where Database Mail Configuration Wizard was throwing an exception when trying to display/manage more than 16 profiles.

Analysis Services (AS)Analysis Services (AS)

  • 修复了修改 SSMS 中 1400 兼容性级别模型上的数据源后,所做更改未保存到服务器的问题。Fixed as issue where modifying a data source on a 1400 compatibility level model in SSMS the changes are not saved to the server.

Integration Services (IS)Integration Services (IS)

  • 修复了连接到 SQL 数据库托管实例时,SSMS 未显示 SSIS 目录节点和报表的问题Fixed an issue where SSMS did not show SSIS catalog node and reports when connected to SQL Database Managed Instance

已知问题Known issues

警告

存在已知问题:当使用维护计划时,SSMS 17.6 变得不稳定,甚至崩溃。There is a known issue where SSMS 17.6 becomes unstable and crashes when using Maintenance Plans. 如果使用维护计划,请勿安装 SSMS 17.6。If you use Maintenance Plans, do not install SSMS 17.6. 如果已经安装 SSMS 17.6,且此问题正在产生不良影响,请降级到 17.5。Downgrade to SSMS 17.5 if you already installed 17.6 and this issue is affecting you.

下载 SSMS 17.5download SSMS 17.5

正式发布版 | 生成号:14.0.17224.0Generally available | Build number: 14.0.17224.0

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

新增功能What's new

常规 SSMSGeneral SSMS

数据发现和分类:Data Discovery & Classification:

  • 添加了新的 SQL 数据发现和分类功能,可用于发现数据库中的敏感数据并对其进行分类、标记和报告。Added a new SQL Data Discovery & Classification feature for discovering, classifying, labeling & reporting sensitive data in your databases.
  • 自动发现最敏感的数据(如商业、金融、医疗和个人数据)并对其进行分类在组织的信息保护中可起到关键作用。Auto-discovering and classifying your most sensitive data (for example, business, financial, healthcare, personal data) can play a pivotal role in your organizational information protection stature.
  • 详细了解 SQL 数据发现和分类Learn more at SQL Data Discovery & Classification.

查询编辑器:Query Editor:

  • 为 Azure SQL DW 的带分隔符的文本外部文件格式添加了 SkipRows 选项的支持。Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW. 此功能允许用户在将带分隔符的文本文件加载到 SQL DW 时,跳过指定的行数。This capability allows users to skip a specified number of rows when loading delimited text files into SQL DW. 还为 FIRST_ROW 关键字添加了相应的 IntelliSense/SMO 支持。Also added the corresponding intellisense/SMO support for the FIRST_ROW keyword.

Showplan:Showplan:

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

Showplan:Showplan:

  • 修复了实时查询统计信息运行时间,以显示引擎执行时间(而非 LQS 连接运行时间)。Fixed Live Query Statistics elapsed time, to show engine execution time instead of time elapsed for LQS connection.
  • 修复了显示计划无法识别应用逻辑运算符(如 GbApply 和 InnerApply)的问题。Fixed an issue where showplan was not able to recognize Apply logical operators like GbApply and InnerApply.
  • 修复了与 ExchangeSpill 相关的问题。Fixed an issue related to ExchangeSpill.

查询编辑器:Query Editor:

  • 修复了在执行由“SET SHOWPLAN_ALL ON”开头的简单查询时,与 SPID 相关的问题,Fixed on issue related to SPIDs where SSMS could throw an error like "Input string was not in a correct format. 例如 SSMS 无法引发“输入字符串格式不正确。(mscorlib)”等错误。(mscorlib)" when executing a simple query preceded by a "SET SHOWPLAN_ALL ON".

SMO:SMO:

  • 修复了当服务器排序规则区分大小写时,SMO 无法提取 AvailabilityReplica 属性的问题(修复后,SSM 可显示错误消息,例如“无法绑定多部分标识符 a.delimited。”)Fixed an issue where SMO was not able to fetch AvailabilityReplica properties in case the server collation happened to be case-sensitive (as a result, SSMS could display an error message like "The multi-part identifier "a.delimited" could not be bound."
  • 修复了 DatabaseScopedConfigurationCollection 类中无法正确处理排序规则的问题(修复后,右键单击在具有区分大小写排序规则的服务器中运行的数据库时,在区域设置为土耳其语的 ma 计算机上运行的 SSMS 可显示错误,如“旧版基数估计不是有效范围配置”)。Fixed an issue in DatabaseScopedConfigurationCollection class, where incorrectly handling collations (as a result, an SSMS running on an ma machine with a Turkish locale could display an error like "legacy cardinality estimation is not valid scoped configuration" when right-clicking on a database running on a server with a case-sensitive collation).
  • 修复了 JobServer 类中 SMO 无法在 SQL 2005 服务器上提取 SQL 代理属性的问题(修复后,SSMS 可引发如“无法向局部变量分配默认值。Fixed an issue in JobServer class, where SMO was not able to fetch SQL Agent properties on a SQL 2005 server (as a result, SSMS was throwing an error like "Cannot assign a default value to a local variable. 必须声明标量变量“@ServiceStartMode”的错误,此外,SSMS 不会在对象资源管理器中显示 SQL 代理节点)。Must declare the scalar variable "@ServiceStartMode" and, ultimately, was not displaying the SQL Agent node in Object Explorer).

模板:Templates:

对象资源管理器:Object Explorer:

审核:Auditing:

  • 修复了“合并审核文件”功能的问题。Fixed an issue with the Merge Audit Files feature.

已知问题Known issues

数据分类:Data classification:

  • 如果删除一个分类并为相同的列手动添加一个新分类,则旧信息类型和敏感标签将被分配给主视图中的该列。Removing a classification and then manually adding a new classification for the same column results in the old information type and sensitivity label being assigned to the column in the main view.
    解决方法:在将分类添加回主视图之后且在保存之前,先分配新信息类型和敏感标签。Workaround: Assign the new information type and sensitivity label after the classification was added back to the main view and before saving.

download SSMS 17.4download SSMS 17.4

正式发布版 | 生成号:14.0.17213.0Generally available | Build number: 14.0.17213.0

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

新增功能What's new

常规 SSMSGeneral SSMS

漏洞评估:Vulnerability Assessment:

  • 添加了一个新的 SQL 漏洞评估服务,以扫描数据库的潜在漏洞和最佳方案偏差,如配置错误、权限过多和敏感数据公开。Added a new SQL Vulnerability Assessment service to scan your databases for potential vulnerabilities and deviations from best practices, such as misconfigurations, excessive permissions, and exposed sensitive data.
  • 评估结果包括旨在解决每个问题的可操作步骤,并提供自定义修正脚本(若适用)。Results of the assessment include actionable steps to resolve each issue and customized remediation scripts where applicable. 可以为每个环境自定义评估报表并进行调整以满足特定需求。The assessment report can be customized for each environment and tailored to specific requirements. 访问 SQL 漏洞评估了解详细信息。Learn more at SQL Vulnerability Assessment.

SMO:SMO:

  • 修复了 *HasMemoryOptimizedObjects 在 Azure 上引发异常的问题。Fixed issue where *HasMemoryOptimizedObjects were throwing exception on Azure.
  • 添加了对新 CATALOG_COLLATION 功能的支持。Added support for new CATALOG_COLLATION feature.

AlwaysOn 仪表板:Always On Dashboard:

  • 可用性组中的延迟分析有所改进。Improvements for latency analysis in Availability Groups.
  • 添加了两个新报表:AlwaysOn_Latency_Primary 和 AlwaysOn_Latency_Secondary。Added two new reports: AlwaysOn_Latency_Primary and AlwaysOn_Latency_Secondary.

Showplan:Showplan:

  • 已更新指向正确文档的链接。Updated links to point to correct documentation.
  • 允许直接从生成的实际计划进行单个计划分析。Allow single plan analysis directly from actual plan produced.
  • 新图标集。New set of icons.
  • 添加了对识别 GbApply、InnerApply 等“应用逻辑运算符”的支持。Added support for recognize "Apply logical operators" like GbApply, InnerApply.

XE 探查器:XE Profiler:

  • 更名为 XEvent 探查器。Renamed to XEvent Profiler.
  • 默认情况下,停止/启动菜单命令会立即停止/启动会话。Stop/Start menu commands now stop/start the session by default.
  • 启用了键盘快捷方式(例如,Ctrl+F 用于搜索)。Enabled keyboard shortcuts (for example, CTRL+F to search).
  • 向 XEvent 探查器会话中的相应事件添加了 database_name 和 client_hostname 操作。Added database_name and client_hostname actions to appropriate events in XEvent Profiler sessions. 为了使更改生效,你可能需要删除服务器上现有 QuickSessionStandard 或 QuickSessionTSQL 会话实例 - 连接 3142981For the change to take effect, you may need to delete existing QuickSessionStandard or QuickSessionTSQL session instances on the servers - Connect 3142981

命令行:Command line:

  • 添加了新的命令行选项 (“-G”),可以用于自动将 SSMS 连接到使用 Active Directory 身份验证(“集成”或“密码”)的服务器/数据库。Added a new command-line option ("-G") that can be used to automatically have SSMS connect to a server/database using Active Directory Authentication (either 'Integrated' or 'Password'). 有关详细信息,请参阅 Ssms 实用工具For details, see Ssms utility.

导入平面文件向导:Import Flat File Wizard:

  • 添加了一种方式,以在创建表时选择默认名称 (“dbo”) 以外的架构名称。Added a way to pick a schema name other than the default ("dbo") when creating the table.

查询存储:Query Store:

  • 在展开查询存储可用报表列表时,还原了“回归查询”报表。Restored the "Regressed Queries" report when expanding the Query Store available reports list.

Integration Services (IS)Integration Services (IS)

  • 在部署向导中添加了包验证函数,可帮助用户找出 SSIS 包内在 Azure SSIS IR 中不受支持的组件。Added package validation function in Deployment Wizard, which helps the user figure out components inside SSIS packages that are not supported in Azure-SSIS IR.

Bug 修复Bug fixes

常规 SSMSGeneral SSMS

  • 对象资源管理器:修复了表值函数节点未显示在数据库快照中的问题 - 连接 3140161Object Explorer: Fixed an issue where Table-Valued Function node was not showing up for database snapshots - Connect 3140161. 在服务器具有 autoclose 数据库的情况下,提高了在展开“数据库”节点时的性能。Improved performance when expanding Databases node when the server has autoclose databases.
  • 查询编辑器:修复了 IntelliSense 对于无权访问 master 数据库的用户不可用的问题。Query Editor: Fixed an issue where IntelliSense was failing for users that don't have access to the master database. 修复在远程计算机连接关闭时导致 SSMS 在某些情况下崩溃的问题 - 连接 3142557Fixed an issue that was causing SSMS to crash in some cases when the connection to a remote machine was closed - Connect 3142557.
  • XEvent 查看器:重新启用了该功能,以便导出到 XEL。XEvent Viewer: Re-enabled functionality to export to XEL. 修复了在某些情况下用户无法加载整个 XEL 文件的问题。Fixed issues where in some cases the user was not able to load an entire XEL file.
  • XEvent 探查器:修复了在用户没有“查看服务器状态”权限时,导致 SSMS 崩溃的问题。XEvent Profiler: Fixed an issue that was causing SSMS to crash when the user did not have VIEW SERVER STATE permissions. 修复了在关闭 XE 探查器实时数据窗口时未停止基础会话的问题。Fixed an issue where closing the XE Profiler Live Data window did not stop the underlying session.
  • 已注册的服务器:修复了“Move To…”命令停止工作的问题 - 连接 3142862连接 3144359Registered Servers: Fixed an issue where the "Move To..." command stopped working - Connect 3142862 and Connect 3144359.
  • SMO:修复了 Transfer 对象上 TransferData 方法不工作的问题。SMO: Fixed an issue where the TransferData method on the Transfer object was not working. 修复了 Server 数据库引发暂停 SQL DW 数据库异常的问题。Fixed an issue where Server databases throws exception for paused SQL DW databases. 修复了在编写针对 SQL 数据仓库的 SQL 数据库脚本时生成了不正确的 T-SQL 参数值的问题。Fixed an issue where scripting SQL database against SQL Data Warehouse generated incorrect T-SQL parameter values. 修复了在编写延伸 DB 脚本时,错误发出“DATA_COMPRESSION”选项的问题。Fixed an issue where scripting of a stretched DB incorrectly emitting the DATA_COMPRESSION option.
  • 作业活动监视器:修复了在用户尝试按类别进行筛选时收到“索引已超出范围。Job Activity Monitor: Fixed an issue where the user was getting an "Index was out of range. 必须为非负数且小于集合大小。Must be non-negative and less than the size of the collection. 参数名称:索引 (System.Windows.Forms)”错误的问题 - 连接 3138691Parameter name: index (System.Windows.Forms)" error when trying to filter by Category - Connect 3138691.
  • 连接对话框:修复了对读/写域控制器不具备访问权限的域用户无法使用 SQL 身份验证登录到 SQL Server 的问题 - 连接 2373381Connection Dialog: Fixed an issue where domain users without access to a Read/Write domain controller could not sign in to a SQL Server using SQL Authentication - Connect 2373381.
  • 复制:修复了在查看 SQL Server 中的请求订阅属性时,显示一个类似于“无法将值 'null' 应用到属性 ServerInstance”的错误的问题。Replication: Fixed an issue where an error similar to "Cannot apply value 'null' to property ServerInstance" was displayed when looking at properties of a pull subscription in SQL Server.
  • SSMS 安装:修复了 SSMS 安装错误导致计算机上所有已安装产品都要进行重新配置的问题。SSMS Setup: Fixed an issue where SSMS setup was incorrectly causing all the installed products on the machine to be reconfigured.
  • 用户设置:User Settings:
    • Azure 政府用户可以利用此修复,通过通用身份验证和 Azure Active Directory 登录,使用 SSMS 不间断地访问其 Azure SQL 数据库和 Azure 资源管理器资源。With this fix, Azure Government users have uninterrupted access to their Azure SQL Database and Azure Resource Manager resources with SSMS via Universal authentication and Azure Active Directory login. 使用以前版本 SSMS 的用户需要打开“工具”|“选项”|“Azure 服务”并在“资源管理”下,将“Active Directory 颁发机构”属性的配置更改为 https://login.microsoftonline.us。Users of prior versions of SSMS would need to open Tools|Options|Azure Services and under Resource Management change the configuration of the "Active Directory Authority" property to https://login.microsoftonline.us.

Analysis Services (AS)Analysis Services (AS)

  • 探查器:修复了尝试使用 Window 身份验证连接 Azure AS 时的问题。Profiler: fixed an issue when trying to connect using Window Authentication against Azure AS.
  • 修复了在取消有关 1400 模型的连接详细信息时可能会导致崩溃的问题。Fixed an issue that could cause a crash when canceling connection details on a 1400 model.
  • 刷新凭据时,在连接属性对话框中设置 Azure blob 密钥,它将被直观屏蔽。When setting an Azure blob key in the connection properties dialog when refreshing credentials, it will now be visually masked.
  • 修复了在搜索时,Azure Analysis Services 用户选择对话框显示应用程序 ID guid 而不是对象 ID 的问题。Fixed an issue in the Azure Analysis Services User selection dialog to show the Application ID guid instead of the Object ID when searching.
  • 修复了浏览数据库\MDX 查询设计器工具栏中导致图标不正确地映射到某些按钮的问题。Fixed an issue in the Browse Database\MDX query designer toolbar that caused the icons to be incorrectly mapped for some buttons.
  • 修复了阻止通过 msmdpump IIS http/https 地址连接到 SSAS 的问题。Fixed an issue that prevented connecting to SSAS using msmdpump IIS http/https addresses.
  • Azure Analysis Services 用户选取器对话框中的多个字符串现在均已转换为其他语言。Several strings in the Azure Analysis Services User Picker dialog have now been translated for additional languages.
  • MaxConnections 属性现对表格模型中的数据源可见。MaxConnections property is now visible for data sources in tabular models.
  • 现在,部署向导将为 Azure AS 角色成员生成正确的 JSON 定义。Deployment Wizard will now generate correct JSON definitions for Azure AS role members.
  • 修复了在 SQL 探查器中当选择针对 Azure AS 的 Windows 身份验证时仍会提示登录的问题。Fixed an issue in SQL Profiler where selecting Windows Authentication against Azure AS would still prompt for login.

下载 SSMS 17.3download SSMS 17.3

正式发布版 | 生成号:14.0.17199.0Generally available | Build number: 14.0.17199.0

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

增强功能Enhancements

  • 新添加的“导入平面文件”向导通过智能框架简化了 CSV 文件的导入体验,极大地减少了所需的用户干预或领域的专业知识。New "Import Flat File" wizard added to streamline the import experience of CSV files with an intelligent framework, requiring minimal user intervention, or specialized domain knowledge. 有关详细信息,请参阅将平面文件导入到 SQL 向导For details, see Import Flat File to SQL Wizard.
  • “XEvent 探查器”节点已添加到对象资源管理器。Added "XEvent Profiler" node to Object Explorer. 有关详细信息,请参阅使用 SSMS XEvent 探查器For details, see Use the SSMS XEvent Profiler.
  • 更新了性能仪表板历史等待报表中的等待过滤和分类。Updated waits filtering and categorization in Performance Dashboard historical waits report.
  • 添加了“预测”函数的语法检查。Added the syntax check of the "Predict" function.
  • 添加了外部库管理查询的语法检查。Added the syntax check of the External Library Management queries.
  • 添加了对外部库管理的 SMO 支持。Added SMO support for External Library Management.
  • 添加了对“已注册服务器”窗口的“启动 PowerShell”支持(需要新的 SQL PowerShell 模块)。Added "Start PowerShell" support to "Registered Servers" window (requires a new SQL PowerShell module).
  • AlwaysOn:已为可用性组添加只读路由支持Always On: added read-only routing support for availability groups.
  • 添加了一个用于将跟踪详细信息发送到“Active Directory - 含 MFA 支持的通用身份验证”登录的输出窗口(默认为关闭状态;必须在“工具”>“选项”>“Azure 服务”>“Azure 云”>“ADAL 输出窗口跟踪级别”下的用户设置中开启)。Added an option to send tracing details to the Output Window for "Active Directory - Universal with MFA support" logins (off by default; needs to be turned on in user settings under "Tools > Options > Azure Services > Azure Cloud > ADAL Output Window Trace Level").
  • 查询存储:Query Store:
    • 即使 QDS 为关闭状态,只要 QDS 已记录任何数据,就可以访问查询存储 UI。Query Store UI will be accessible even when QDS is OFF as long as QDS have recorded any data.
    • 查询存储 UI 现在会在所有现有报表中公开等待分类。Query Store UI now exposes waits categorization in all the existing reports. 这让客户解锁顶级等待查询等方案。This lets customers unlock the scenarios of Top Waiting Queries and many more.
  • 包含可选的脚本参数标头(默认为关闭状态;可在“工具”>“选项”>“SQL Server 对象资源管理器”>“脚本”>“包括脚本参数标头”下的用户设置中启用)- 连接项 3139199Made inclusion of the scripting parameters headers optional (off by default; can be enabled in user settings under "Tools > Options > SQL Server Object Explorer > Scripting > Include scripting parameters header") - Connect item 3139199.
  • 已删除“RC”商标。Removed "RC" branding.

Bug 修复Bug Fixes

常规 SSMSGeneral SSMS

  • XEvent:XEvent:
    • 修复了 SSMS 仅打开 .xel 文件中的部分事件的问题。Fixed issue where SSMS opens only part of the events in .xel file.
    • 改进了默认数据库不是“master”时的“查看实时数据”体验 - 连接项 1222582Improved "Watch Live Data" experience when default database is not 'master' - Connect item 1222582.
  • Always On:修复了“还原日志备份”可能出现故障的问题,其错误标志为“此备份集中的日志终止于 LSN x,该日志过早地应用到了数据库中”。Always On: Fixed issue where "Restore log backups" may fail with error "The sign in this backup set terminates at LSN x, which is too early to apply to the database".
  • 作业活动监视器:修复了不一致的图标 - 连接项 3133100Job Activity Monitor: fixed inconsistent icons - Connect item 3133100.
  • 查询存储:修复了用户无法为查询存储报表选择“自定义”日期范围的问题。Query Store: Fixed Issue where user cannot choose "custom" date range for Query Store reports. 链接到下面的连接项。Linked to below connect items.
  • 修复了保存的信息具有命名数据库和用户选择默认值时,连接对话框未“清除”最近使用的数据库的问题。Fixed issue where connection dialog doesn't "clear" the most recently used database when saved info has named database and user selects default.
  • 对象脚本:修复了用户在服务器上具有暂停的 DW 数据库,但选择了其他非 DW 数据库并尝试进行脚本编辑,在该情况下“生成数据库脚本”无法正常工作并引发了错误的问题。Object Scripting: Fixed an issue where "Generate database script" not working and throwing an error when the user has a paused DW database on the server, but selected another non-DW database and tried t script it. 修复了脚本化存储过程的标头与脚本设置不匹配,而导致生成误导性的脚本的问题 - 连接项 3139784Fixed issue where the header for scripted Stored Procedures was not matching the script settings, resulting in a misleading script - Connect item 3139784. 重新启用了在面向 Azure SQL 对象时的“脚本”按钮。Re-enabled the "Script button" when targeting Azure SQL objects. 修复了连接到 Azure SQL 数据库时,SSMS 不允许在某些对象(UDF、视图、SP、触发器)上为“更改”或“执行”编写脚本的问题 - 连接项 3136386Fixed issue where SSMS was not allowing scripting for "Alter" or "Execute" on some objects (UDF, View, SP, Trigger) when connected to an Azure SQL database - Connect item 3136386.
  • 查询编辑器:Query editor:
    • 改进了面向 Azure SQL 数据库时的智能功能。Improved intellisense when targeting Azure SQL databases.
    • 修复了查询由于身份验证令牌(通用身份验证)过期而失败的问题。Fixed an issue where queries failed due to an expired authentication token (Universal Authentication).
    • 改进了针对 Azure SQL 数据库工作时的智能功能(具体来说,连接到 Azure SQL 数据库时,会使用最新的 T-SQL 语法 (140))。Improved intellisense when working against Azure SQL databases (particularly, when connecting to Azure SQL Database, the latest T-SQL grammar (140) will be used).
    • 修复了在服务器上使用指向非数据仓库数据库的连接打开查询窗口,这一操作会导致该服务器指向数据仓库数据库的所有后续查询窗口引发各种有关不受支持的类型/选项的错误的问题。Fixed issue where open a query window with a connection to a non-DataWarehouse database on a server would cause all subsequent query windows for that server to DataWarehouse databases to throw various errors about unsupported types/options.
  • Always On:Always On:
    • 向 Always On 仪表板和 AG 属性页添加了种子设定模式列。Added For details, seeding mode column to Always On dashboard and AG properties page.
    • 修复了主系统为 Windows 时无法创建 Linux AG 的问题 - 连接项 3139856Fixed issue where it was not possible to create a Linux AG when primary is on Windows - Connect item 3139856.
  • 修复了运行查询时 SSMS 中出现的多个“内存不足”的问题 - 连接项 2845190连接项 3123864Fixed several "Out of Memory" issues in SSMS when running queries - Connect item 2845190, Connect item 3123864.
  • 探查器:Profiler:
    • 修复了面向 SQL 2005 时探查器不工作的问题。Fixed issue where Profiler was not working when targeting SQL 2005.
    • 修复了探查器不遵循“信任服务器证书”连接选项的问题。Fixed issue where Profiler was not honoring the "trust server certificate" connection option.
  • 活动监视器:修复了指向在 Linux 上运行的 SQL Server 时活动监视器不工作的问题。Activity Monitor: fixed an issue where Activity Monitor does not work when pointed at SQL Server running on Linux.
  • 修复了 SMO 传输类的相关问题,即它不会传输外部数据源或外部文件格式对象,这些类型的对象现在应正确包含在传输中。Fixed an issue with the SMO Transfer class where it wouldn't transfer External Data Source or External File Format objects, objects of those types should now correctly be included in the transfer.
  • 已注册的服务器:Registered Servers:
    • 启用了 UA 服务器的多服务器查询(它尝试在组中为每个 UA 服务器使用相同的令牌)。Enabled multiserver query for UA servers (it tries to use the same token for every UA server in the group).
  • AD 通用身份验证:AD Universal Authentication:
    • 修复了不支持 Azure AD 身份验证的问题。Fixed issue where Azure AD authentication was not supported.
    • 修复了表格/视图设计器不工作的问题。Fixed issue where table/view designer was not working.
    • 修复了“选择前 1000 行”和“编辑前 200 行”不工作的问题。Fixed issue where "Select Top 1000 rows" and "Edit Top 200 rows" were not working.
  • 数据库还原:修复了将文件移动到另一个位置时,还原操作会忽略路径中最后一个文件夹的问题。Database restore: fixed an issue where restore omits the last folder in the path when moving files to an alternate location.
  • 压缩向导:Compress wizard:
    • 修复了索引的管理压缩向导的相关问题;修复了压缩数据向导在 SQL 2016 和更低版本中中断的问题。Fixed an issue with manage compression wizard for indexes; fixed issue where compress data wizards were broken for SQL 2016 and lower. https://connect.microsoft.com/SQLServer/feedback/details/3139342
    • 向 Azure 表和索引添加了压缩向导。Added Compress wizard to Azure tables and indexes.
  • Showplan:Showplan:
    • 修复了未识别 PDW 运算符的问题。Fixed issue where PDW operators were not recognized.
  • 服务器属性:Server Properties:
    • 修复了无法修改服务器处理器关联的问题。Fixed issue with not being able to modify server processor affinity.

Analysis Services (AS)Analysis Services (AS)

  • 修复了有关部署向导的大量问题,以支持表格 1400 兼容级别模型和 Power Query 数据源。Fixed a number of issues with Deployment Wizard to support tabular 1400 compat-level models and Power Query data sources.
  • 从命令行运行时,部署向导现可部署到 AS Azure 中。Deployment Wizard can now deploy to AS Azure when running from command line.
  • 在 AS Azure 中使用 Windows 身份验证时,用户现在可在对象资源管理器中看到用户帐户的正确名称。When using Windows Auth in AS Azure the user will now For details, see the name of the user account in Object Explorer correctly.

此 17.3 版本中的已知问题:Known issues in this 17.3 release:

常规 SSMSGeneral SSMS

  • 对于使用含 MFA 的 UA 的 Azure AD 身份验证,不支持以下 SSMS 功能:The following SSMS functionality is not supported for Azure AD auth using UA with MFA:
    • 对于 Azure AD 身份验证,不支持数据库引擎优化顾问;存在以下已知问题:向用户显示的错误消息“无法加载文件或程序集 Microsoft.IdentityModel.Clients.ActiveDirectory,…”令人费解,而不是所需的“数据库引擎优化顾问不支持 Microsoft Azure SQL 数据库。Database Engine Tuning Advisor is not supported for Azure AD auth; there is a known issue where the error message presented to the user is a bit cryptic "Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,..." instead of the expected "Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient)”。(DTAClient)".
  • 尝试在 DTA 中分析查询会导致错误:“对象必须实现 IConvertible。Trying to analyze a query in DTA results in an error: "Object must implement IConvertible. (mscorlib)”。(mscorlib)".
  • 回归的查询缺少对象资源管理器中报表的查询存储列表。Regressed Queries is missing from the Query Store list of reports in Object Explorer.
    • 解决方法:右键单击“查询存储”节点,然后选择“查看回归的查询”。Workaround: Right-click the Query Store node and select View Regressed Queries.

Integration Services (IS)Integration Services (IS)

  • 对于 Scale Out 中的包执行,[catalog].[event_messagea] 中的 [execution_path] 不正确。[execution_path] 以“\Package”开头,而不是以包可执行文件的对象名称开头。The [execution_path] in [catalog].[event_messagea] is not correct for package executions in Scale Out. The [execution_path] starts with "\Package" instead of the object name of the package executable. 在 SSMS 中查看包执行的概述报表时,执行概述中“执行路径”的链接不起作用。When viewing the overview report of package executions in SSMS, the link of "Execution Path" in Execution Overview cannot work. 解决方法是,在概述报表上单击“查看消息”,检查所有事件消息。The workaround is to click "View Messages" on overview report to check all event messages.

download SSMS 17.2download SSMS 17.2

正式发布版 | 生成号:14.0.17177.0Generally available | Build number: 14.0.17177.0

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

增强功能Enhancements

  • 多重身份验证 (MFA)Multi-Factor Authentication (MFA)

    • 用于含多重身份验证的通用身份验证的多用户 Azure AD 身份验证(具有 MFA 的 UA)Multiple-user Azure AD authentication for Universal authentication with Multi-factor authentication (UA with MFA)
    • 为含 MFA 的通用身份验证添加了新的用户凭据输入字段,以支持多用户身份验证。A new user credential input field was added for Universal Authentication with MFA to support multi-user authentication.
  • 连接对话框现在支持以下 5 种身份验证方法:The connection dialog box now supports the following 5 authentication methods:

    • Windows 身份验证Windows Authentication
    • SQL Server 身份验证SQL Server Authentication
    • Active Directory - 含 MFA 支持的通用身份验证Active Directory - Universal with MFA support
    • Active Directory - 密码Active Directory - Password
    • Active Directory - 集成Active Directory - Integrated
  • DacFx 向导的数据库导出/导入使用含 MFA 的通用身份验证。Database export/import for DacFx wizard using Universal Authentication with MFA.

  • 有关 API 支持,请参阅 IUniversalAuthProvider 接口For API support, see IUniversalAuthProvider Interface.

  • 具有 MFA 的 Azure AD 通用身份验证使用的 ADAL 托管库已升级到 3.13.9 版本。ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to 3.13.9 version.

  • 此外,加入了新 CLI 接口,支持用于 SQL 数据库和 SQL 数据仓库的 Azure AD 管理设置。In addition, a new CLI interface was delivered supporting Azure AD admin setting for SQL Database and SQL Data Warehouse.

有关 Active Directory 身份验证方法的详细信息,请参阅使用 SQL 数据库和 SQL 数据仓库进行通用身份验证(MFA 的 SSMS 支持)配置 SQL Server Management Studio 的 Azure SQL 数据库多重身份验证For more information on the Active Directory authentication methods, For details, see Universal Authentication with SQL Database and SQL Data Warehouse (SSMS support for MFA) and Configure Azure SQL Database multi-factor authentication for SQL Server Management Studio.

  • 输出窗口具有在对象资源管理器节点扩展期间运行的查询条目Output window has entries for queries run during expansion of Object Explorer nodes

  • 为 Azure SQL 数据库启用了查看设计器Enabled View designer Azure SQL Databases

  • SSMS 中的对象资源管理器脚本对象的默认脚本选项已更改:The default scripting options for scripting objects from Object Explorer in SSMS have changed:

    • 以前,新安装的默认值是将生成的脚本面向最新版本的 SQL Server(当前为 SQL Server 2017)。Previously, the default on a new install was to have the generated script target the latest version of SQL Server (currently SQL Server 2017).
    • 在 SSMS 17.2 中添加了一个新选项:“将脚本设置与源进行匹配”。In SSMS 17.2 a new option has been added: Match Script Settings to Source. 当设置为 True 时,生成的脚本面向与要从其中脚本化对象的服务器相同的版本、引擎类型和引擎版本。When set to True, the generated script targets the same version, engine type, and engine edition as the server the object being scripted is from.
    • 默认情况下,“将脚本设置与源进行匹配”值设置为 True,因此新安装的 SSMS 将自动默认始终将对象脚本化到与原始服务器相同的目标。The Match Script Settings to Source value is set to True by default, so new installs of SSMS will automatically default to always scripting objects to the same target as the original server.
    • 当“将脚本设置与源进行匹配”设置为 False 时,正常的脚本目标选项将被启用,并像以前那样运行。When the Match Script Settings to Source value is set to False, the normal scripting target options will be enabled and function as they did previously. 此外,所有脚本选项已移动到其各自的部分 - 版本选项。Additionally, all the scripting options have been moved to their own section - Version Options. 它们不再位于“常规脚本选项”下。They are no longer under General Scripting Options.
  • 在“从 URL 还原”中增加了对国家云的支持Added support for National Clouds in "Restore from URL"

  • QueryStoreUI 报表现在支持来自 sys.query_store_runtime_stats 的其他指标(例如,RowCount、DOP 和 CLR Time)。QueryStoreUI reports now supports additional metrics (for example, RowCount, DOP, CLR Time) from sys.query_store_runtime_stats.

  • Azure SQL 数据库现在支持 IntelliSense https://connect.microsoft.com/SQLServer/feedback/details/3100677/ssms-2016-would-be-nice-to-have-intellisense-on-azure-sql-databasesIntelliSense is now supported for Azure SQL Database https://connect.microsoft.com/SQLServer/feedback/details/3100677/ssms-2016-would-be-nice-to-have-intellisense-on-azure-sql-databases

  • 安全性:连接对话框将默认不信任服务器证书,并为 Azure SQL DB 连接请求加密Security: connection dialog will default to not trusting server certificates and to requesting encryption for Azure SQL DB connections

  • 对 Linux 上的 SQL Server 支持的常规改进:General improvements around support for SQL Server on Linux:

  • 重新使用数据库邮件节点Database Mail node is back

  • 解决了与路径相关的其他问题Addressed misc issues related to paths

  • 活动监视器更加稳定Activity Monitor is more stable

  • “连接属性”对话框将显示正确的平台Connection Properties dialog displays correct platform

  • 现在可将性能仪表板服务器报表用作默认报表:Performance Dashboard server report now available as a default report:

    • 可连接到 SQL Server 2008 和更新版本。Can connect to SQL Server 2008 and newer versions.
    • 缺失索引子报表使用计分来帮助确定最有用的索引。Missing indexes sub-report uses scoring to assist in identifying most useful indexes.
    • 历史等待统计信息子报表现在将等待聚合为类别。Historical wait stats subreport now aggregates waits be category. 默认情况下,将筛选出空闲和睡眠等待。Idle and sleep waits filtered out by default.
    • 新的历史闩锁子报表。New Historical latches subreport.
  • Showplan 节点搜索允许在计划属性中进行搜索。Showplan node search allows searching in plan properties. 轻松查找任何操作符属性,如表名。Easily look for any operator property such as table name. 在查看计划时使用此选项:To use this option when viewing a plan:

    • 右键单击计划,并在上下文菜单中单击“查找节点”选项Right-click on plan, and in the context menu click on Find Node option
    • 使用 Ctrl+FUse CTRL+F

Analysis Services (AS)Analysis Services (AS)

  • 用于在 SSMS 中的 AS Azure 模型中无电子邮件地址用户的新的 AAD 角色成员选择New AAD role member selection for users without email addresses in AS Azure models in SSMS

Integration Services (IS)Integration Services (IS)

  • 向 SSIS 的执行报表添加了新列(“执行计数”)Added new column ("Executed Count") to the execution report for SSIS

此版本中的已知问题:Known issues in this release:

  • 使用“Active Directory - 含 MFA 支持的通用身份验证”身份验证的查询窗口在打开一小时后尝试执行查询时可能会遇到类似以下错误:Query windows using "Active Directory - Universal with MFA Support" authentication may experience an error similar to the following, when attempting to execute a query after being open for one hour:

    Msg 0, Level 11, State 0, Line 0 The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts.

    重新运行查询应忽略错误并成功。Rerunning the query should get past the error and succeed.

  • 对于使用含 MFA 的通用身份验证的 Azure AD 身份验证,不支持以下 SSMS 功能:The following SSMS functionality is not supported for Azure AD auth using Universal Authentication with MFA:

    • “新建表/视图”设计器显示旧式登录提示,并且不适用于 Azure AD 身份验证。The New Table/View designer shows the old-style login prompt, and does not work for Azure AD authentication.
    • “编辑前 200 行”功能不支持 Azure AD 身份验证。The Edit Top 200 Rows feature doesn't support Azure Ad authentication.
    • “已注册的服务器”组件不支持 Azure AD 身份验证。The Registered Server component does not support Azure AD authentication.
    • “数据库引擎优化顾问”不支持 Azure AD 身份验证。The Database Engine Tuning Advisor is not supported for Azure AD authentication. 存在以下已知问题:向用户显示的错误消息:“无法加载文件或程序集 Microsoft.IdentityModel.Clients.ActiveDirectory,…”帮助不大,而不是所需的“数据库引擎优化顾问不支持 Microsoft Azure SQL 数据库 。(DTAClient)”There is a known issue where the error message presented to the user is less than helpful: Could not load file or assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory,... instead of the expected Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).

Analysis Services (AS)Analysis Services (AS)

  • SSAS 中的对象资源管理器将不会在 AS Azure 连接属性中显示 Windows 身份验证用户名。Object Explorer in SSAS will not show the Windows Auth username in AS Azure connection properties.

Bug 修复Bug fixes

  • 修复了尝试打印查询结果(打印成文本)时的问题。Fixed an issue when trying to print the results of a query (as text). https://connect.microsoft.com/SQLServer/feedback/details/3055225/https://connect.microsoft.com/SQLServer/feedback/details/3055225/
  • 修复了在 Azure SQL 数据库上通过编写脚本的方式删除此类对象时 SSMS 未正确删除表和其他对象的问题。Fixed an issue where SSMS was incorrectly dropping tables and other objects when scripting the deletion of such objects on a Azure SQL database.
  • 修复了以下问题:SSMS 偶尔拒绝启动,出现错误“找不到一个或多个组件。Fixed an issue where SSMS occasionally SSMS refuses to start with an error like "Cannot find one or more components. 请重新安装应用程序”Please reinstall the application"
  • 修复了 SSMS UI 中的 SPID 可能会过时和不同步的问题。 https://connect.microsoft.com/SQLServer/feedback/details/1898875Fixed an issue where the SPID in SSMS UI could get stale and out of sync. https://connect.microsoft.com/SQLServer/feedback/details/1898875
  • 修复了 SSMS(无提示)安装中 /passive 参数被视为 /quiet 的问题。Fixed an issue in SSMS (silent) setup where the /passive argument was treated as /quiet.
  • 修复了 SSMS 偶尔在启动时引发“未将对象引用设置为对象的实例”错误的问题。Fixed an issue where SSMS occasionally throws an "Object reference not set to an instance of the object" error on startup. https://connect.microsoft.com/SQLServer/feedback/details/3134698https://connect.microsoft.com/SQLServer/feedback/details/3134698
  • 修复了“数据压缩向导”上导致 SSMS 在图形表上按“计算”会崩溃的问题Fixed an issue on the "Data Compression Wizard" that was causing SSMS to crash when pressing 'Calculate' on Graph Table
  • 解决了右键单击表的索引(通过缓慢的 Internet 连接)时遇到性能问题。Addressed performance issue when right-clicking on an index for a table (over a slow internet connect). https://connect.microsoft.com/SQLServer/feedback/details/3120783https://connect.microsoft.com/SQLServer/feedback/details/3120783
  • 修复了 SSMS 无法枚举使用区分大小写排序规则的服务器上的备份文件的问题。Fixed an issue where SSMS was not able to enumerate backup files on servers with a case-sensitive collation. https://connect.microsoft.com/SQLServer/feedback/details/3134787 和 https://connect.microsoft.com/SQLServer/feedback/details/3137000https://connect.microsoft.com/SQLServer/feedback/details/3134787 and https://connect.microsoft.com/SQLServer/feedback/details/3137000
  • 显示计划和显示计划比较各种修复Showplan and showplan compare assorted fixes
  • 修复了以下问题:除非运行 SSMS 的计算机上安装了 SQL Server,否则连接对话框不允许用户指定用于连接的“网络协议”。Fixed an issue where the Connection Dialog was not allowing the user to specify the "Network Protocol" to use for the connection, unless SQL Server was installed on the machine running SSMS. https://connect.microsoft.com/SQLServer/feedback/details/3134997https://connect.microsoft.com/SQLServer/feedback/details/3134997
  • 改进了对多监视器配置的支持,其中某些 SSMS 对话框显示在“随机”位置。Improved support for multi-monitor configurations where some SSMS dialog were showing up on "random" locations. 在“SQL Server 对象资源管理器 | 命令”用户设置下添加了新选项“任务对话框”,以便任务对话框或属性表关闭时记住其位置。Added new option "Task Dialogs" under "SQL Server Object Explorer | Commands" user settings to allow remembering the position of a task dialog or property sheet when it closes. https://connect.microsoft.com/SQLServer/feedback/details/889169、 https://connect.microsoft.com/SQLServer/feedback/details/1158271、 https://connect.microsoft.com/SQLServer/feedback/details/3135260https://connect.microsoft.com/SQLServer/feedback/details/889169, https://connect.microsoft.com/SQLServer/feedback/details/1158271, https://connect.microsoft.com/SQLServer/feedback/details/3135260
  • 修复了 SSMS 无法更改加密的 Azure SQL DB 的 DB 属性的问题Fixed an issue where SSMS was not able to change DB properties for encrypted Azure SQL DB
  • 改进了“执行后放弃结果”选项。Improved "Discard results after execution" option. https://connect.microsoft.com/SQLServer/feedback/details/1196581https://connect.microsoft.com/SQLServer/feedback/details/1196581
  • 改进/修复了用户无法访问其不是管理员的 Azure 订阅的问题。Improved/fixed issue where users are not able to access Azure subscriptions for which they are not administrators.
  • 改进了“数据库恢复”向导以保持在 OE 中选择目标数据库(无论选择什么源数据库)。Improved "Database Restore" wizard to keep the target database selected in OE regadless of the source database selection. https://connect.microsoft.com/SQLServer/feedback/details/3118581https://connect.microsoft.com/SQLServer/feedback/details/3118581
  • 修复了对象资源管理器未正确排序新添加的“本机编译的存储过程”的问题。Fixed an issue where Object Explorer was not sorting incorrectly newly added "Natively compiled stored procedures". https://connect.microsoft.com/SQLServer/feedback/details/3133365https://connect.microsoft.com/SQLServer/feedback/details/3133365
  • 修复了“SELECT TOP n ROWS”不包含“TOP”子句的问题。Fixed an issue where "SELECT TOP n ROWS" did not include the "TOP" clause. 对于 Azure SQLDW。For Azure SQLDW. https://connect.microsoft.com/SQLServer/feedback/details/3133551 和 https://connect.microsoft.com/SQLServer/feedback/details/3135874https://connect.microsoft.com/SQLServer/feedback/details/3133551 and https://connect.microsoft.com/SQLServer/feedback/details/3135874
  • QueryStoreUI:修复了非自定义时间间隔对于所有报表都无法正确工作的问题。QueryStoreUI: fixed issue where non-custom time intervals were not working correctly for all reports.
  • Always Encrypted:改进了新 CMK 对话框中 AKV 权限状态的消息传递。向 CEK 下拉列表添加了工具提示,以便更容易区分具有长名称的 CEK 修复了某些 CNG 密钥存储提供程序不会显示在 Always Encrypted 的“新列主密钥”对话框中的问题Always Encrypted: Improved messaging for AKV permission status in New CMK dialog Added tooltips to CEK dropdown to make it easier to distinguish CEKs with long names Fixed an issue where some CNG key store providers would not be displayed in the New Column Master Key dialog for Always Encrypted
  • 修复了 SSMS 连接的“应用程序名称”不一致的问题。Fixed inconsistent "Application Name" for SSMS connections. https://connect.microsoft.com/SQLServer/feedback/details/3135115https://connect.microsoft.com/SQLServer/feedback/details/3135115
  • 修复了 SSMS 未为 Azure SQL(具有 DATA_COMPRESSIONS 选项的表和索引)生成正确脚本的问题。Fixed an issue where SSMS was not generating correct scripts for Azure SQL (tables and indexes with DATA_COMPRESSIONS option). https://connect.microsoft.com/SQLServer/feedback/details/3133148https://connect.microsoft.com/SQLServer/feedback/details/3133148
  • 修复了用户无法使用 Ctrl+Q 快捷方式进行快速启动的问题(在查询编辑器中切换“启用 IntelliSense”选项的新键绑定现在是 Ctrl+B、Ctrl+I)。Fixed an issue where user was not able to use CTRL+Q shortcut for Quick Launch (the new key bindings to toggle the "IntelliSense Enabled" option in Query Editor is now CTRL+B, CTRL+I. https://connect.microsoft.com/SQLServer/feedback/details/3131968https://connect.microsoft.com/SQLServer/feedback/details/3131968
  • 修复了“还原数据库”中,SSMS 在尝试从具有定义了自定义域的帐户的订阅中选择存储帐户时引发异常的问题Fixed an issue in "Restore Database" where SSMS was throwing an exception when trying to select a storage account from a subscription that has accounts with custom domains defined
  • 修复了“数据库关系图”中 SSMS 引发“索引超出了数组界限”错误的问题;以及用户无法将“表视图”更改为除标准之外的任何内容的问题。Fixed an issue in "Database Diagram" where SSMS was throwing an "Index was outside the bounds of the array" error; also, the user was not able to change the "Table View" to anything but standard. https://connect.microsoft.com/SQLServer/feedback/details/3133792 和 https://connect.microsoft.com/SQLServer/feedback/details/3135326https://connect.microsoft.com/SQLServer/feedback/details/3133792 and https://connect.microsoft.com/SQLServer/feedback/details/3135326
  • 修复了“备份/还原到 URL”中 SSMS 没有枚举经典存储帐户的问题。Fixed an issue in "Backup/Restore to URL" where SSMS was not enumerating classic storage accounts.
  • 修复了在尝试向 DB 角色添加架构绑定安全对象时引发异常的问题。Fixed an issue where an exception was being thrown when trying to add schema-bound securables to DB Roles. https://connect.microsoft.com/SQLServer/feedback/details/3118143https://connect.microsoft.com/SQLServer/feedback/details/3118143
  • 修复了 SSMS 间歇性显示错误“数据为 Null。Fixed an issue where SSMS was intermittently showing the error "Data is Null. 不能对 Null 值调用此方法或属性。”的问题This method or property cannot be called on Null values." 当展开表节点 https://connect.microsoft.com/SQLServer/feedback/details/3136283when expanding a table node https://connect.microsoft.com/SQLServer/feedback/details/3136283
  • DTA:修复了当使用特定边界值评估分区功能时,DTAEngine.exe 因堆损坏终止的问题。DTA: Fixed an issue where DTAEngine.exe terminates with Heap Corruption when evaluating Partition Function with Certain Boundary Values.

Analysis Services (AS)Analysis Services (AS)

  • 修复了如果 DB 具有与 ID 不同的名称,AS 还原数据库将失败并出现错误的问题Fixed an issue where AS Restore Database would fail with an error if the DB had a different Name than ID
  • 修复了导致 DAX 查询窗口忽略用于切换已启用 IntelliSense 功能的菜单选项的问题Fixed an issue causing the DAX query window to disregard the menu option for toggling IntelliSense Enabled
  • 修复了阻止通过 msmdpump IIS http/https 地址连接到 SSAS 的问题Fixed an issue that prevented connecting to SSAS through msmdpump IIS http/https addresses
  • 允许使用包含分号的密码连接到 AS AzureAllow connecting to AS Azure using a password that contains a semi-colon
  • 使用“跳过成员身份”选项脚本化 AS 还原数据库命令将包括与 SQL Server 2017 AS 服务器或 AS Azure 一起使用时的新对应 JSON 选项Scripting out AS Restore Database command with "Skip Membership" option will include the new corresponding JSON option when used with SQL Server 2017 AS server or AS Azure
  • 修复了一个非常罕见的问题,该问题可能导致删除数据库对话框在加载时出错Fixed an extremely rare issue that could cause the delete database dialog to raise an error when loading
  • 修复了尝试在包含混合了 SQL 查询和 M 分区定义的 1400 兼容级别模型中查看分区时可能会出现的问题Fixed an issue that may occur when attempting to view partitions in 1400-compat level model containing a mix of SQL query and M partition definitions

Integration Services (IS)Integration Services (IS)

  • 修复了无法显示 SSISDB 目录的执行信息报表的问题Fixed issue where the execution information reports of SSISDB catalog can't be displayed
  • 修复了 SSMS 中与大量项目/包性能不佳相关的问题Addressed issues in SSMS related to poor performance with large number of projects/packages

下载 SSMS 17.1download SSMS 17.1

正式发布版 | 生成号:14.0.17119.0Generally available | Build number: 14.0.17119.0

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

增强功能Enhancements

  • 探查器:“帮助”>“关于”现在显示发行版本号(例如 17.1)Profiler: Help > About now displays release version number (e.g 17.1)
  • Analysis Service 用户可以从数据源上的上下文菜单中针对 1200 TM 模型及更高版本刷新其数据源的凭据Analysis Service users can refresh credentials for their datasources for 1200 TM models and above from the context menu on the datasource
  • 内置 SSIS 报表现在可显示 CTP 2.1 中 SSIS 扩展执行的日志Built-in SSIS reports now show logs from SSIS scale-out execution in CTP 2.1
  • SSIS 扩展管理应用程序SSIS scale-out management application
    • 查看扩展主要角色的基本信息。View basic information about scale-out master.
    • 轻松向扩展部署添加辅助角色。Easily add a Worker to the scale-out deployment.
    • 查看所有扩展辅助角色及其相关基本信息,还可将它们轻松启用或禁用。View all the scale-out workers and basic information about them, and can also enable or disable them easily.

Bug 修复Bug fixes

  • Always On:Always On:
    • 修复了可用性副本的属性对于 WSFC AG 始终显示为“自动故障转移”模式的问题。Fixed an issue where the properties of an Availability Replica was always displayed as "Automatic failover" mode for WSFC AGs.
    • 修复了更新可用性组时覆盖只读路由列表的问题Fixed an issue where the read-only routing list was overwritten when updating the Availability Group
  • Always Encrypted:修复了生成的日志文件缺少 DacFx 生成的信息的问题。Always Encrypted: fixed an issue where log file generated was missing the information generated by DacFx.
  • 显示计划:修复了用户界面总是显示非自适应联接运算符的实际联接类型属性的问题。ShowPlan: fixed in issue where the UI was always showing the Actual join type attribute for non-adaptive join operators.
  • 安装程序:Setup:
    • 修复了 SSMS 17.0 中断 Visual Studio 2013 上的 SSDT 的问题 [Connect 项目 3133479]Fixed an issue where SSMS 17.0 was breaking SSDT on Visual Studio 2013 [Connect Item 3133479]
    • 修复了安装结束时单击“重启”不会重启计算机的问题Fixed an issue where clicking on "Restart" at the end of setup was not restarting the machine
  • 脚本:通过禁用选项,暂时阻止了 SSMS 尝试编写删除脚本时误删 Azure 数据库对象的问题。Scripting: temporarily preventing SSMS from accidentally deleting Azure database objects when trying to script the deletion by disabling that option. 即将发布的 SSMS 版本中将提供正式修复。Proper fix will be in an upcoming release of SSMS.
  • 对象资源管理器:修复了使用“AS COPY”将“数据库”节点连接到创建的 Azure 数据库时此节点无法展开的问题Object Explorer: fixed an issue where "Databases" node was not expanded when connected to an Azure database created using "AS COPY"

下载 SSMS 17.0download SSMS 17.0

正式发布版 | 生成号:14.0.17099.0Generally available | Build number: 14.0.17099.0

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

增强功能Enhancements

  • 升级包和 Windows Software Update Services (WSUS) 未来的 17.X 版本包括较小的累积更新包Upgrade package and Windows Software Update Services (WSUS) Future 17.X releases include a smaller cumulative update package
    • 更新包还将发布到 WSUS 目录The update package will also be published to the WSUS catalog
  • 图标更新 已更新图标,其与 VS Shell 提供的图标保持一致并且支持高 DPI 分辨率 新增了 SSMS 和探查器程序图标,用于区分 16.X 和 17.X 版本Icon Updates Icons have been updated to be consistent with VS Shell provided icons and support High DPI resolutions New SSMS and Profiler program icons to differentiate between 16.X and 17.X versions
  • SQL PowerShell 模块SQL PowerShell Module
    • 已从 SSMS 中删除 SQL Server PowerShell 模块,现通过 PowerShell 库提供(现在需要 PowerShell 5.0 才能支持模块版本控制)SQL Server PowerShell module removed from SSMS and now ships via the PowerShell gallery (PowerShell 5.0 now required to support module versioning)
    • 对一些 SMO 对象的“演示”(格式设置)进行了其他改进(例如,数据库现在显示大小和可用空间,表显示行计数和空间使用情况)Miscellaneous improvements to the "presentation" (formatting) of some SMO objects (e.g. databases now show the size and the available space and tables show row count and space usage)
    • 对通过 OE 中的“启动 PowerShell”菜单调用的 PowerShell 命令提示符添加了着色Added colorization when the PowerShell command prompt is invoked from the "Start PowerShell" menu in OE
    • 向 AG cmdlet(New-SqlAvailabilityGroup、Join-SqlAvailabilityGroup 和 Set-SqlAvailabilityGroup cmdlet)添加了 -ClusterType 和 -RequiredCopiesToCommit 参数Added -ClusterType and -RequiredCopiesToCommit parameter to AG cmdlets (New-SqlAvailabilityGroup, Join-SqlAvailabilityGroup, and Set-SqlAvailabilityGroup cmdlets)
    • 向 Add-SqlAzureAuthenticationContext cmdlet 添加了 -ActiveDirectoryAuthority 和 -AzureKeyVaultResourceId 参数Added parameters -ActiveDirectoryAuthority and -AzureKeyVaultResourceId to Add-SqlAzureAuthenticationContext cmdlet
    • 添加了 Revoke SqlAvailabilityGroupCreateAnyDatabase、Grant-SqlAvailabilityGroupCreateAnyDatabase 和 Set-SqlAvailabilityReplicaRoleToSecondary cmdletAdded Revoke-SqlAvailabilityGroupCreateAnyDatabase, Grant-SqlAvailabilityGroupCreateAnyDatabase and Set-SqlAvailabilityReplicaRoleToSecondary cmdlets
    • 向 Set-SqlAvailabilityReplica 和 New-SqlAvailabilityReplica cmdlet 添加了 SeedingMode 参数Added -For details, seedingMode parameter to Set-SqlAvailabilityReplica and New-SqlAvailabilityReplica cmdlets
    • 向 Get-SqlDatabase 添加了 -ConnectionString 参数Added -ConnectionString parameter to Get-SqlDatabase
  • Linux 上的 SQL Server 全面改进和修复了日志传送SQL Server on Linux General improvements and fixes for Log Shipping
    • 添加了对本机 Linux 路径附加、还原和备份数据库的支持Added support for native Linux paths Attach, Restore and Backup database
    • 添加了对审核日志目标文件夹的本机 Linux 路径的支持Added support for native Linux paths for audit log destination folder
  • Analysis ServicesAnalysis Services
    • DAX 查询窗口:DAX Query Window:
      • 编辑器中的括号匹配Parentheses matching in the editor
      • DEFINE MEASURE 和 DEFINE VAR 语法支持DEFINE MEASURE and DEFINE VAR syntax support
      • 多种 Intellisense 改进Assorted Intellisense improvements
    • 通用身份验证Universal Authentication
      • 允许用户指定用户名而不指定密码,然后 Azure 登录对话框将处理连接Allows users to specify a username and no password and the Azure Login Dialog will handle the connection
    • SSMS PQ 集成:SSMS PQ Integration:
      • 支持对结构化数据源编写脚本Scripting of structured data sources works
      • 在 PQ UI 中查看和编辑结构化数据源Viewing and Editing of structured data sources in PQ UI
  • 新增了“添加唯一约束”模板New "Add Unique Constraint" template
  • 显示计划在运行时间的属性窗口中显示线程最大值(而非总和) 公开了新的内存授予运算符属性 在实时查询统计信息中启用了“编辑查询”按钮 支持交错执行Showplan Show max instead of sum across the threads in properties window for elapsed time Expose new mem grant operator properties Enabled the "Edit Query" button in Live Query Statistics Support for interleaved execution
    • 为“分析实际执行计划”提供了新选项New option to "Analyze Actual Execution Plan"
    • 对显示计划比较进行了整体改进General improvements to showplan compare
    • 在“显示计划比较”功能中引入了功能,可用于查找两个查询计划的匹配节点间基数估计的显著区别,并对可能的根本原因执行基本分析Introduced functionality in Showplan Comparison feature to find significant differences in Cardinality Estimation between matching nodes of two query plans and perform basic analysis of the possible root causes
  • 从已注册的服务器资源管理器中删除了配置管理器Removed Configuration Manager from Registered Servers explorer
  • 支持从 Azure Blob 存储中读取审核日志Enable reading audit logs from Azure blob storage
  • 添加了“始终加密的参数化”,有关详细信息请参阅本页Added Parameterization for Always Encrypted, please refer to this page for more details
  • AAD 通用身份验证连接到 Azure SQL DB 支持自定义租户 IDAAD Universal auth connection to Azure SQL DB supports custom tenant ID
  • 为 Azure SQL 数据库生成脚本,现在为全文、规则和数据库编写脚本Generate scripts for Azure SQL Database, now scripts full text, rules, and database
  • 解决了 SSMS 和探查器的初始屏幕的外观方案问题Branding fixes in splash screens for SSMS and Profiler
  • 从 SSMS 删除了实用工具控制点 UIRemoved Utility Control Point UI from SSMS
  • SSMS 现在可以创建“PremiumRS”版 Azure SQL 数据库SSMS can now create "PremiumRS" edition Azure SQL databases
  • AlwaysOn 可用性组Always On Availability Groups
    • 添加了对新群集类型:EXTERNAL 和 NONE 的支持。添加了对 Linux 上的 SQL Server 的支持。为初始数据同步添加了自动种子设定选项。修复了一些不足,包括终结点 URL 处理、DB 刷新和用户界面布局。删除了 Azure 副本相关功能Add support for new cluster types: EXTERNAL and NONE Add support for SQL Server on Linux Add automatic For details, seeding as an option for initial data synchronization Fixed some defects, e.g. endpoint URL handling, DB refresh and UI layout Removed Azure replica-related features
    • 改进了几个可用性组关键字的 IntelliSenseImproved IntelliSense for several Availability Group keywords
  • 活动监视器Activity Monitor
    • 在 SSMS 输出窗口中添加了新的“活动监视器”窗格Added new "Activity Monitor" pane to the SSMS Output window
    • 将连接错误/超时消息更改为输出窗口的日志信息,而不是弹出消息Changed connection error/timeout message to log info to output window rather than a pop-up message
    • 删除了“概述”部分中的空图表(第 5 个图表)Removed empty chart (5th chart) in Overview section
    • 针对活动监视器数据收集暂停的情况,在“概述”标题中添加了“(暂停)”Added "(paused)" to Overview title if the Activity Monitor data collection is paused
    • SQL Server 图形扩展 为图形节点和边缘表提供了新图标 图形节点和边缘表将在“图形表”文件夹下显示 提供了用于创建图形节点和边缘表的模板Graph Extensions to SQL Server New icons for graph node and edge tables Graph node and edge tables will be displayed under Graph Tables folder Templates to create graph node and edge tables available
  • 演示文稿模式 新增了 3 个可通过快速启动 (Ctr-Q) 执行的任务 PresentOn - 打开演示模式 PresentEdit - 编辑演示模式的演示字号。Presentation Mode 3 new tasks available via Quick Launch (Ctr-Q) PresentOn - Turn on presentation mode PresentEdit - Edit the presentation font sizes for presentation mode. 对查询编辑器使用“文本编辑器字体”。"Text Editor font" for the Query Editor. 对其他组件使用“环境字体”。"Environment font" for other components. RestoreDefaultFonts - 还原默认设置。RestoreDefaultFonts - Revert back to default settings. 目前没有 PresentOff 命令。There is currently no PresentOff command at this time. 请使用 RestoreDefaultFonts 关闭演示模式*Use RestoreDefaultFonts to turn off Presentation Mode*

Bug 修复Bug fixes

  • 修复了通过 Surface Book 触摸板滚动显示计划时 SSMS 崩溃的问题Fixed an issue where SSMS crashed when showplan scrolled via surface book touchpad
  • 修复了获取正在还原或脱机的数据库的属性时 SSMS 长时间挂起的问题Fixed an issue where SSMS hangs for a long time while getting the properties of a database which is being restored or offline
  • 修复了无法在 RC 内部版本中打开“帮助查看器”的问题Fixed an issue where "Help viewer" could not be opened in RC builds
  • 修复了 SSMS 中可能缺少“维护计划任务工具箱”项的问题。Fixed an issue where "Maintenance Plans Tasks Toolbox" items may be missing in SSMS.
  • 修复了 SSMS 中的一个问题:数据库名称包含大括号时,用户无法收缩数据库。Fixed an issue in SSMS where the user was unable to shrink a database when the database name contained curly braces. 连接项Connect Item
  • 修复了 SSMS 尝试编写删除 Azure 数据库的脚本时导致实际删除数据库本身的问题。Fixed an issue where SSMS was trying to script the deletion of an Azure database was actually causing the deletion of the database itself. 连接项Connect Item
  • 修复了没有为用户定义的表类型编写默认值的问题。Fixed an issue where default values were not scripted for user-defined table types. 连接项Connect Item
  • 对索引中的上下文菜单进行了另一轮性能改进。Another round of perf improvements around context menu on indexes. 连接项Connect Item
  • 解决了将鼠标悬停在执行计划缺少的索引之上时,闪烁次数过多的问题。Fixed issue which was causing excessive flickering when hovering mouse over missing index in execution plan. 连接项Connect Item
  • 解决了编写脚本时 SSMS 导致 DB 脱机的问题 连接项Fixed an issue where SSMS was taking the DB offline when scripting Connect Item
  • 对本地化(非英语)版本的 SSMS 进行了其他 UI 修复。Miscellaneous UI fixes on localized (non-English) versions of SSMS.
  • 解决了定位 SQL 2016 SP1 标准版时没有“Always Encrypted 密钥”节点的问题。Fixed issue where "Always Encrypted Keys" node was missing when targeting SQL 2016 SP1 Standard Edition.
  • Always Encrypted 定位 SQL 2016 RTM 标准版或任意 SQL 2014(及更低版本)服务器时,“Always Encrypted”菜单未正确启用。修复了使用 CREATE OR ALTER 语法时 IntelliSense 报告错误的问题。修复了当 CMK/CEK 包含应转义的字符(即用括号括住)时无法加密的问题。当 SSMS 中发生内存不足异常时,用户会看到一个错误消息,建议其改用本机(64 位)PowerShell。Always Encrypted "Always Encrypted" menu was incorrectly enabled when targeting SQL 2016 RTM Standard Edition or any SQL 2014 (and below) servers Fixed an issue where IntelliSense is reporting an error when the CREATE OR ALTER syntax is used Fixed issue where encryption fails in case CMK/CEK contain characters that should be escaped, i.e. enclosed in brackets When an Out of Memory exception occurs in SSMS, the user is presented an error that suggests using the native (64bit) PowerShell instead. 解决了在用户使用资源组管理器订阅(而不是经典 Azure 订阅)时,AE 向导无法运行的问题 解决了在用户对任何订阅都没有权限,或对任何订阅都没有 Azure Key Vault 时,AE 向导显示不正确错误消息的问题。Fixed issue where the AE wizard was failing in case the user was using Resource Group Manager subscriptions instead of Classic Azure subscriptions Fixed issue where AE wizard was showing an incorrect error when the user had no permissions in any subscriptions or had no Azure Key Vaults in any of them. 解决了在有多个 AAD 的情况下,AE 向导中的 Azure Key Vault 登录页不显示 Azure 订阅的问题 解决了 AE 向导中的 Azure Key Vault 登录页不显示用户有读者权限的 Azure 订阅的问题Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions in case of multiple AAD Fixed issue in AE wizard where the Azure Key Vault sign-in page was not showing Azure subscriptions for which the user has reader permission
    • 修复了资源文件可能未正确加载而导致错误消息不准确的问题Fixed an issue where resource files may not be loaded correctly, thus resulting in inaccurate error messages
  • 改进了 SSMS 安装页上的超链接对比度Improved contrast of hyperlinks on SSMS Setup page
  • 解决了连接 SQL Server Express (2016 SP1) 时不显示 PolyBase 节点的问题Fixed an issue where PolyBase nodes were not displayed when connected to SQL Server Express (2016 SP1)
  • 修复了 SSMS 无法将 Azure DB 的兼容级别更改为 v140 的问题Fixed an issue where SSMS is unable to change the Compatibility Level of an Azure DB to v140
  • 改进了展开 Azure 数据库列表时的对象资源管理器性能 连接项Improved performance of Object Explorer when expanding the list of Azure databases Connect Item
  • 解决了对非关系服务器类型 (AS\RS\IS) 错误显示“查看 SQL Server 日志”上下文菜单项的问题Fixed an issue where "View SQL Server Log" context menu item appeared incorrectly for non-relational server types (AS\RS\IS)
  • 解决了使用 SQL 身份验证查看 Analysis Services 分区查询的语法时看到登录失败消息的问题Fixed an issue where checking syntax of an Analysis Services partition query using SQL auth could result in login failed message
  • 解决了在 SSMS 中无法重命名预览 1400 兼容性级别 AS 表格模型的问题Fixed an issue where renaming a preview 1400 compat-level AS tabular model would fail in SSMS
  • 解决了在模型保存失败后还原本地更改的极少数情况下,尝试在 AS 服务器上执行无效操作后可能看到“无法对模型执行操作”错误消息的问题Fixed an "operation failed on model" issue that could occur after attempting an invalid operation on the AS server in rare circumstances, revert local changes after unsuccessful save on the model
  • 更正了 Analysis Services 同步数据库弹出式对话框中的错别字Fixed a typo in Analysis Services Synchronize Database popup dialog
  • 在多个监视器设置中,备份/还原容器对话框出现在屏幕外。Backup/restore container dialogs come up offscreen on multiple monitor setups.
  • 如果目标对象的名称中包含 ],则无法创建 SecurityPolicy。SecurityPolicy create fails if target object has ] in its name.
  • SSMS 2016 的“打开最近的文件”菜单不显示最近保存的文件。SSMS 2016 "Open recent" menu doesn't show recently saved files. 连接项Connect Item
  • 删除了 VS Shell 更新后用户设置的重置。Removed reset of user settings when VS Shell is updated.
  • 修复了用户无法在 SQL Server 2017 中更改数据库兼容级别的问题。Fixed an issue that was preventing the user from being able to change Compatibility Level of a database on SQL Server 2017.
  • 使用 AAD 通用身份验证的查询窗口在一小时后无法刷新查询。Query windows using AAD Universal authentication cannot refresh the query after an hour.
  • 从 SSMS 删除了实用工具控制点 UI。Utility Control Point UI removed from SSMS.
  • 初始令牌过期后,AD 通用身份验证连接无法查询数据。AD Universal auth connections fail to query data after the initial token expiration.
  • 无法从 Azure SQL DB 将规则脚本编写到 Azure SQL DB。Unable to script Rules from Azure SQL DB to Azure SQL DB.
  • 解决了 SQL PowerShell 无法连接旧 SQL 实例(2014 或更早版本)的问题。Fixed issue where SQL PowerShell was not able to connect legacy SQL instances (2014 and older). 连接项Connect Item
  • 解决了无法导入已注册的服务器时导致 SSMS 崩溃的问题。Fixed an issue that was causing SSMS to crash when failing to import registered servers.
  • 修复了在用户具有数据库特定权限的情况下导致 SSMS 崩溃的问题。Fixed an issue that was causing SSMS to crash if a user has certain permissions in a database.
  • SSMS - 查看视图时表从设计图面消失。SSMS - tables disappear from design surface while reviewing views. 连接项Connect Item
  • 表滚动条不允许用户滚动表内容,仅向上/向下键允许此操作。The table scrollbar does not allow the user to scroll the table content, only the up/down Arrow allow this. 在尝试使用滚动条滚动(而这是一个 Bug)时,有可能滚动表内容。It's also possible to scroll the table content after trying to scroll using the scrollbar which is a bug. 连接项Connect Item
  • 刷新根节点后,已注册的服务器不显示图标。Registered Servers not displaying icons after refreshing the root node.
  • Azure v12 服务器上的“创建数据库”脚本按钮执行脚本,然后显示消息“没有要编写脚本的操作”。Script button for Create Database on Azure v12 servers executes script then displays message "No action to be scripted".
  • “SSMS 连接到服务器”对话框不为每个新连接清除“附加属性”选项卡。SSMS Connect to Server dialog does not clear "Additional Properties" tab for each new connection.
  • 生成任务脚本不会为 Azure SQL DB 生成“创建数据库”脚本。Generate Tasks script doesn't generate Create Database scripts for an Azure SQL DB.
  • 视图设计器中的滚动条显示为已禁用。Scrollbar in View Designer appears disabled.
  • Always Encrypted AVK 密钥路径不包括版本 ID。Always Encrypted AVK key paths do not include version IDs.
  • 减少查询窗口中引擎版本查询的数量。Reduced number of engine edition queries in the query window. 连接项Connect Item
  • 错误处理加密后,刷新模块出现“始终加密”错误。Always Encrypted errors from refreshing modules after encryption are incorrectly handled.
  • 更改 OLTP 和 OLAP 的默认连接超时,将其从 15 秒更改为 30 秒,以修复一类被忽略的连接故障。Changed default connection timeout for OLTP and OLAP from 15 to 30 seconds to fix a class of ignored connection failures.
  • 解决了启动自定义报表时 SSMS 崩溃的问题。Fixed a crash in SSMS when custom report is launched. 连接项Connect Item
  • 修复了 Azure SQL 数据库“生成脚本...”失败的问题。Fixed an issue where "Generate Script..." fails for Azure SQL databases.
  • 解决了“编写脚本为”和“生成脚本向导”问题,避免在对象脚本编写(如存储过程)时添加额外的换行符。Fix "Script As" and "Generate Script Wizard" to not add extra newlines when scripting objects such as stored procedures. 连接项Connect Item
  • SQLAS PowerShell 提供程序:向 Dimension 和 MeasureGroup 文件夹添加 LastProcessed 属性。SQLAS PowerShell Provider: Add LastProcessed property to Dimension and MeasureGroup folders. 连接项Connect Item
  • 实时查询统计信息:解决了在批处理中仅显示第一个查询的问题。Live Query Statistics: fixed issue where it was only showing the first query in a batch. 连接项Connect Item
  • Showplan:在属性窗口中显示线程的最大值而非总和。Showplan: show max instead of sum across the threads in properties window.
  • 查询存储:使用高执行变体在查询中添加新报表。Query Store: add new report on queries with high execution variation.
  • 对象资源管理器性能问题:连接项 表的上下文菜单暂时挂起。右键单击表的索引(通过远程 (Internet) 连接)时,SSMS 运行缓慢。Object explorer performance issues: Connect Item Context menu for tables momentarily hangs SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection). 避免发出在服务器上排序的表查询Avoid issuing table queries that sort on the server
  • 从 SSMS 删除 Azure 部署向导(向 Azure VM 部署数据库)Removed Azure Deployment Wizard (Deploy Database to Azure VM) from SSMS
  • 解决了 SSMS 的执行计划中不显示丢失的索引的问题连接项Fixed issue where missing indexes were not shown in execution plans in SSMS Connect Item
  • 解决了 SSMS 中常见的崩溃关闭问题Fixed common crash-on-shutdown issue in SSMS
  • 解决了对象资源管理器中,在 PolyBase|横向扩展组节点上调用上下文菜单时出错的问题连接项Fixed issue in Object Explorer where an error occurred when bringing up the context menu on the PolyBase|Scale-Out Group nodes Connect Item
  • 解决了尝试显示数据库上的权限时 SSMS 可能崩溃的问题Fixed an issue where SSMS may crash when trying to display the permissions on a database
  • 查询存储:查询存储报表的结果网格的上下文菜单项中的常规功能增强Query Store: general enhancements in context menu items for result grids of query store report
  • 为现有表配置“始终加密”功能失败,在不相关的对象上出错。Configuring Always Encrypted for an existing table fails with errors on unrelated objects. 连接项Connect Item
  • 为现有数据库配置“始终加密”功能时,多个架构无法正常运行。Configuring Always Encrypted for an existing database with multiple schemas doesn't work. 连接项Connect Item
  • 由于数据库包含引用系统视图的视图,“始终加密、已加密列”向导失败。The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. 连接项Connect Item
  • 使用“始终加密”功能进行加密时,错误处理加密后刷新模块出现错误。When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.
  • 解决了“新建服务器注册”对话框中的 UI 截断问题Fixed UI truncation issue on "New Server Registration" dialog
  • 解决了 DMF 条件 UI 无法正确更新带有其中包含引号的字符串常量值的表达式的问题Fix DMF Condition UI incorrectly updating expressions that contain string constant values with quotes in them
  • 解决了在运行自定义报表时有可能导致 SSMS 崩溃的问题Fixed an issue that may cause SSMS to crash when running custom reports
  • 将“在横向扩展里执行...”菜单项添加到文件夹节点Add "Execution in Scale Out..." menu item to the folder node
  • 修复了 Azure SQL DB 防火墙白名单 IP 地址功能的问题Fixed an issue with Azure SQL DB firewall whitelist IP address feature
  • 修复了 SSMS 中的一个问题:编辑 AS 多维分区的源时,此问题会导致对象引用不会设置为异常Fixed an issue in SSMS which caused an Object reference not set exception when editing the source of AS multi-dimensional partition
  • 修复了 SSMS 中的一个问题:删除多维 AS 服务器中的客户程序集时,此问题会导致对象引用不会设置为异常Fixed an issue in SSMS which caused an Object reference not set exception when deleting a customer assembly from multi-dimensional AS server
  • 修复了重命名 AS 表格 1400 db 失败的问题Fixed an issue where renaming an AS tabular 1400 db failed
  • 修复了为连接属性对话框中的 1400 兼容级别 AS 表格数据源编写脚本时出现的 问题Fixed an issue with scripting a 1400 compat-level AS tabular datasource from connection properties dialog
  • 消除了 AS 1400 兼容级别模型中的表至少有一个分区的假设Remove assumption that tables in AS 1400 compat-level model have at least one partition
  • 现在按 Ctrl-R 可在 SSMS DAX 查询编辑器中切换结果窗格Ctrl-R now toggles results pane in SSMS DAX query editor

下载 SSMS 16.5.3download SSMS 16.5.3

正式发布版 | 生成号:13.0.16106.4Generally available | Build number: 13.0.16106.4

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

此版本已解决以下问题:The following issues were fixed this release:

  • 解决了 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.

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

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

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

  • 使用“始终加密”功能进行加密时,错误处理加密后刷新模块出现错误。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"

卸载并重装 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.

其他下载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).