SQL Server Management Studio (SSMS) 版本資訊Release notes for SQL Server Management Studio (SSMS)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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,請參閱舊版 SSMSIf 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 2019 支援Support 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 2019 支援Support for SQL Server 2019 支援 SQL Server 2019 中的 "BATCH_STARTED_GROUP" 和 "BATCH_COMPLETED_GROUP",以及 SQL 受控執行個體。Support for "BATCH_STARTED_GROUP" and "BATCH_COMPLETED_GROUP" in SQL Server 2019 and SQL Managed Instance.
SQL Server 2019 支援Support for SQL Server 2019 SMO:新增 UDF 內嵌支援。SMO: Added support for UDF Inlining.
SQL Server 2019 支援Support for SQL Server 2019 GraphDB:在 Graph TC 序列的執行程序表中新增旗標。GraphDB: Add flag in showplan for Graph TC Sequence.
SQL Server 2019 支援Support for SQL Server 2019 Always Encrypted:新增 AEv2/記憶體保護區支援。Always Encrypted: added support for AEv2 / Enclave.
SQL Server 2019 支援Support for SQL Server 2019 Always Encrypted:當使用者按一下 [選項] 按鈕來啟用/設定記憶體保護區支援時,連線對話方塊會有新的索引標籤 [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 Isolated Shell 為基礎SSMS 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 允許以不同於作業系統語言的語言進行安裝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. 如果作業系統語言與 SSMS 語言不相符,使用者必須在 [工具] > [選項] > [國際設定] 下變更語言,否則 SSMS 會顯示英文的 UI。If the OS language does not match the SSMS language, the user needs to change the language under Tools > Options > International Settings, otherwise SSMS 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.
高 DPI 支援Support for High DPI 現在預設會啟用高 DPI。High DPI is now enabled by default.
SSMS 隨附 Microsoft OLE DB 驅動程式SSMS ships with the Microsoft OLE DB driver 如需詳細資料,請參閱下載 Microsoft OLE DB Driver for SQL ServerFor 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.
開發 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. 如需詳細資料,請參閱 Priority boost details - and why it’s not recommended (優先權提升詳細資料 - 及不建議使用的原因)。For details, see Priority boost details – and why it’s not recommended.
一般 SSMSGeneral SSMS 用來建立檔案的新功能表和按鍵繫結關係:CTRL+ALT+NNew 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 錯誤記錄檔] 下公開 [maximum size for error log files] (錯誤記錄檔大小上限)。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] – 我們已整合 Database Migration Assistant 與 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 Database。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 新增對最近所新增虛擬核心 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 新增「AAD 登入」作為 SMO 及 SSMS 中連線到 Azure SQL 受控執行個體時的新登入類型。Added new "AAD logins" as a new login type in SMO and SSMS when connected to an Azure SQL Managed Instance.
Always OnAlways 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 EncryptedAlways Encrypted [連線至伺服器] 對話方塊之新 [Always Encrypted] 索引標籤中的 [啟用 Always Encrypted] 核取方塊現在提供簡單的方法來啟用/停用資料庫連線的 Always Encrypted。The Enable Always Encrypted checkbox in the new Always Encrypted tab in the Connect to Server dialog now provides an easy way to enable/disable Always Encrypted for a database connection.
具有安全記憶體保護區的 Always EncryptedAlways Encrypted with secure enclaves 在 SQL Server 2019 Preview 中,已完成數個增強功能來支援具有安全記憶體保護區的 Always Encrypted:Several enhancements have been made to support Always Encrypted with secure enclaves in SQL Server 2019 preview:
[連線至伺服器] 對話方塊中用於指定記憶體保護區證明 URL 的文字欄位 (新的 [Always Encrypted] 索引標籤)。A text field for specifying enclave attestation URL in the Connect to Server dialog (the new Always Encrypted tab).
[新增資料行主要金鑰] 對話方塊中用來控制新資料行主要金鑰是否允許記憶體保護區計算的新核取方塊。The new checkbox in the New Column Master Key dialog to control whether a new column master key allows enclave computations.
其他 Always Encrypted 金鑰管理對話方塊現在會公開哪些資料行主要金鑰允許記憶體保護區計算的資訊。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. 這會啟動新的 Query Tuning Assistant (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 Government 雲端中 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 Agent 時,您可以在 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 Data Factory 中嘗試 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 Data Factory SSIS Integration Runtime。Deployment Wizard now supports creating and deploying to Azure Data Factory SSIS Integration Runtime.
物件指令碼Object Scripting 為物件編寫指令碼時,新增功能表項目 [CREATE 或 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 新增邏輯以顯示「具體化程式運算子 (外部 Select)」。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 在伺服器物件上公開新的 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 在資料庫物件上公開新的 LastGoodCheckDbTime 屬性,該屬性對應至 "lastgoodcheckdbtime" 資料庫屬性。Exposed new LastGoodCheckDbTime property on Database object, which maps to "lastgoodcheckdbtime" database property. 如果沒有這類屬性可用,則會傳回預設值 1/1/1900 12:00:00 AM。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 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 修正選取 [編寫指令碼為 Create/Update/Drop] (已移除 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 application error and crash when using Central Management Server (使用中央管理伺服器時發生 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 > 2048G),擲回算數溢位錯誤的問題。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 Database 中的使用者資料庫 (而非 master) 時,Azure SQL DB 查詢視窗之資料庫清單不正確地填入資料的問題。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 Database 的問題。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 UI 控制項中防止使用者顯示 Azure 訂用帳戶 (若未超過 50 個) 的問題。Fixed issues in common Azure UI control that was preventing the user from displaying Azure subscriptions (if there were more than 50). 此外,排序已變更為依名稱,而不是依訂用帳戶識別碼。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." 錯誤。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 修正使用 SQL Agent 排程器的迴歸問題,在其中即使選擇了其他某個排程類型,還是會選擇 ONIDLE 排程。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 在 RESTORE 作業之前撰寫結尾記錄備份指令碼的問題 (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 修正為資料庫編寫指令碼時 ([編寫指令碼為 Create...]),無法為額外檔案群組和檔案編寫指令碼的問題。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。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. 如需詳細資料,請參閱 Allow deletion of users from SSMS login window (允許從 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 在 [AG 儀表板] 中顯示截斷警告的問題。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 修正嘗試在 OE 中展開 [管理] 節點時,SSMS 可能會擲回「物件無法從 DBNull 轉換為其他類型」例外狀況 (設定錯誤的 DataCollector) 的問題。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 修正 OE 在叫用「編輯前 N 個...」之前未逸出引號而造成設計工具混淆的問題。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 修正「Database Mail 設定」中沒有保存 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 修正 SSMS 在嘗試使用 is_auto_update_stats_async_on 還原資料庫時,現有連線關閉選項呈現灰色的問題。Fixed an issue where SSMS grayed out option to close existing connections when trying to restore database with is_auto_update_stats_async_on.
物件總管Object Explorer 修正以滑鼠右鍵按一下 OE 節點 (例如「資料表」),並想要執行動作 (例如移至 [篩選] > [篩選設定] 來篩選資料表),篩選設定表單可能會出現在 SSMS 目前使用中畫面以外其他畫面上的問題。Fixed an issue where right-clicking on nodes in OE the (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 鍵在 OE 中無法運作的長時間待處理問題。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 整體效能改善 - 相較於 SSMS 17.7,產生 WideWorldImporters 指令碼只要一半的時間。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 修正搭配 MFA 使用 AAD 連線到 Azure SQL DB 時,為資料庫物件編寫指令碼失敗的問題。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 DB 上使用 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 Database 的資料庫指令碼一律瞄準內部部署 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.
ProfilerProfiler 將「彙總資料表重寫查詢」事件新增至分析工具事件。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 修正嘗試在內建查詢存放區報表中設定自訂時間間隔時,使用者無法在開始/結束間隔上選取上午或下午的問題。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 修正瞄準 Azure 時 ServerConnection 執行緒安全性中造成 SMO 流失 SqlConnection 執行個體的問題。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. 如需詳細資料,請參閱 Restoring wrong default color for SQL System Table (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 修正 IntelliSense 在使用 AAD 驗證連線到 Azure SQLDW 時無法運作的問題。Fixed issue where intellisense was not working when connected to Azure SQLDW using AAD authentication.
SSMS 編輯器SSMS Editor 修正 IntelliSense 在使用者缺少 master 資料庫存取權時於 Azure 中的體驗。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 IntelliSense 現在可識別新的 TRANSLATE 函式。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 修正 IntelliSense 在使用 "ALTER TABLE...ADD CONSTRAINT...WITH(ONLINE=ON)" 時發出警告的問題。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 Database 時,允許新增至資料表的問題。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" 這兩個資料行,它們會將動作識別碼及類別類型欄位顯示為可讀取字串。Added two columns "action_name" and "class_type_desc" that show action id and class type fields as readable strings.
XEventXEvent 移除事件 XEvent 檢視器 1,000,000 個事件的上限。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 組態管理員和 Reporting 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 命令列選項 -PSSMS 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. 新式的 Database Mail 和「維護計劃」節點會繼續如往常般運作。The modern "Database Mail" and "Maintenance Plans" nodes will continue to work as usual.

舊版 SSMSPrevious 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 的小型更新,其中包括下列錯誤修正:17.9.1 is a small update to 17.9 with the following bug fixes:

  • 修正在搭配使用 SQL 查詢編輯器和「支援 MFA 的 Active Directory - Universal」驗證時,使用者可能會遇到每一次查詢叫用時連線都會關閉並重新開啟的問題。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 Database 時導致錯誤。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:

  • 圖形化執行程序表現在會顯示新資料列模式記憶體授與回應屬性 (當此功能已針對特定方案啟用時):IsMemoryGrantFeedbackAdjusted 與 LastRequestedMemory 會新增至 MemoryGrantInfo 查詢計畫 XML 元素。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 fixes

一般 SSMSGeneral SSMS

複寫監視器:Replication Monitor:

匯入一般檔案精靈:Import Flat File Wizard:

  • 修正 [一般檔案精靈] 對話方塊說明頁面的連結Fixed the link to the help page for "Flat File Wizard" dialog
  • 修正當資料表已存在時,精靈不允許變更目的地資料表的問題:這可讓使用者重試,而不需要結束精靈、刪除失敗的資料表,然後重新輸入資訊到精靈 (User Voice 項目: https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186)。Fixed issue where the wizard did not allow changing the destination table when the table already existed: this allows users to retry without having to exit the wizard, delete the failed table, and then reenter the information into the wizard (User Voice item: https://feedback.azure.com/forums/908035-sql-server/suggestions/32896186).

匯入/匯出資料層應用程式:Import/Export Data-Tier Application:

  • 修正 DacFx 中導致當處理具有已定義且在資料表上無索引的資料表時匯入 .bacpac 失敗並顯示「錯誤 SQL72014: .Net SqlClient 資料提供者:訊息 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:

  • 修正搭配 MFA 使用 AAD 時,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.
  • 修正搭配 MFA 使用 ADD 連線到 Azure SQL Database 時,嘗試產生指令碼 (「資料」或「結構描述與資料」) 失敗的問題。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 Database 的情況下從 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.
  • 修正 SSMS 查詢編輯器在 MFA 權杖更新期間自動關閉並重新開啟連線的問題。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 未搭配 MFA 登入使用 AAD 針對 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).
  • 修正 SSMS 在嘗試登入沒有任何儲存體帳戶的 Microsoft Azure 帳戶時擲回例外狀況 (「索引超出範圍」) 的問題 (在 [從 URL 還原備份] 對話方塊中)。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:

  • 編寫「Drop 及 Create」指令碼時,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 查詢編輯器和 支援 MFA 的 Active Directory - Universal 驗證時,使用者可能會遇到每一次查詢叫用時連線都會關閉並重新開啟的問題。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 資料庫有關的 BUG,因此以 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. 這個新的設定選項已新增至 [資料庫屬性] > [檔案群組] 視窗之下,採用的形式是為每個可用檔案群組 (除了 Filestream 和記憶體最佳化檔案群組之外) 提供新的核取方塊資料行 ([所有檔案自動成長])。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. 同樣地,針對資料庫 (SQL2016 和更新版本) 的 CREATE (建立)/產生指令碼,編寫資料庫指令碼時也已正確地編寫 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:

  • 已改善當使用者沒有 master 存取權時,在 Azure SQL Database 中的 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 Government 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 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)

  • 已修正在 Tabular 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 Tabular 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 Database 版本時,某些對話方塊顯示版本無效錯誤。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 Database 的 SSIS 套件,新增排程功能。Added a scheduling feature for SSIS packages deployed to Azure SQL Database. 不同於具有 SQL Server Agent 作為首要工作排程器的內部部署 SQL Server 和 SQL Database 受控執行個體,SQL Database 並沒有內建排程器。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 Agent 的熟悉使用者介面,來排程部署到 SQL Database 的套件。This new SSMS feature provides a familiar user interface that's similar to SQL Server Agent for scheduling packages deployed to SQL Database. 如果您使用 SQL Database 來裝載 SSIS 目錄資料庫 SSISDB,您可以使用此 SSMS 功能,產生排程 SSIS 套件所需的 Data Factory 管線、活動和觸發程序。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. 然後,您可以編輯並擴充 Data Factory 中的這些物件。You can then edit and extend these objects in Data Factory. 如需詳細資訊,請參閱使用 SSMS 排程 Azure SQL Database 上的 SSIS 套件執行For more info, For details, see Schedule SSIS package execution on Azure SQL Database with SSMS. 若要深入了解 Azure Data Factory 管線、活動和觸發程序,請參閱 Azure Data Factory 中的管道及活動Azure Data Factory 中的管道執行和觸發程序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 Agent 中排程 SSIS 套件。Support for SSIS package scheduling in SQL Agent on SQL Managed instance. 您現在可以建立 SQL Agent 工作,在受控執行個體上執行 SSIS 套件。It is now possible to create SQL Agent jobs to execute SSIS packages on the managed instance.

錯誤修正Bug fixes

一般 SSMSGeneral SSMS

維護計畫:Maintenance Plan:

一律開啟: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 Database 編寫資料庫指令碼無法編寫 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 Database: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:

  • 在 SMO 中公開錯誤記錄檔大小設定。Exposed Error Log Size setting in SMO. 如需詳細資料,請參閱 Set the Maximum Size of the SQL Server Error Logs (設定 SQL Server 錯誤記錄檔大小上限)。For details, see Set the Maximum Size of the SQL Server Error Logs.
  • 修正 Linux 上 SMO 的換行字元指令碼處理。Fix linefeed scripting in SMO on Linux.
  • 擷取不常使用之屬性時的其他效能提升。Miscellaneous perf improvement when retrieving rarely used properties.

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 Database 受控執行個體的支援。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 Database 版本時,某些對話方塊顯示版本無效錯誤。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 Database 受控執行個體:SQL Database Managed Instance:

  • 針對 Azure SQL Database 受控執行個體新增支援。Added a support for Azure SQL Database Managed Instance. Azure SQL Database 受控執行個體幾乎達到 100% 的 SQL Server 內部部署相容性,這是解決常見安全性問題的原生虛擬網路 (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 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:

  • 已修正 AG Show Dashboard 中的一個問題;當伺服器設定為區分大小寫的定序時,按一下「收集延遲資料」 可能會導致錯誤。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.
    • 只有當複本在不同於主要複本的作業系統上時,才執行檔案重新配置。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:

  • 已修正當嘗試在物件總管中展開 [Management] 節點時,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:Database Mail:

  • 已修正當嘗試顯示與管理超過 16 個設定檔時,[Database Mail 設定精靈] 會擲回的問題。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)

  • 已修正當 SSMS 連線到 SQL Database 受控執行個體時,未顯示 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. 若您已經安裝 17.6 且有這項問題的影響,請降級至 SSMS 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:

  • 已將 SkipRows 選項的支援新增至 Azure SQL DW 的分隔文字外部檔案格式。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:

錯誤修正Bug fixes

一般 SSMSGeneral SSMS

執行程序表: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:

  • 修正 SSMS 可擲回下列這類錯誤的 SPID 相關問題:「輸入字串格式不正確。Fixed on issue related to SPIDs where SSMS could throw an error like "Input string was not in a correct format. (mscorlib)」(執行前面加上 "SET SHOWPLAN_ALL ON" 的簡單查詢時)。(mscorlib)" when executing a simple query preceded by a "SET SHOWPLAN_ALL ON".

SMO:SMO:

  • 修正 SMO 在伺服器定序區分大小寫時無法提取 AvailabilityReplica 屬性的問題 (因此,SSMS 可以顯示「無法繫結多部分識別碼 "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 Agent 屬性的問題 (因此,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",且最後不會在物件總管中顯示 SQL Agent 節點)。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.

下載 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.

Always On 儀表板:Always On Dashboard:

  • 改進了可用性群組中延遲分析。Improvements for latency analysis in Availability Groups.
  • 新增兩個報表:AlwaysOn_Latency_PrimaryAlwaysOn_Latency_SecondaryAdded two new reports: AlwaysOn_Latency_Primary and AlwaysOn_Latency_Secondary.

執行程序表: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).
  • 已加入 database_name 與 client_hostname 動作至 XEvent 分析工具工作階段中適當的事件。Added database_name and client_hostname actions to appropriate events in XEvent Profiler sessions. 若要讓變更生效,您可能需要刪除伺服器上現有的 QuickSessionStandard 或 QuickSessionTSQL 工作階段執行個體 - Connect 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)

  • 已加入「部署精靈」中的套件驗證功能,以協助使用者了解 Azure-SSIS IR 中不支援的 SSIS 套件內元件。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 fixes

一般 SSMSGeneral SSMS

  • 物件總管:已修正資料庫快照集未顯示「資料表值函式」節點的問題 - Connect 3140161Object Explorer: Fixed an issue where Table-Valued Function node was not showing up for database snapshots - Connect 3140161. 已改進當伺服器有 autoclose 資料庫時展開 Databases 節點的效能。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 當機的問題 - Connect 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 分析工具:已修正當使用者沒有 VIEW SERVER STATE 權限時,造成 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.
  • 已註冊的伺服器:修正 [移至...] 命令停止運作的問題 - Connect 3142862Connect 3144359Registered Servers: Fixed an issue where the "Move To..." command stopped working - Connect 3142862 and Connect 3144359.
  • SMO:已修正 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. 已修正編寫延伸資料庫指令碼時,不正確地發出 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. 參數名稱:index (System.Windows.Forms)」錯誤的問題 - Connect 3138691Parameter name: index (System.Windows.Forms)" error when trying to filter by Category - Connect 3138691.
  • 連線對話方塊:修正網域使用者沒有讀取/寫入網域控制站存取權時,無法使用 SQL 驗證登入 SQL Server 的問題 - Connect 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 Government 使用者將可透過通用驗證和 Azure Active Directory 登入,使用 SSMS 持續存取其 Azure SQL Database 和 Azure Resource Manager 資源。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 使用者選項] 對話方塊的問題,以便在進行搜尋時會顯示應用程式識別碼 GUID,而非物件識別碼。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 Profiler] 節點新增至物件總管。Added "XEvent Profiler" node to Object Explorer. 如需詳細資料,請參閱使用 SSMS XEvent ProfilerFor details, see Use the SSMS XEvent Profiler.
  • 已更新效能儀表板等候歷程記錄報表中的等候篩選和分類。Updated waits filtering and categorization in Performance Dashboard historical waits report.
  • 已新增 "Predict" 函式的語法檢查。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.
  • 已將傳送追蹤詳細資料的選項新增至 [具 MFA 支援的 Active Directory - 通用] 登入的 [輸出] 視窗 (預設為關閉;需要在 [工具] > [選項] > [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 物件總管 > [指令碼] > [包括指令碼參數標頭] 下的 [使用者設定] 中啟用)- Connect 項目 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 Fixes

一般 SSMSGeneral SSMS

  • XEvent:XEvent:
    • 已修正 SSMS 只會開啟 .xel 檔案中部分事件的問題。Fixed issue where SSMS opens only part of the events in .xel file.
    • 已改善預設資料庫不是 'master' 時的「監看即時資料」體驗 - Connect 項目 1222582Improved "Watch Live Data" experience when default database is not 'master' - Connect item 1222582.
  • 一律開啟:修正「還原記錄備份」可能因錯誤「在 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".
  • 作業活動監視器:已修正不一致的圖示 - Connect 項目 3133100Job Activity Monitor: fixed inconsistent icons - Connect item 3133100.
  • 查詢存放區:修正使用者無法針對查詢存放區報表選擇「自訂」日期範圍的問題。Query Store: Fixed Issue where user cannot choose "custom" date range for Query Store reports. 已連結至下列 Connect 項目。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. 修正指令碼預存程序的標頭不符合指令碼設定,而導致可能造成誤導的指令碼問題 - Connect 項目 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. 修正 SSMS 不允許在某些物件 (UDF、檢視、SP、觸發程序) 上撰寫「改變」或「執行」指令碼的問題;當連線到 Azure SQL Database 時,就會發生此問題 - Connect 項目 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 Database 時的 IntelliSense。Improved intellisense when targeting Azure SQL databases.
    • 已修正查詢因驗證權杖 (通用驗證) 過期而失敗的問題。Fixed an issue where queries failed due to an expired authentication token (Universal Authentication).
    • 已改善針對 Azure SQL Database 使用時的 IntelliSense (特別是連接到 Azure SQL Database 時,將會使用最新的 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).
    • 已修正開啟連接到伺服器上非 DataWarehouse 資料庫的查詢視窗,會導致該伺服器對 DataWarehouse 資料庫的所有後續查詢視窗擲回未支援類型/選項之各種相關錯誤的問題。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 儀表板和 AG 屬性頁面。Added For details, seeding mode column to Always On dashboard and AG properties page.
    • 已修正主要在 Windows 上時無法建立 Linux AG 的問題 - Connect 項目 3139856Fixed issue where it was not possible to create a Linux AG when primary is on Windows - Connect item 3139856.
  • 已修正執行查詢時 SSMS 中的數種「記憶體不足」問題 - Connect 項目 2845190Connect 項目 3123864Fixed several "Out of Memory" issues in SSMS when running queries - Connect item 2845190, Connect item 3123864.
  • Profiler:Profiler:
    • 修正目標為 SQL 2005 時 Profiler 無法運作的問題。Fixed issue where Profiler was not working when targeting SQL 2005.
    • 已修正 Profiler 不允許 [信任伺服器憑證] 連接選項的問題。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:
    • 已修正無法辨識 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 驗證不支援 Database Engine Tuning Advisor;有一個已知問題,亦即向使用者呈現不太容易了解的錯誤訊息:「無法載入檔案或組件 'Microsoft.IdentityModel.Clients.ActiveDirectory'...」,而非預期的:「Database Engine Tuning Advisor 不支援 Microsoft Azure SQL Database。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)

  • [catalog].[event_messagea] 中的 [execution_path] 不是 Scale Out 中正確的套件執行路徑。[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.

下載 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

  • Multi-Factor Authentication (MFA)Multi-Factor Authentication (MFA)

    • 適用於具 Multi-Factor Authentication 的通用驗證 (具 MFA 的 UA) 的多使用者 Azure AD 驗證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 Managed 程式庫已升級至 3.13.9 版。ADAL managed library used by Azure AD Universal Authentication with MFA was upgraded to 3.13.9 version.

  • 此外,所提供 CLI 介面可支援 SQL Database 和 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 Database 和 SQL 資料倉儲的通用驗證 (MFA 的 SSMS 支援)設定適用於 SQL Server Management Studio 的 Azure SQL Database Multi-Factor AuthenticationFor 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 Database 的已啟用檢視表設計工具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 時間)。QueryStoreUI reports now supports additional metrics (for example, RowCount, DOP, CLR Time) from sys.query_store_runtime_stats.

  • Azure SQL Database 現在支援 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 節點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 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:

  • 在開啟一小時之後嘗試執行查詢時,使用「具 MFA 支援的 Active Directory - 通用」驗證的查詢視窗可能會發生與下列類似的錯誤: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.
    • 不支援 Database Engine Tuning Advisor 進行 Azure AD 驗證。The Database Engine Tuning Advisor is not supported for Azure AD authentication. 有一個已知問題,亦即向使用者呈現不太有用的錯誤訊息:「無法載入檔案或組件 'Microsoft.IdentityModel.Clients.ActiveDirectory'...」 ,而非預期的「Database Engine Tuning Advisor 不支援 Microsoft Azure SQL Database。 (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 fixes

  • 修正在嘗試列印查詢結果 (文字格式) 時的問題。Fixed an issue when trying to print the results of a query (as text). 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)https://connect.microsoft.com/SQLServer/feedback/details/3055225/https://connect.microsoft.com/SQLServer/feedback/details/3055225/
  • 修正 SSMS 在 Azure SQL Database 上編寫這類物件刪除指令碼時,不正確地卸除資料表和其他物件的問題。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
  • 修正將 /passive 引數視為 /quiet 的 SSMS (無訊息) 安裝程式問題。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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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
  • 解決以滑鼠右鍵按一下資料表索引 (透過慢速的網際網路連線) 時的效能問題。Addressed performance issue when right-clicking on an index for a table (over a slow internet connect). 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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". 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)https://connect.microsoft.com/SQLServer/feedback/details/3133365https://connect.microsoft.com/SQLServer/feedback/details/3133365
  • 修正 [選取前 n 個資料列] 未包含 "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:改善 [新增資料行主要金鑰] 對話方塊中 AKV 權限狀態的傳訊。將工具提示新增至 CEK 下拉式清單,以更輕鬆地區別具有完整名稱的 CEK。修正未針對 Always Encrypted 將某些 CNG 金鑰存放區提供者顯示在 [新增資料行主要金鑰] 對話方塊中的問題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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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). 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)https://connect.microsoft.com/SQLServer/feedback/details/3133148https://connect.microsoft.com/SQLServer/feedback/details/3133148
  • 修正使用者無法使用 CTRL+Q 快速鍵進行快速啟動的問題 (在 [查詢編輯器] 中切換 [IntelliSense 已啟用] 選項的新按鍵繫結關係現在是 CTRL+BCTRL+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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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. 如何:使用資料來源檢視精靈來定義資料來源檢視 (Analysis Services)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 的名稱和識別碼不同時,[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
  • 與 SQL Server 2017 AS 伺服器或 AS Azure 搭配使用時,具有 [略過成員資格] 選項的 [正在產生 AS 還原資料庫的指令碼] 命令會包含新的對應 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

  • Profiler:[說明] > [關於] 現在會顯示發行版本號碼 (例如 17.1)Profiler: Help > About now displays release version number (e.g 17.1)
  • 分析服務使用者可以從資料來源的內容功能表,針對 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
    • 檢視向外延展 master 的基本資訊。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 fixes

  • 一律開啟: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
  • 永遠加密:已修正下列問題:產生的記錄檔遺漏了 DacFx 所產生的資訊。Always Encrypted: fixed an issue where log file generated was missing the information generated by DacFx.
  • 執行程序表:修正下列問題:UI 一律顯示非自適性聯結運算子的實際聯結類型屬性。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 [連接項目 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 和 Profiler 程式圖示,以區分 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
    • SQL Server PowerShell 模組已從 SSMS 中移除,現在是透過 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
    • 新增 -ClusterType 和 -RequiredCopiesToCommit 參數至 AG Cmdlet (New-SqlAvailabilityGroup、Join-SqlAvailabilityGroup 及 Set-SqlAvailabilityGroup Cmdlet)Added -ClusterType and -RequiredCopiesToCommit parameter to AG cmdlets (New-SqlAvailabilityGroup, Join-SqlAvailabilityGroup, and Set-SqlAvailabilityGroup cmdlets)
    • 新增參數 -ActiveDirectoryAuthority 和 -AzureKeyVaultResourceId 至 Add-SqlAzureAuthenticationContext CmdletAdded parameters -ActiveDirectoryAuthority and -AzureKeyVaultResourceId to Add-SqlAzureAuthenticationContext cmdlet
    • 新增 Revoke-SqlAvailabilityGroupCreateAnyDatabase、Grant-SqlAvailabilityGroupCreateAnyDatabase 和 Set-SqlAvailabilityReplicaRoleToSecondary CmdletAdded Revoke-SqlAvailabilityGroupCreateAnyDatabase, Grant-SqlAvailabilityGroupCreateAnyDatabase and Set-SqlAvailabilityReplicaRoleToSecondary cmdlets
    • 將 -seedingMode 參數新增至 Set-SqlAvailabilityReplica 和 New-SqlAvailabilityReplica CmdletAdded -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
    • XMLA 查詢視窗: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
  • 為 Always Encrypted 新增參數化,如需詳細資料,請參閱此頁面Added Parameterization for Always Encrypted, please refer to this page for more details
  • 目標為 Azure SQL DB 的 AAD 通用驗證連線支援自訂租用戶識別碼AAD Universal auth connection to Azure SQL DB supports custom tenant ID
  • 為 Azure SQL Database 產生指令碼,現在可編寫全文、規則及資料庫指令碼Generate scripts for Azure SQL Database, now scripts full text, rules, and database
  • 修正 SSMS 和 Profiler 啟動顯示畫面的商標Branding fixes in splash screens for SSMS and Profiler
  • 從 SSMS 移除公用程式控制點 UIRemoved Utility Control Point UI from SSMS
  • SSMS 現在可以建立 "PremiumRS" 版本的 Azure SQL DatabaseSSMS can now create "PremiumRS" edition Azure SQL databases
  • AlwaysOn 可用性群組Always On Availability Groups
    • 新增新叢集類型的支援:EXTERNAL 和 NONE。新增 Linux 上的 SQL Server 支援。新增自動植入作為初始資料同步的選項。修正一些缺陷,例如端點 URL 處理、資料庫重新整理和 UI 配置。移除 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
    • 改進 IntelliSense 的數個可用性群組關鍵字Improved 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 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 項目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 項目Connect Item
  • 修正預設值沒有針對使用者定義資料表類型撰寫指令碼的問題。Fixed an issue where default values were not scripted for user-defined table types. Connect 項目Connect Item
  • 針對索引上操作功能表的另一輪效能改進。Another round of perf improvements around context menu on indexes. Connect 項目Connect Item
  • 修正當滑鼠游標暫留在執行計畫中的遺失索引上時,會造成過度閃爍的問題。Fixed issue which was causing excessive flickering when hovering mouse over missing index in execution plan. Connect 項目Connect Item
  • 修正 SSMS 在編寫指令碼時會使 DB 離線的問題 Connect 項目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 Standard Edition 為目標時,[Always Encrypted 金鑰] 節點會遺失的問題。Fixed issue where "Always Encrypted Keys" node was missing when targeting SQL 2016 SP1 Standard Edition.
  • Always Encrypted:當以 SQL 2016 RTM Standard Edition 或任何 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 金鑰保存庫時,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. 修正在 AE 精靈具有多個 AAD 的情況下,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 資料庫的 [相容性層級] 變更為 [v140] 的問題Fixed an issue where SSMS is unable to change the Compatibility Level of an Azure DB to v140
  • 改進 [物件總管] 在展開 Azure 資料庫清單時的效能 Connect 項目 (英文)Improved performance of Object Explorer when expanding the list of Azure databases Connect Item
  • 修正 [檢視 SQL Server 記錄檔] 操作功能表項目針對非關聯式伺服器類型 (AS\RS\IS) 會不正確顯示的問題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 項目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.
  • 公用程式控制點 UI 已從 SSMS 移除。Utility Control Point UI removed from SSMS.
  • AD 通用驗證連線在初始權杖過期後無法查詢資料。AD Universal auth connections fail to query data after the initial token expiration.
  • 無法將 Rules from 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 項目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 項目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 項目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 金鑰路徑未包含版本識別碼。Always Encrypted AVK key paths do not include version IDs.
  • 減少查詢視窗中的引擎版本查詢數。Reduced number of engine edition queries in the query window. Connect 項目Connect Item
  • 未正確處理加密後來自重新整理模組的 Always Encrypted 錯誤。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 項目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 項目Connect Item
  • SQLAS PowerShell 提供者:將 LastProcessed 屬性新增至 Dimension 和 MeasureGroup 資料夾。SQLAS PowerShell Provider: Add LastProcessed property to Dimension and MeasureGroup folders. Connect 項目Connect Item
  • 即時查詢統計資料:修正其只顯示批次中第一個查詢的問題。Live Query Statistics: fixed issue where it was only showing the first query in a batch. Connect 項目Connect Item
  • 執行程序表:在視窗中顯示執行緒的最大值,而非加總。Showplan: show max instead of sum across the threads in properties window.
  • 查詢存放區:對具有高執行變化的查詢新增報表。Query Store: add new report on queries with high execution variation.
  • [物件總管] 效能問題:Connect 項目。資料表的操作功能表會短暫停止回應。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 中的執行計劃顯示的問題 Connect 項目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|向外延展群組節點上帶出操作功能表時發生錯誤的問題 Connect 項目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
  • 為現有資料表設定 Always Encrypted 失敗,不相關的物件發生錯誤。Configuring Always Encrypted for an existing table fails with errors on unrelated objects. Connect 項目Connect Item
  • 無法為具有多個結構描述的現有資料庫設定 Always Encrypted。Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect 項目Connect Item
  • Always Encrypted、加密資料行精靈失敗,原因是資料庫包含參考系統檢視的檢視。The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect 項目Connect Item
  • 使用 Always Encrypted 進行加密時,未正確處理加密後來自重新整理模組的錯誤。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
  • 將 [Scale Out 中的執行...] 功能表項目新增至資料夾節點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 資料庫失敗的問題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 中出現的問題,這造成 'Table' 節點會在資料表有多個疏鬆資料行時展開。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 連線管理員且連線到 Microsoft Dynamics AX/CRM Online 資源的 SSIS 套件部署到 SSIS 目錄。Users can deploy SSIS packages containing OData Connection Manager which connect to a Microsoft Dynamics AX/CRM Online resource to SSIS catalog. 如需詳細資訊,請參閱 OData 連線管理員For more information, For details, see OData Connection Manager.

  • 在現有資料表上設定 Always Encrypted 失敗,不相關的物件發生錯誤。Configuring Always Encrypted on an existing table fails with errors on unrelated objects. Connect 識別碼 3103181Connect ID 3103181

  • 無法為具有多個結構描述的現有資料庫設定 Always Encrypted。Configuring Always Encrypted for an existing database with multiple schemas doesn't work. Connect 識別碼 3109591Connect ID 3109591

  • Always Encrypted、加密資料行精靈失敗,原因是資料庫包含參考系統檢視的檢視。The Always Encrypted, Encrypted Column wizard fails due to the database containing views that reference system views. Connect 識別碼 3111925Connect ID 3111925

  • 使用 Always Encrypted 進行加密時,未正確處理加密後來自重新整理模組的錯誤。When encrypting using Always Encrypted, errors from refreshing modules after encryption are incorrectly handled.

  • 「開啟最近使用的項目」 功能表未顯示最近儲存的檔案。Open recent menu doesn't show recently saved files. Connect 識別碼 3113288Connect ID 3113288

  • SSMS 在以右鍵按一下資料表索引時 (透過遠端 (網際網路) 連線) 很緩慢。SSMS is slow when right-clicking an index for a table (over a remote (Internet) connection). Connect 識別碼 3114074Connect ID 3114074

  • 修正 SQL Designer 捲軸的問題。Fixed an issue with the SQL Designer scrollbar. Connect 識別碼 3114856Connect ID 3114856

  • 資料表的操作功能表會短暫停止回應Context menu for tables momentarily hangs

  • SSMS 有時會擲回活動監視器的例外狀況及損毀。SSMS occasionally throws exceptions in Activity Monitor and crashes. Connect 識別碼 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. 從提升權限的命令提示字元解除安裝 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. 從提升權限的命令提示字元重新安裝 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).