共用方式為


KB4341265 - SQL Server 2017 的累積更新 9

發行日期: 2018 年 7 月 18 日
版本: 14.0.3030.27

摘要

本文說明 Microsoft SQL Server 2017 的累積更新套件 9 (CU9) 。 此更新包含在 2017 年 SQL Server 累積更新 8 發行之後發出的 18 個修正程式,並會更新下列組建中的元件:

  • SQL Server - 產品版本:14.0.3030.27,檔案版本:2017.140.3030.27
  • Analysis Services - 產品版本: 14.0.223.1,檔案版本: 2017.140.223.1

此更新中的已知問題

此累積更新中沒有任何已知問題。

此更新中包含的改善和修正

您可以使用可下載的 Excel 活頁簿,其中包含組建的摘要清單,以及其目前的支援生命週期。 Excel 檔案同時包含 SQL Server 2019 與 SQL Server 2017 的詳細修正清單。 選取立即下載此 Excel 檔案

注意事項

下表中的個別專案可以透過書籤直接參考。 如果您在數據表中選取任何 Bug 參考識別符,則會使用 「#NNNNNNNN」 格式將書籤標記新增至 URL。 然後,您可以與其他人共用此 URL,讓他們可以直接跳到數據表中所需的修正程式。

如需此累積更新中所包含之固定和增強功能之 Bug 的詳細資訊,請參閱下列 Microsoft 知識庫文章。

Bug 參考 描述 修正區域 元件 平台
12041154 修正:使用受限數據行定義的角色在 SSAS 中執行鑽研查詢時發生錯誤 (KB4340134) Analysis Services Analysis Services Windows
12121216 修正:當您嘗試在 SSAS 2017 中重新整理 Excel 中數據透視表的數據透視表時發生例外狀況錯誤 (KB4339664) Analysis Services Analysis Services Windows
12123248 修正:使用 HTTP 存取 SSAS 失敗 SQL Server (KB4340742) Analysis Services Analysis Services Windows
12129434 修正:「無法載入檔案或元件 'Microsoft.AnalysisServices.AdomdClientUI』錯誤,當「行程已滿」作業在 SQL Server (KB4134601) Analysis Services 伺服器 Windows
12168709 修正:當您更新 SSIS 中模糊查閱轉換的參考資料表時,發生 .NET Framework 錯誤 (KB4010460) Integration Services Tasks_Components Windows
12138685 修正:當您嘗試將新成員新增至 SQL Server (KB4339613) 中的實體時,MDS 總管上會發生「字元字串之後未關閉的引號」錯誤 SQL Server (KB4339613) Master Data Services Master Data Services Windows
11983925 修正:當 SQL Server Agent 作業執行 PowerShell 命令來列舉資料庫的許可權時發生錯誤 (KB4133164) SQL Server 用戶端工具 Smo Windows
12162425 修正:2016 和 2017 SQL Server 2017 年基本可用性 群組 次要復本中的 VSS 備份失敗 (KB4341221) SQL Server引擎 備份還原 Windows
12186129 修正:啟用 TDE 且具有壓縮功能的資料庫備份會導致 SQL Server (KB4101502) SQL Server引擎 備份還原 全部
12108225 修正:在 SQL Server (KB4339858) 實例中停用追蹤旗標 3459 之後,平行重做無法運作 SQL Server引擎 高可用性和災害復原 全部
12149855 修正:在 2017 年 SQL Server 中搭配外部叢集技術使用 AlwaysOn 可用性群組時,會在故障轉移之後發生分割大腦案例 (KB4341219) SQL Server引擎 高可用性和災害復原 全部
12144190 修正:SQL Server 2017 年 Linux 版在復原 In-Memory OLTP 資料庫時意外關閉 (KB4340069) SQL Server引擎 In-Memory OLTP Linux
12162067 改進:允許 SQL Server Agent 作業啟動,而不需要等待所有資料庫在 2017 年 SQL Server 在 Linux 上復原 (KB4341264) SQL Server引擎 Linux Linux
12128861 修正:SQLDUMPER.EXE 起始的傾印可能需要很長的時間才能在 SQL Server 2017 SQL Server Linux 上完成傾印產生程式 (KB4340747) SQL Server引擎 Linux Linux
11922902 修正:更新統計數據查詢在 SQL Server (KB4316858) 上使用哈希匯總時,「損毀的索引」訊息和伺服器中斷連線 SQL Server引擎 查詢優化器 全部
12111717 修正:在提取訂閱資料庫上具有資料庫快照集的 SQL Server 上套用 Hotfix 時發生錯誤 3906 (KB4340837) SQL Server引擎 複製 Windows
12107546 修正:SQL Server 的實例可能沒有回應,然後可能會在 2017 SQL Server 2017 年發生「未產生排程器」錯誤 (KB4338890) SQL Server引擎 SQL OS Windows
12061383 修正:DMV sys.dm_db_log_statssys.dm_db_log_info 可能會針對 SQL Server 2017 實例的最後一個資料庫傳回不正確的值 (KB4341253) SQL Server引擎 SQL OS Windows

如何取得或下載此或最新的累積更新套件

如何取得或下載 Windows (建議) 的最新累積更新套件

下列更新可從 Microsoft 下載中心取得:

立即下載 SQL Server 2017 的最新累積更新套件

如果下載頁面未出現,請連絡 Microsoft 客戶服務及支援 服務以取得累積更新套件。

如何從 Microsoft Update Catalog 取得或下載此適用於 Windows 的累積更新套件

注意事項

在 2017 年 SQL Server 發行未來的累積更新之後,即可從 Microsoft Update Catalog 下載此和所有先前的 SU。 不過,我們建議您一律安裝可用的最新累積更新。

下列更新可從 Microsoft Update Catalog 取得:

立即下載 SQL Server 2017 CU9 的累積更新套件

如何取得或下載 Linux 的最新累積更新套件

若要將Linux上的 SQL Server 2017 更新為最新的 CU,您必須先設定累積更新存放庫。 然後,使用適當的平臺特定更新命令來更新 SQL Server 套件。

如需 CU 套件下載的安裝指示和直接連結,請參閱 SQL Server 2017 版本資訊

檔案資訊

檔案哈希資訊

您可以使用下列命令,藉由計算 SQLServer2017-KB4341265-x64.exe 檔案的哈希來驗證下載:

certutil -hashfile SQLServer2017-KB4341265-x64.exe SHA256

檔案名稱 SHA256 哈希
SQLServer2017-KB4341265-x64.exe 6871130543A0DE2F9D1FA761E5B39101BC4CA667AE93E64C051323BEF1ABC6BA
累積更新套件檔案資訊

此套件的英文版本具有下表所列的文件屬性 (或更新版本的文件屬性) 。 這些檔案的日期和時間會列在國際標準時間 (UTC) 中。 當您檢視檔案資訊時,它會轉換成當地時間。 若要尋找 UTC 和當地時間之間的差異,請使用 控制台 中 [日期和時間] 專案中的 [時區] 索引標籤。

x64 型版本

SQL Server 2017 Analysis Services

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Asplatformhost.dll 2017.140.223.1 266408 22-Jun-18 02:03 x64
Microsoft.analysisservices.minterop.dll 14.0.223.1 741544 22-Jun-18 02:03 x86
Microsoft.analysisservices.server.core.dll 14.0.223.1 1380520 22-Jun-18 02:03 x86
Microsoft.analysisservices.server.tabular.dll 14.0.223.1 984232 22-Jun-18 02:03 x86
Microsoft.analysisservices.server.tabular.json.dll 14.0.223.1 521384 22-Jun-18 02:03 x86
Microsoft.applicationinsights.dll 2.6.0.6787 239328 20-Apr-18 23:59 x86
Microsoft.data.mashup.dll 2.57.5068.261 180424 06-Jun-18 04:34 x86
Microsoft.data.mashup.oledb.dll 2.57.5068.261 37584 06-Jun-18 04:34 x86
Microsoft.data.mashup.preview.dll 2.57.5068.261 54472 06-Jun-18 04:34 x86
Microsoft.data.mashup.providercommon.dll 2.57.5068.261 107728 06-Jun-18 04:34 x86
Microsoft.hostintegration.connectors.dll 2.57.5068.261 5223112 06-Jun-18 04:34 x86
Microsoft.mashup.container.exe 2.57.5068.261 26312 06-Jun-18 04:34 x64
Microsoft.mashup.container.netfx40.exe 2.57.5068.261 26824 06-Jun-18 04:34 x64
Microsoft.mashup.container.netfx45.exe 2.57.5068.261 26824 06-Jun-18 04:34 x64
Microsoft.mashup.eventsource.dll 2.57.5068.261 159440 06-Jun-18 04:34 x86
Microsoft.mashup.oauth.dll 2.57.5068.261 84176 06-Jun-18 04:34 x86
Microsoft.mashup.oledbprovider.dll 2.57.5068.261 67280 06-Jun-18 04:34 x86
Microsoft.mashup.shims.dll 2.57.5068.261 25808 06-Jun-18 04:34 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 151240 06-Jun-18 04:34 x86
Microsoft.mashupengine.dll 2.57.5068.261 13608144 06-Jun-18 04:34 x86
Microsoft.powerbi.adomdclient.dll 15.0.1.272 1106088 06-Jun-18 04:34 x86
Msmdctr.dll 2017.140.223.1 40104 22-Jun-18 02:03 x64
Msmdlocal.dll 2017.140.223.1 40384680 22-Jun-18 01:40 x86
Msmdlocal.dll 2017.140.223.1 60707488 22-Jun-18 02:03 x64
Msmdpump.dll 2017.140.223.1 9334952 22-Jun-18 02:03 x64
Msmdredir.dll 2017.140.223.1 7092384 22-Jun-18 01:40 x86
Msmdsrv.exe 2017.140.223.1 60608680 22-Jun-18 02:03 x64
Msmgdsrv.dll 2017.140.223.1 7310504 22-Jun-18 01:40 x86
Msmgdsrv.dll 2017.140.223.1 9004736 22-Jun-18 02:03 x64
Msolap.dll 2017.140.223.1 7777448 22-Jun-18 01:40 x86
Msolap.dll 2017.140.223.1 10258600 22-Jun-18 02:03 x64
Msolui.dll 2017.140.223.1 287400 22-Jun-18 01:40 x86
Msolui.dll 2017.140.223.1 310952 22-Jun-18 02:03 x64
Powerbiextensions.dll 2.57.5068.261 6606536 06-Jun-18 04:34 x86
Sql_as_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlboot.dll 2017.140.3030.27 196288 30-Jun-18 01:15 x64
Sqlceip.exe 14.0.3030.27 255144 30-Jun-18 01:22 x86
Sqldumper.exe 2017.140.3030.27 141472 30-Jun-18 01:11 x64
Sqldumper.exe 2017.140.3030.27 119464 30-Jun-18 01:12 x86
Tmapi.dll 2017.140.223.1 5821608 22-Jun-18 02:03 x64
Tmcachemgr.dll 2017.140.223.1 4164776 22-Jun-18 02:03 x64
Tmpersistence.dll 2017.140.223.1 1132192 22-Jun-18 02:03 x64
Tmtransactions.dll 2017.140.223.1 1641128 22-Jun-18 02:03 x64
Xe.dll 2017.140.3030.27 673440 30-Jun-18 00:59 x64
Xmlrw.dll 2017.140.3030.27 257704 30-Jun-18 01:14 x86
Xmlrw.dll 2017.140.3030.27 305320 30-Jun-18 01:15 x64
Xmlrwbin.dll 2017.140.3030.27 224424 30-Jun-18 01:00 x64
Xmlrwbin.dll 2017.140.3030.27 189608 30-Jun-18 01:14 x86
Xmsrv.dll 2017.140.223.1 33350816 22-Jun-18 01:40 x86
Xmsrv.dll 2017.140.223.1 25375400 22-Jun-18 02:03 x64

SQL Server 2017 Database Services Common Core

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Batchparser.dll 2017.140.3030.27 180904 30-Jun-18 00:48 x64
Batchparser.dll 2017.140.3030.27 160416 30-Jun-18 01:00 x86
Instapi140.dll 2017.140.3030.27 61096 30-Jun-18 01:00 x86
Instapi140.dll 2017.140.3030.27 70848 30-Jun-18 01:00 x64
Isacctchange.dll 2017.140.3030.27 29344 30-Jun-18 01:13 x86
Isacctchange.dll 2017.140.3030.27 30912 30-Jun-18 01:15 x64
Microsoft.analysisservices.adomdclient.dll 14.0.223.1 1088680 22-Jun-18 01:40 x86
Microsoft.analysisservices.adomdclient.dll 14.0.223.1 1088704 22-Jun-18 02:03 x86
Microsoft.analysisservices.core.dll 14.0.223.1 1381544 22-Jun-18 01:40 x86
Microsoft.analysisservices.xmla.dll 14.0.223.1 741544 22-Jun-18 01:40 x86
Microsoft.analysisservices.xmla.dll 14.0.223.1 741544 22-Jun-18 02:03 x86
Microsoft.sqlserver.edition.dll 14.0.3030.27 37024 30-Jun-18 01:13 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3030.27 78504 30-Jun-18 01:00 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3030.27 82088 30-Jun-18 01:00 x64
Msasxpress.dll 2017.140.223.1 31912 22-Jun-18 01:40 x86
Msasxpress.dll 2017.140.223.1 36008 22-Jun-18 02:03 x64
Pbsvcacctsync.dll 2017.140.3030.27 68264 30-Jun-18 01:14 x86
Pbsvcacctsync.dll 2017.140.3030.27 82600 30-Jun-18 01:15 x64
Sql_common_core_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqldumper.exe 2017.140.3030.27 141472 30-Jun-18 01:11 x64
Sqldumper.exe 2017.140.3030.27 119464 30-Jun-18 01:12 x86
Sqlftacct.dll 2017.140.3030.27 55464 30-Jun-18 01:14 x86
Sqlftacct.dll 2017.140.3030.27 62624 30-Jun-18 01:15 x64
Sqlmanager.dll 2017.140.17218.0 734952 21-Apr-18 00:33 x64
Sqlmanager.dll 2017.140.17218.0 602848 21-Apr-18 00:29 x86
Sqlmgmprovider.dll 2017.140.3030.27 372896 30-Jun-18 01:13 x86
Sqlmgmprovider.dll 2017.140.3030.27 416424 30-Jun-18 01:15 x64
Sqlsecacctchg.dll 2017.140.3030.27 34984 30-Jun-18 01:14 x86
Sqlsecacctchg.dll 2017.140.3030.27 37536 30-Jun-18 01:23 x64
Sqlsvcsync.dll 2017.140.3030.27 273576 30-Jun-18 01:14 x86
Sqlsvcsync.dll 2017.140.3030.27 356008 30-Jun-18 01:15 x64
Sqltdiagn.dll 2017.140.3030.27 60584 30-Jun-18 00:48 x86
Sqltdiagn.dll 2017.140.3030.27 67752 30-Jun-18 01:00 x64
Svrenumapi140.dll 2017.140.3030.27 894120 30-Jun-18 01:00 x86
Svrenumapi140.dll 2017.140.3030.27 1173160 30-Jun-18 01:00 x64

SQL Server 2017 sql_dreplay_client

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Dreplayclient.exe 2017.140.3030.27 121000 30-Jun-18 01:30 x86
Dreplaycommon.dll 2017.140.3030.27 699048 30-Jun-18 01:13 x86
Dreplayserverps.dll 2017.140.3030.27 32936 30-Jun-18 00:48 x86
Dreplayutil.dll 2017.140.3030.27 309928 30-Jun-18 01:22 x86
Instapi140.dll 2017.140.3030.27 70848 30-Jun-18 01:00 x64
Sql_dreplay_client_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlresourceloader.dll 2017.140.3030.27 29352 30-Jun-18 00:48 x86

SQL Server 2017 sql_dreplay_controller

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Dreplaycommon.dll 2017.140.3030.27 699048 30-Jun-18 01:13 x86
Dreplaycontroller.exe 2017.140.3030.27 350368 30-Jun-18 01:22 x86
Dreplayprocess.dll 2017.140.3030.27 171680 30-Jun-18 01:13 x86
Dreplayserverps.dll 2017.140.3030.27 32936 30-Jun-18 00:48 x86
Instapi140.dll 2017.140.3030.27 70848 30-Jun-18 01:00 x64
Sql_dreplay_controller_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlresourceloader.dll 2017.140.3030.27 29352 30-Jun-18 00:48 x86

SQL Server 2017 Database Services Core 實例

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Batchparser.dll 2017.140.3030.27 180904 30-Jun-18 00:48 x64
C1.dll 18.10.40116.18 909312 20-Apr-18 23:43 x64
C2.dll 18.10.40116.18 5325312 20-Apr-18 23:43 x64
Cl.exe 18.10.40116.18 176128 20-Apr-18 23:43 x64
Databasemailprotocols.dll 14.0.17178.0 48352 21-Apr-18 00:28 x86
Datacollectorcontroller.dll 2017.140.3030.27 226464 30-Jun-18 01:15 x64
Dcexec.exe 2017.140.3030.27 74408 30-Jun-18 01:23 x64
Fssres.dll 2017.140.3030.27 89760 30-Jun-18 01:23 x64
Hadrres.dll 2017.140.3030.27 188072 30-Jun-18 01:15 x64
Hkcompile.dll 2017.140.3030.27 1423016 30-Jun-18 01:23 x64
Hkengine.dll 2017.140.3030.27 5858464 30-Jun-18 01:23 x64
Hkruntime.dll 2017.140.3030.27 162984 30-Jun-18 01:23 x64
Link.exe 12.10.40116.18 1001472 20-Apr-18 23:43 x64
Microsoft.analysisservices.applocal.xmla.dll 14.0.223.1 741032 22-Jun-18 02:03 x86
Microsoft.applicationinsights.dll 2.6.0.6787 239328 20-Apr-18 23:59 x86
Microsoft.sqlautoadmin.autobackupagent.dll 14.0.3030.27 237224 30-Jun-18 01:31 x86
Microsoft.sqlautoadmin.sqlautoadmin.dll 14.0.3030.27 79528 30-Jun-18 01:29 x86
Microsoft.sqlserver.vdiinterface.dll 2017.140.3030.27 71336 30-Jun-18 01:00 x64
Microsoft.sqlserver.xe.core.dll 2017.140.3030.27 65192 30-Jun-18 00:59 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 152232 30-Jun-18 01:22 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 159400 30-Jun-18 01:11 x64
Microsoft.sqlserver.xevent.linq.dll 2017.140.3030.27 304296 30-Jun-18 01:11 x64
Microsoft.sqlserver.xevent.targets.dll 2017.140.3030.27 74920 30-Jun-18 01:29 x64
Msobj120.dll 12.10.40116.18 113664 20-Apr-18 23:43 x64
Mspdb120.dll 12.10.40116.18 543232 20-Apr-18 23:43 x64
Mspdbcore.dll 12.10.40116.18 543232 20-Apr-18 23:43 x64
Msvcp120.dll 12.10.40116.18 645120 20-Apr-18 23:43 x64
Msvcr120.dll 12.10.40116.18 948736 20-Apr-18 23:43 x64
Odsole70.dll 2017.140.3030.27 92840 30-Jun-18 01:15 x64
Opends60.dll 2017.140.3030.27 32928 30-Jun-18 00:48 x64
Qds.dll 2017.140.3030.27 1168552 30-Jun-18 09:52 x64
Rsfxft.dll 2017.140.3030.27 34472 30-Jun-18 00:48 x64
Secforwarder.dll 2017.140.3030.27 37536 30-Jun-18 01:15 x64
Sqagtres.dll 2017.140.3030.27 74408 30-Jun-18 01:15 x64
Sql_engine_core_inst_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlaamss.dll 2017.140.3030.27 90304 30-Jun-18 01:31 x64
Sqlaccess.dll 2017.140.3030.27 474792 30-Jun-18 01:00 x64
Sqlagent.exe 2017.140.3030.27 582312 30-Jun-18 01:23 x64
Sqlagentctr140.dll 2017.140.3030.27 52904 30-Jun-18 01:13 x86
Sqlagentctr140.dll 2017.140.3030.27 62120 30-Jun-18 01:15 x64
Sqlagentlog.dll 2017.140.3030.27 32960 30-Jun-18 00:45 x64
Sqlagentmail.dll 2017.140.3030.27 53920 30-Jun-18 00:45 x64
Sqlboot.dll 2017.140.3030.27 196288 30-Jun-18 01:15 x64
Sqlceip.exe 14.0.3030.27 255144 30-Jun-18 01:22 x86
Sqlcmdss.dll 2017.140.3030.27 72872 30-Jun-18 01:15 x64
Sqlctr140.dll 2017.140.3030.27 112296 30-Jun-18 01:14 x86
Sqlctr140.dll 2017.140.3030.27 129192 30-Jun-18 01:15 x64
Sqldk.dll 2017.140.3030.27 2794152 30-Jun-18 09:57 x64
Sqldtsss.dll 2017.140.3030.27 107688 30-Jun-18 02:12 x64
Sqlevn70.rll 2017.140.3030.27 3367072 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 3786920 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 3821224 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 1445032 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 3588256 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 1497768 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 2089640 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3676840 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 4027048 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3596968 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3296936 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3914408 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3402912 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3917480 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3338920 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 2036392 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3779752 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3785384 30-Jun-18 01:13 x64
Sqlevn70.rll 2017.140.3030.27 3291304 30-Jun-18 01:13 x64
Sqlevn70.rll 2017.140.3030.27 3481792 30-Jun-18 01:14 x64
Sqlevn70.rll 2017.140.3030.27 3635904 30-Jun-18 01:14 x64
Sqlevn70.rll 2017.140.3030.27 3213992 30-Jun-18 01:14 x64
Sqliosim.com 2017.140.3030.27 313504 30-Jun-18 01:22 x64
Sqliosim.exe 2017.140.3030.27 3019944 30-Jun-18 01:23 x64
Sqllang.dll 2017.140.3030.27 41234088 30-Jun-18 10:19 x64
Sqlmin.dll 2017.140.3030.27 40450728 30-Jun-18 10:02 x64
Sqlolapss.dll 2017.140.3030.27 107688 30-Jun-18 01:15 x64
Sqlos.dll 2017.140.3030.27 26280 30-Jun-18 01:12 x64
Sqlpowershellss.dll 2017.140.3030.27 68264 30-Jun-18 01:15 x64
Sqlrepss.dll 2017.140.3030.27 64680 30-Jun-18 01:15 x64
Sqlresld.dll 2017.140.3030.27 30888 30-Jun-18 00:48 x64
Sqlresourceloader.dll 2017.140.3030.27 32416 30-Jun-18 00:45 x64
Sqlscm.dll 2017.140.3030.27 71336 30-Jun-18 01:15 x64
Sqlscriptdowngrade.dll 2017.140.3030.27 27808 30-Jun-18 00:48 x64
Sqlscriptupgrade.dll 2017.140.3030.27 5872800 30-Jun-18 00:48 x64
Sqlserverspatial140.dll 2017.140.3030.27 732840 30-Jun-18 01:15 x64
Sqlservr.exe 2017.140.3030.27 487592 30-Jun-18 09:52 x64
Sqlsvc.dll 2017.140.3030.27 161952 30-Jun-18 01:15 x64
Sqltses.dll 2017.140.3030.27 9537192 30-Jun-18 09:57 x64
Sqsrvres.dll 2017.140.3030.27 261280 30-Jun-18 01:15 x64
Svl.dll 2017.140.3030.27 153768 30-Jun-18 01:31 x64
Xe.dll 2017.140.3030.27 673440 30-Jun-18 00:59 x64
Xmlrw.dll 2017.140.3030.27 305320 30-Jun-18 01:15 x64
Xmlrwbin.dll 2017.140.3030.27 224424 30-Jun-18 01:00 x64
Xpadsi.exe 2017.140.3030.27 89768 30-Jun-18 01:15 x64
Xplog70.dll 2017.140.3030.27 75944 30-Jun-18 01:23 x64
Xpqueue.dll 2017.140.3030.27 74912 30-Jun-18 01:15 x64
Xprepl.dll 2017.140.3030.27 102080 30-Jun-18 01:15 x64
Xpsqlbot.dll 2017.140.3030.27 32424 30-Jun-18 01:15 x64
Xpstar.dll 2017.140.3030.27 438440 30-Jun-18 01:23 x64

SQL Server 2017 Database Services Core Shared

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Batchparser.dll 2017.140.3030.27 180904 30-Jun-18 00:48 x64
Batchparser.dll 2017.140.3030.27 160416 30-Jun-18 01:00 x86
Bcp.exe 2017.140.3030.27 119968 30-Jun-18 01:15 x64
Commanddest.dll 2017.140.3030.27 245920 30-Jun-18 01:14 x64
Datacollectorenumerators.dll 2017.140.3030.27 116392 30-Jun-18 01:15 x64
Datacollectortasks.dll 2017.140.3030.27 187560 30-Jun-18 01:23 x64
Distrib.exe 2017.140.3030.27 203432 30-Jun-18 01:15 x64
Dteparse.dll 2017.140.3030.27 111784 30-Jun-18 01:15 x64
Dteparsemgd.dll 2017.140.3030.27 89248 30-Jun-18 01:15 x64
Dtepkg.dll 2017.140.3030.27 138912 30-Jun-18 01:23 x64
Dtexec.exe 2017.140.3030.27 73896 30-Jun-18 01:23 x64
Dts.dll 2017.140.3030.27 2998952 30-Jun-18 01:23 x64
Dtscomexpreval.dll 2017.140.3030.27 475304 30-Jun-18 01:15 x64
Dtsconn.dll 2017.140.3030.27 497312 30-Jun-18 01:23 x64
Dtshost.exe 2017.140.3030.27 104616 30-Jun-18 01:15 x64
Dtslog.dll 2017.140.3030.27 120488 30-Jun-18 01:15 x64
Dtsmsg140.dll 2017.140.3030.27 545448 30-Jun-18 01:15 x64
Dtspipeline.dll 2017.140.3030.27 1266336 30-Jun-18 01:23 x64
Dtspipelineperf140.dll 2017.140.3030.27 48296 30-Jun-18 01:15 x64
Dtuparse.dll 2017.140.3030.27 89256 30-Jun-18 01:15 x64
Dtutil.exe 2017.140.3030.27 147104 30-Jun-18 01:15 x64
Exceldest.dll 2017.140.3030.27 260776 30-Jun-18 01:15 x64
Excelsrc.dll 2017.140.3030.27 282792 30-Jun-18 01:15 x64
Execpackagetask.dll 2017.140.3030.27 168104 30-Jun-18 01:15 x64
Flatfiledest.dll 2017.140.3030.27 386728 30-Jun-18 01:15 x64
Flatfilesrc.dll 2017.140.3030.27 399016 30-Jun-18 01:15 x64
Foreachfileenumerator.dll 2017.140.3030.27 96424 30-Jun-18 01:23 x64
Hkengperfctrs.dll 2017.140.3030.27 59560 30-Jun-18 01:15 x64
Logread.exe 2017.140.3030.27 635048 30-Jun-18 01:15 x64
Mergetxt.dll 2017.140.3030.27 63680 30-Jun-18 01:15 x64
Microsoft.analysisservices.applocal.core.dll 14.0.223.1 1381544 22-Jun-18 02:03 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 21-Apr-18 00:24 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3030.27 89760 30-Jun-18 01:39 x86
Microsoft.sqlserver.manageddts.dll 14.0.3030.27 614056 30-Jun-18 01:23 x86
Microsoft.sqlserver.replication.dll 2017.140.3030.27 1663656 30-Jun-18 01:15 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 152232 30-Jun-18 01:22 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 159400 30-Jun-18 01:11 x64
Msdtssrvrutil.dll 2017.140.3030.27 103080 30-Jun-18 01:15 x64
Msgprox.dll 2017.140.3030.27 270504 30-Jun-18 01:15 x64
Msxmlsql.dll 2017.140.3030.27 1448104 30-Jun-18 01:15 x64
Oledbdest.dll 2017.140.3030.27 261280 30-Jun-18 01:23 x64
Oledbsrc.dll 2017.140.3030.27 288928 30-Jun-18 01:23 x64
Osql.exe 2017.140.3030.27 75432 30-Jun-18 00:48 x64
Qrdrsvc.exe 2017.140.3030.27 473768 30-Jun-18 01:15 x64
Rawdest.dll 2017.140.3030.27 206504 30-Jun-18 01:23 x64
Rawsource.dll 2017.140.3030.27 194216 30-Jun-18 01:15 x64
Rdistcom.dll 2017.140.3030.27 857256 30-Jun-18 01:15 x64
Recordsetdest.dll 2017.140.3030.27 184488 30-Jun-18 01:15 x64
Replagnt.dll 2017.140.3030.27 30888 30-Jun-18 01:15 x64
Repldp.dll 2017.140.3030.27 290976 30-Jun-18 01:15 x64
Replerrx.dll 2017.140.3030.27 154280 30-Jun-18 01:15 x64
Replisapi.dll 2017.140.3030.27 362152 30-Jun-18 01:15 x64
Replmerg.exe 2017.140.3030.27 524968 30-Jun-18 01:15 x64
Replprov.dll 2017.140.3030.27 801960 30-Jun-18 01:15 x64
Replrec.dll 2017.140.3030.27 975528 30-Jun-18 01:15 x64
Replsub.dll 2017.140.3030.27 445608 30-Jun-18 01:15 x64
Replsync.dll 2017.140.3030.27 154280 30-Jun-18 01:15 x64
Spresolv.dll 2017.140.3030.27 252072 30-Jun-18 01:15 x64
Sql_engine_core_shared_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlcmd.exe 2017.140.3030.27 249000 30-Jun-18 01:15 x64
Sqldiag.exe 2017.140.3030.27 1257640 30-Jun-18 01:15 x64
Sqldistx.dll 2017.140.3030.27 225448 30-Jun-18 01:15 x64
Sqllogship.exe 14.0.3030.27 105640 30-Jun-18 00:48 x64
Sqlmergx.dll 2017.140.3030.27 360616 30-Jun-18 01:15 x64
Sqlresld.dll 2017.140.3030.27 30888 30-Jun-18 00:48 x64
Sqlresld.dll 2017.140.3030.27 28832 30-Jun-18 01:13 x86
Sqlresourceloader.dll 2017.140.3030.27 32416 30-Jun-18 00:45 x64
Sqlresourceloader.dll 2017.140.3030.27 29352 30-Jun-18 00:48 x86
Sqlscm.dll 2017.140.3030.27 61096 30-Jun-18 01:13 x86
Sqlscm.dll 2017.140.3030.27 71336 30-Jun-18 01:15 x64
Sqlsvc.dll 2017.140.3030.27 134824 30-Jun-18 01:13 x86
Sqlsvc.dll 2017.140.3030.27 161952 30-Jun-18 01:15 x64
Sqltaskconnections.dll 2017.140.3030.27 182944 30-Jun-18 01:15 x64
Sqlwep140.dll 2017.140.3030.27 105640 30-Jun-18 00:48 x64
Ssdebugps.dll 2017.140.3030.27 33440 30-Jun-18 01:15 x64
Ssisoledb.dll 2017.140.3030.27 216256 30-Jun-18 01:15 x64
Ssradd.dll 2017.140.3030.27 75424 30-Jun-18 01:15 x64
Ssravg.dll 2017.140.3030.27 75944 30-Jun-18 01:15 x64
Ssrdown.dll 2017.140.3030.27 60576 30-Jun-18 01:15 x64
Ssrmax.dll 2017.140.3030.27 73384 30-Jun-18 01:15 x64
Ssrmin.dll 2017.140.3030.27 73896 30-Jun-18 01:15 x64
Ssrpub.dll 2017.140.3030.27 61600 30-Jun-18 01:15 x64
Ssrup.dll 2017.140.3030.27 60584 30-Jun-18 01:15 x64
Txagg.dll 2017.140.3030.27 362144 30-Jun-18 01:15 x64
Txbdd.dll 2017.140.3030.27 170152 30-Jun-18 01:23 x64
Txdatacollector.dll 2017.140.3030.27 360608 30-Jun-18 01:15 x64
Txdataconvert.dll 2017.140.3030.27 293032 30-Jun-18 01:23 x64
Txderived.dll 2017.140.3030.27 604320 30-Jun-18 01:15 x64
Txlookup.dll 2017.140.3030.27 528040 30-Jun-18 01:15 x64
Txmerge.dll 2017.140.3030.27 230048 30-Jun-18 01:15 x64
Txmergejoin.dll 2017.140.3030.27 275624 30-Jun-18 01:23 x64
Txmulticast.dll 2017.140.3030.27 127656 30-Jun-18 01:23 x64
Txrowcount.dll 2017.140.3030.27 125600 30-Jun-18 01:23 x64
Txsort.dll 2017.140.3030.27 256672 30-Jun-18 01:15 x64
Txsplit.dll 2017.140.3030.27 596648 30-Jun-18 01:23 x64
Txunionall.dll 2017.140.3030.27 181928 30-Jun-18 01:15 x64
Xe.dll 2017.140.3030.27 673440 30-Jun-18 00:59 x64
Xmlrw.dll 2017.140.3030.27 305320 30-Jun-18 01:15 x64
Xmlsub.dll 2017.140.3030.27 261280 30-Jun-18 01:15 x64

SQL Server 2017 sql_extensibility

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Launchpad.exe 2017.140.3030.27 1125032 30-Jun-18 01:39 x64
Sql_extensibility_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlsatellite.dll 2017.140.3030.27 922280 30-Jun-18 01:39 x64

SQL Server 2017 Full-Text 引擎

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Fd.dll 2017.140.3030.27 667304 30-Jun-18 01:15 x64
Fdhost.exe 2017.140.3030.27 114848 30-Jun-18 01:23 x64
Fdlauncher.exe 2017.140.3030.27 62632 30-Jun-18 01:15 x64
Sql_fulltext_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlft140ph.dll 2017.140.3030.27 68264 30-Jun-18 01:00 x64

SQL Server 2017 sql_inst_mr

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Imrdll.dll 14.0.3030.27 23720 30-Jun-18 01:00 x86
Sql_inst_mr_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64

SQL Server 2017 Integration Services

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Attunity.sqlserver.cdccontroltask.dll 5.0.0.70 75248 21-Apr-18 00:28 x86
Attunity.sqlserver.cdcsplit.dll 5.0.0.70 36336 21-Apr-18 00:28 x86
Attunity.sqlserver.cdcsrc.dll 5.0.0.70 76272 21-Apr-18 00:28 x86
Commanddest.dll 2017.140.3030.27 245920 30-Jun-18 01:14 x64
Commanddest.dll 2017.140.3030.27 200872 30-Jun-18 01:22 x86
Dteparse.dll 2017.140.3030.27 100520 30-Jun-18 01:13 x86
Dteparse.dll 2017.140.3030.27 111784 30-Jun-18 01:15 x64
Dteparsemgd.dll 2017.140.3030.27 83624 30-Jun-18 01:13 x86
Dteparsemgd.dll 2017.140.3030.27 89248 30-Jun-18 01:15 x64
Dtepkg.dll 2017.140.3030.27 116928 30-Jun-18 01:13 x86
Dtepkg.dll 2017.140.3030.27 138912 30-Jun-18 01:23 x64
Dtexec.exe 2017.140.3030.27 67752 30-Jun-18 01:13 x86
Dtexec.exe 2017.140.3030.27 73896 30-Jun-18 01:23 x64
Dts.dll 2017.140.3030.27 2549416 30-Jun-18 01:13 x86
Dts.dll 2017.140.3030.27 2998952 30-Jun-18 01:23 x64
Dtscomexpreval.dll 2017.140.3030.27 417960 30-Jun-18 01:13 x86
Dtscomexpreval.dll 2017.140.3030.27 475304 30-Jun-18 01:15 x64
Dtsconn.dll 2017.140.3030.27 399520 30-Jun-18 01:22 x86
Dtsconn.dll 2017.140.3030.27 497312 30-Jun-18 01:23 x64
Dtsdebughost.exe 2017.140.3030.27 111272 30-Jun-18 01:15 x64
Dtsdebughost.exe 2017.140.3030.27 95392 30-Jun-18 01:22 x86
Dtshost.exe 2017.140.3030.27 89768 30-Jun-18 01:13 x86
Dtshost.exe 2017.140.3030.27 104616 30-Jun-18 01:15 x64
Dtslog.dll 2017.140.3030.27 103080 30-Jun-18 01:13 x86
Dtslog.dll 2017.140.3030.27 120488 30-Jun-18 01:15 x64
Dtsmsg140.dll 2017.140.3030.27 541352 30-Jun-18 01:14 x86
Dtsmsg140.dll 2017.140.3030.27 545448 30-Jun-18 01:15 x64
Dtspipeline.dll 2017.140.3030.27 1059496 30-Jun-18 01:22 x86
Dtspipeline.dll 2017.140.3030.27 1266336 30-Jun-18 01:23 x64
Dtspipelineperf140.dll 2017.140.3030.27 42664 30-Jun-18 01:13 x86
Dtspipelineperf140.dll 2017.140.3030.27 48296 30-Jun-18 01:15 x64
Dtuparse.dll 2017.140.3030.27 80040 30-Jun-18 01:13 x86
Dtuparse.dll 2017.140.3030.27 89256 30-Jun-18 01:15 x64
Dtutil.exe 2017.140.3030.27 126120 30-Jun-18 01:13 x86
Dtutil.exe 2017.140.3030.27 147104 30-Jun-18 01:15 x64
Exceldest.dll 2017.140.3030.27 214696 30-Jun-18 01:13 x86
Exceldest.dll 2017.140.3030.27 260776 30-Jun-18 01:15 x64
Excelsrc.dll 2017.140.3030.27 282792 30-Jun-18 01:15 x64
Excelsrc.dll 2017.140.3030.27 230560 30-Jun-18 01:22 x86
Execpackagetask.dll 2017.140.3030.27 135336 30-Jun-18 01:13 x86
Execpackagetask.dll 2017.140.3030.27 168104 30-Jun-18 01:15 x64
Flatfiledest.dll 2017.140.3030.27 332968 30-Jun-18 01:13 x86
Flatfiledest.dll 2017.140.3030.27 386728 30-Jun-18 01:15 x64
Flatfilesrc.dll 2017.140.3030.27 344232 30-Jun-18 01:13 x86
Flatfilesrc.dll 2017.140.3030.27 399016 30-Jun-18 01:15 x64
Foreachfileenumerator.dll 2017.140.3030.27 80544 30-Jun-18 01:22 x86
Foreachfileenumerator.dll 2017.140.3030.27 96424 30-Jun-18 01:23 x64
Isdeploymentwizard.exe 14.0.3030.27 467104 30-Jun-18 06:00 x86
Isdeploymentwizard.exe 14.0.3030.27 466600 30-Jun-18 02:17 x64
Isserverexec.exe 14.0.3030.27 149160 30-Jun-18 01:39 x86
Isserverexec.exe 14.0.3030.27 148648 30-Jun-18 01:39 x64
Microsoft.analysisservices.applocal.core.dll 14.0.223.1 1381544 22-Jun-18 01:40 x86
Microsoft.analysisservices.applocal.core.dll 14.0.223.1 1381544 22-Jun-18 02:03 x86
Microsoft.applicationinsights.dll 2.6.0.6787 239328 20-Apr-18 23:59 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 21-Apr-18 00:24 x86
Microsoft.sqlserver.astasks.dll 14.0.3030.27 71336 30-Jun-18 01:31 x86
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3030.27 107176 30-Jun-18 01:13 x86
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3030.27 112296 30-Jun-18 01:15 x64
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3030.27 89768 30-Jun-18 01:30 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3030.27 89760 30-Jun-18 01:39 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3030.27 494760 30-Jun-18 00:48 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3030.27 494760 30-Jun-18 01:00 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3030.27 83624 30-Jun-18 01:22 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3030.27 83624 30-Jun-18 01:23 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3030.27 415936 30-Jun-18 06:00 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3030.27 415912 30-Jun-18 02:12 x86
Microsoft.sqlserver.manageddts.dll 14.0.3030.27 614056 30-Jun-18 01:22 x86
Microsoft.sqlserver.manageddts.dll 14.0.3030.27 614056 30-Jun-18 01:23 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3030.27 252584 30-Jun-18 01:13 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3030.27 252576 30-Jun-18 01:15 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 141984 30-Jun-18 01:22 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 152232 30-Jun-18 01:22 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 159400 30-Jun-18 01:11 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 145576 30-Jun-18 01:11 x86
Msdtssrvr.exe 14.0.3030.27 219816 30-Jun-18 01:31 x64
Msdtssrvrutil.dll 2017.140.3030.27 90272 30-Jun-18 01:13 x86
Msdtssrvrutil.dll 2017.140.3030.27 103080 30-Jun-18 01:15 x64
Msmdpp.dll 2017.140.223.1 9194152 22-Jun-18 02:03 x64
Oledbdest.dll 2017.140.3030.27 214696 30-Jun-18 01:13 x86
Oledbdest.dll 2017.140.3030.27 261280 30-Jun-18 01:23 x64
Oledbsrc.dll 2017.140.3030.27 233128 30-Jun-18 01:13 x86
Oledbsrc.dll 2017.140.3030.27 288928 30-Jun-18 01:23 x64
Rawdest.dll 2017.140.3030.27 166560 30-Jun-18 01:13 x86
Rawdest.dll 2017.140.3030.27 206504 30-Jun-18 01:23 x64
Rawsource.dll 2017.140.3030.27 194216 30-Jun-18 01:15 x64
Rawsource.dll 2017.140.3030.27 153256 30-Jun-18 01:22 x86
Recordsetdest.dll 2017.140.3030.27 149160 30-Jun-18 01:13 x86
Recordsetdest.dll 2017.140.3030.27 184488 30-Jun-18 01:15 x64
Sql_is_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlceip.exe 14.0.3030.27 255144 30-Jun-18 01:22 x86
Sqldest.dll 2017.140.3030.27 213672 30-Jun-18 01:13 x86
Sqldest.dll 2017.140.3030.27 260776 30-Jun-18 01:15 x64
Sqltaskconnections.dll 2017.140.3030.27 155296 30-Jun-18 01:13 x86
Sqltaskconnections.dll 2017.140.3030.27 182944 30-Jun-18 01:15 x64
Ssisoledb.dll 2017.140.3030.27 176800 30-Jun-18 01:13 x86
Ssisoledb.dll 2017.140.3030.27 216256 30-Jun-18 01:15 x64
Txagg.dll 2017.140.3030.27 302248 30-Jun-18 01:13 x86
Txagg.dll 2017.140.3030.27 362144 30-Jun-18 01:15 x64
Txbdd.dll 2017.140.3030.27 136360 30-Jun-18 01:13 x86
Txbdd.dll 2017.140.3030.27 170152 30-Jun-18 01:23 x64
Txbestmatch.dll 2017.140.3030.27 493224 30-Jun-18 01:14 x86
Txbestmatch.dll 2017.140.3030.27 605344 30-Jun-18 01:15 x64
Txcache.dll 2017.140.3030.27 146088 30-Jun-18 01:13 x86
Txcache.dll 2017.140.3030.27 180392 30-Jun-18 01:15 x64
Txcharmap.dll 2017.140.3030.27 248992 30-Jun-18 01:13 x86
Txcharmap.dll 2017.140.3030.27 286880 30-Jun-18 01:15 x64
Txcopymap.dll 2017.140.3030.27 145568 30-Jun-18 01:13 x86
Txcopymap.dll 2017.140.3030.27 180392 30-Jun-18 01:23 x64
Txdataconvert.dll 2017.140.3030.27 253096 30-Jun-18 01:22 x86
Txdataconvert.dll 2017.140.3030.27 293032 30-Jun-18 01:23 x64
Txderived.dll 2017.140.3030.27 515744 30-Jun-18 01:14 x86
Txderived.dll 2017.140.3030.27 604320 30-Jun-18 01:15 x64
Txfileextractor.dll 2017.140.3030.27 160936 30-Jun-18 01:13 x86
Txfileextractor.dll 2017.140.3030.27 198816 30-Jun-18 01:23 x64
Txfileinserter.dll 2017.140.3030.27 159392 30-Jun-18 01:13 x86
Txfileinserter.dll 2017.140.3030.27 196776 30-Jun-18 01:15 x64
Txgroupdups.dll 2017.140.3030.27 231080 30-Jun-18 01:13 x86
Txgroupdups.dll 2017.140.3030.27 290472 30-Jun-18 01:15 x64
Txlineage.dll 2017.140.3030.27 110248 30-Jun-18 01:13 x86
Txlineage.dll 2017.140.3030.27 136864 30-Jun-18 01:15 x64
Txlookup.dll 2017.140.3030.27 528040 30-Jun-18 01:15 x64
Txlookup.dll 2017.140.3030.27 446624 30-Jun-18 01:22 x86
Txmerge.dll 2017.140.3030.27 176808 30-Jun-18 01:13 x86
Txmerge.dll 2017.140.3030.27 230048 30-Jun-18 01:15 x64
Txmergejoin.dll 2017.140.3030.27 221864 30-Jun-18 01:13 x86
Txmergejoin.dll 2017.140.3030.27 275624 30-Jun-18 01:23 x64
Txmulticast.dll 2017.140.3030.27 102560 30-Jun-18 01:14 x86
Txmulticast.dll 2017.140.3030.27 127656 30-Jun-18 01:23 x64
Txpivot.dll 2017.140.3030.27 180392 30-Jun-18 01:13 x86
Txpivot.dll 2017.140.3030.27 224936 30-Jun-18 01:23 x64
Txrowcount.dll 2017.140.3030.27 101544 30-Jun-18 01:13 x86
Txrowcount.dll 2017.140.3030.27 125600 30-Jun-18 01:23 x64
Txsampling.dll 2017.140.3030.27 135848 30-Jun-18 01:13 x86
Txsampling.dll 2017.140.3030.27 172712 30-Jun-18 01:15 x64
Txscd.dll 2017.140.3030.27 220840 30-Jun-18 01:15 x64
Txscd.dll 2017.140.3030.27 170152 30-Jun-18 01:22 x86
Txsort.dll 2017.140.3030.27 208032 30-Jun-18 01:13 x86
Txsort.dll 2017.140.3030.27 256672 30-Jun-18 01:15 x64
Txsplit.dll 2017.140.3030.27 510632 30-Jun-18 01:13 x86
Txsplit.dll 2017.140.3030.27 596648 30-Jun-18 01:23 x64
Txtermextraction.dll 2017.140.3030.27 8615080 30-Jun-18 01:14 x86
Txtermextraction.dll 2017.140.3030.27 8676520 30-Jun-18 01:23 x64
Txtermlookup.dll 2017.140.3030.27 4157096 30-Jun-18 01:15 x64
Txtermlookup.dll 2017.140.3030.27 4106912 30-Jun-18 01:22 x86
Txunionall.dll 2017.140.3030.27 139432 30-Jun-18 01:13 x86
Txunionall.dll 2017.140.3030.27 181928 30-Jun-18 01:15 x64
Txunpivot.dll 2017.140.3030.27 160416 30-Jun-18 01:13 x86
Txunpivot.dll 2017.140.3030.27 199848 30-Jun-18 01:15 x64
Xe.dll 2017.140.3030.27 673440 30-Jun-18 00:59 x64
Xe.dll 2017.140.3030.27 595616 30-Jun-18 01:11 x86

SQL Server 2017 sql_polybase_core_inst

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Dms.dll 13.0.9124.18 523944 21-Apr-18 00:47 x86
Dmsnative.dll 2016.130.9124.18 78504 21-Apr-18 00:47 x64
Dwengineservice.dll 13.0.9124.18 45736 21-Apr-18 00:47 x86
Instapi140.dll 2017.140.3030.27 70848 30-Jun-18 01:00 x64
Microsoft.sqlserver.datawarehouse.backup.backupmetadata.dll 13.0.9124.18 74928 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.catalog.dll 13.0.9124.18 213672 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.common.dll 13.0.9124.18 1799336 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.configuration.dll 13.0.9124.18 116904 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.common.dll 13.0.9124.18 390312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.manager.dll 13.0.9124.18 196272 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagetypes.dll 13.0.9124.18 131248 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagingprotocol.dll 13.0.9124.18 63144 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.diagnostics.dll 13.0.9124.18 55464 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.distributor.dll 13.0.9124.18 93872 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.engine.dll 13.0.9124.18 792752 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.engine.statsstream.dll 13.0.9124.18 87720 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.eventing.dll 13.0.9124.18 78000 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.appliance.dll 13.0.9124.18 42152 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.fabric.interface.dll 13.0.9124.18 37032 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.polybase.dll 13.0.9124.18 47792 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.fabric.xdbinterface.dll 13.0.9124.18 27304 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.failover.dll 13.0.9124.18 32424 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.hadoop.hadoopbridge.dll 13.0.9124.18 129704 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.loadercommon.dll 13.0.9124.18 95400 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.loadmanager.dll 13.0.9124.18 109232 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.localization.dll 13.0.9124.18 264360 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 105128 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 119464 21-Apr-18 00:48 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 122536 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118952 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 129192 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 121512 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 116392 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 149680 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 103080 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118440 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.nodes.dll 13.0.9124.18 70312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.nulltransaction.dll 13.0.9124.18 28840 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.parallelizer.dll 13.0.9124.18 43688 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.resourcemanagement.dll 13.0.9124.18 83624 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.setup.componentupgradelibrary.dll 13.0.9124.18 136872 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.dll 13.0.9124.18 2341040 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.parser.dll 13.0.9124.18 3860136 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 110760 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123560 21-Apr-18 00:48 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 128176 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124080 21-Apr-18 00:49 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 136872 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124584 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 121512 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 156328 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 108712 21-Apr-18 00:46 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123048 21-Apr-18 00:50 x86
Microsoft.sqlserver.datawarehouse.sqldistributor.dll 13.0.9124.18 70312 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.transactsql.scriptdom.dll 13.0.9124.18 2756264 21-Apr-18 00:47 x86
Microsoft.sqlserver.datawarehouse.utilities.dll 13.0.9124.18 751784 21-Apr-18 00:47 x86
Mpdwinterop.dll 2017.140.3030.27 407208 30-Jun-18 01:15 x64
Mpdwsvc.exe 2017.140.3030.27 7324328 30-Jun-18 01:38 x64
Pdwodbcsql11.dll 2017.140.3030.27 2263208 30-Jun-18 01:00 x64
Secforwarder.dll 2017.140.3030.27 37536 30-Jun-18 01:15 x64
Sharedmemory.dll 2016.130.9124.18 64688 21-Apr-18 00:19 x64
Sqldk.dll 2017.140.3030.27 2711552 30-Jun-18 01:12 x64
Sqldumper.exe 2017.140.3030.27 141472 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 1497768 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3914408 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3213992 30-Jun-18 01:14 x64
Sqlevn70.rll 2017.140.3030.27 3917480 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3821224 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 2089640 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 2036392 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 3588256 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 3596968 30-Jun-18 01:12 x64
Sqlevn70.rll 2017.140.3030.27 1445032 30-Jun-18 01:11 x64
Sqlevn70.rll 2017.140.3030.27 3785384 30-Jun-18 01:13 x64
Sqlos.dll 2017.140.3030.27 26280 30-Jun-18 01:12 x64
Sqlsortpdw.dll 2016.130.9124.18 4348072 21-Apr-18 00:47 x64
Sqltses.dll 2017.140.3030.27 9691136 30-Jun-18 01:22 x64

SQL Server 2017 sql_shared_mr

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Smrdll.dll 14.0.3030.27 23720 30-Jun-18 00:48 x86
Sql_engine_core_shared_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64

SQL Server 2017 sql_tools_extensions

檔案名稱 檔案版本 檔案大小 日期 時間 平台
Autoadmin.dll 2017.140.3030.27 1448616 30-Jun-18 01:22 x86
Dtaengine.exe 2017.140.3030.27 204448 30-Jun-18 01:22 x86
Dteparse.dll 2017.140.3030.27 100520 30-Jun-18 01:13 x86
Dteparse.dll 2017.140.3030.27 111784 30-Jun-18 01:15 x64
Dteparsemgd.dll 2017.140.3030.27 83624 30-Jun-18 01:13 x86
Dteparsemgd.dll 2017.140.3030.27 89248 30-Jun-18 01:15 x64
Dtepkg.dll 2017.140.3030.27 116928 30-Jun-18 01:13 x86
Dtepkg.dll 2017.140.3030.27 138912 30-Jun-18 01:23 x64
Dtexec.exe 2017.140.3030.27 67752 30-Jun-18 01:13 x86
Dtexec.exe 2017.140.3030.27 73896 30-Jun-18 01:23 x64
Dts.dll 2017.140.3030.27 2549416 30-Jun-18 01:13 x86
Dts.dll 2017.140.3030.27 2998952 30-Jun-18 01:23 x64
Dtscomexpreval.dll 2017.140.3030.27 417960 30-Jun-18 01:13 x86
Dtscomexpreval.dll 2017.140.3030.27 475304 30-Jun-18 01:15 x64
Dtsconn.dll 2017.140.3030.27 399520 30-Jun-18 01:22 x86
Dtsconn.dll 2017.140.3030.27 497312 30-Jun-18 01:23 x64
Dtshost.exe 2017.140.3030.27 89768 30-Jun-18 01:13 x86
Dtshost.exe 2017.140.3030.27 104616 30-Jun-18 01:15 x64
Dtslog.dll 2017.140.3030.27 103080 30-Jun-18 01:13 x86
Dtslog.dll 2017.140.3030.27 120488 30-Jun-18 01:15 x64
Dtsmsg140.dll 2017.140.3030.27 541352 30-Jun-18 01:14 x86
Dtsmsg140.dll 2017.140.3030.27 545448 30-Jun-18 01:15 x64
Dtspipeline.dll 2017.140.3030.27 1059496 30-Jun-18 01:22 x86
Dtspipeline.dll 2017.140.3030.27 1266336 30-Jun-18 01:23 x64
Dtspipelineperf140.dll 2017.140.3030.27 42664 30-Jun-18 01:13 x86
Dtspipelineperf140.dll 2017.140.3030.27 48296 30-Jun-18 01:15 x64
Dtuparse.dll 2017.140.3030.27 80040 30-Jun-18 01:13 x86
Dtuparse.dll 2017.140.3030.27 89256 30-Jun-18 01:15 x64
Dtutil.exe 2017.140.3030.27 126120 30-Jun-18 01:13 x86
Dtutil.exe 2017.140.3030.27 147104 30-Jun-18 01:15 x64
Exceldest.dll 2017.140.3030.27 214696 30-Jun-18 01:13 x86
Exceldest.dll 2017.140.3030.27 260776 30-Jun-18 01:15 x64
Excelsrc.dll 2017.140.3030.27 282792 30-Jun-18 01:15 x64
Excelsrc.dll 2017.140.3030.27 230560 30-Jun-18 01:22 x86
Flatfiledest.dll 2017.140.3030.27 332968 30-Jun-18 01:13 x86
Flatfiledest.dll 2017.140.3030.27 386728 30-Jun-18 01:15 x64
Flatfilesrc.dll 2017.140.3030.27 344232 30-Jun-18 01:13 x86
Flatfilesrc.dll 2017.140.3030.27 399016 30-Jun-18 01:15 x64
Foreachfileenumerator.dll 2017.140.3030.27 80544 30-Jun-18 01:22 x86
Foreachfileenumerator.dll 2017.140.3030.27 96424 30-Jun-18 01:23 x64
Microsoft.sqlserver.astasks.dll 14.0.3030.27 71336 30-Jun-18 01:30 x86
Microsoft.sqlserver.astasksui.dll 14.0.3030.27 184480 30-Jun-18 06:10 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3030.27 406688 30-Jun-18 01:13 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3030.27 406720 30-Jun-18 01:23 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3030.27 2093224 30-Jun-18 01:22 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3030.27 2093224 30-Jun-18 01:23 x86
Microsoft.sqlserver.manageddts.dll 14.0.3030.27 614056 30-Jun-18 01:22 x86
Microsoft.sqlserver.manageddts.dll 14.0.3030.27 614056 30-Jun-18 01:23 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3030.27 252584 30-Jun-18 01:13 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 141984 30-Jun-18 01:22 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3030.27 152232 30-Jun-18 01:22 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 159400 30-Jun-18 01:11 x64
Microsoft.sqlserver.xevent.dll 2017.140.3030.27 145576 30-Jun-18 01:11 x86
Msdtssrvrutil.dll 2017.140.3030.27 90272 30-Jun-18 01:13 x86
Msdtssrvrutil.dll 2017.140.3030.27 103080 30-Jun-18 01:15 x64
Msmgdsrv.dll 2017.140.223.1 7310504 22-Jun-18 01:40 x86
Oledbdest.dll 2017.140.3030.27 214696 30-Jun-18 01:13 x86
Oledbdest.dll 2017.140.3030.27 261280 30-Jun-18 01:23 x64
Oledbsrc.dll 2017.140.3030.27 233128 30-Jun-18 01:13 x86
Oledbsrc.dll 2017.140.3030.27 288928 30-Jun-18 01:23 x64
Sql_tools_extensions_keyfile.dll 2017.140.3030.27 100520 30-Jun-18 00:45 x64
Sqlresld.dll 2017.140.3030.27 30888 30-Jun-18 00:48 x64
Sqlresld.dll 2017.140.3030.27 28832 30-Jun-18 01:13 x86
Sqlresourceloader.dll 2017.140.3030.27 32416 30-Jun-18 00:45 x64
Sqlresourceloader.dll 2017.140.3030.27 29352 30-Jun-18 00:48 x86
Sqlscm.dll 2017.140.3030.27 61096 30-Jun-18 01:13 x86
Sqlscm.dll 2017.140.3030.27 71336 30-Jun-18 01:15 x64
Sqlsvc.dll 2017.140.3030.27 134824 30-Jun-18 01:13 x86
Sqlsvc.dll 2017.140.3030.27 161952 30-Jun-18 01:15 x64
Sqltaskconnections.dll 2017.140.3030.27 155296 30-Jun-18 01:13 x86
Sqltaskconnections.dll 2017.140.3030.27 182944 30-Jun-18 01:15 x64
Txdataconvert.dll 2017.140.3030.27 253096 30-Jun-18 01:22 x86
Txdataconvert.dll 2017.140.3030.27 293032 30-Jun-18 01:23 x64
Xe.dll 2017.140.3030.27 673440 30-Jun-18 00:59 x64
Xe.dll 2017.140.3030.27 595616 30-Jun-18 01:11 x86
Xmlrw.dll 2017.140.3030.27 257704 30-Jun-18 01:14 x86
Xmlrw.dll 2017.140.3030.27 305320 30-Jun-18 01:15 x64
Xmlrwbin.dll 2017.140.3030.27 224424 30-Jun-18 01:00 x64
Xmlrwbin.dll 2017.140.3030.27 189608 30-Jun-18 01:14 x86

此更新的注意事項

先決條件

若要套用此累積更新套件,您必須在 2017 SQL Server 執行。

重新啟動資訊

套用此累積更新套件之後,您可能必須重新啟動電腦。

登錄資訊

若要使用此套件中的其中一個 Hotfix,您不需要對登錄進行任何變更。

重要注意事項

本文也提供下列情況的重要資訊:

  • Pacemaker:會在使用最新可用 Pacemaker 版本的發行版中進行行為變更。 提供風險降低方法。

  • 查詢存放區:如果您使用 查詢存放區,而且先前已安裝 Microsoft SQL Server 2017 累積更新 2 (CU2) ,則必須執行此腳本。

Analysis Services CU 組建版本

從 Microsoft SQL Server 2017 開始,Analysis Services 組建版本號碼和 SQL Server Database Engine 組建版本號碼不相符。 如需詳細資訊,請 參閱驗證 Analysis Services 累積更新組建版本

(CU) 的累積更新

(CU) 的累積更新現在可在 Microsoft 下載中心取得。

下載中心僅提供 2017 年 SQL Server 發行的最新 CU。

適用於 Linux 的 CU 套件可在 https://packages.microsoft.com取得。

  • 每個新的 CU 都包含已安裝之 SQL Server 版舊版 CU 隨附的所有修正程式。
  • SQL Server的 SU 會認證為與 Service Pack 相同的層級,而且應該安裝在相同的信賴層級。
  • 我們建議您根據下列指導方針,在 CUS 可供使用時進行主動式安裝:
    • 歷程記錄數據顯示,大量支援案例牽涉到已在發行 CU 中解決的問題。
    • TU 可能包含 Hotfix 的上方和以上的加值。 這包括可支援性、管理性和可靠性更新。
  • 建議您先測試 SQL Server 個 RU,再將它們部署到生產環境。
Pacemaker 注意事項

重要

使用最新可用 Pacemaker 套件 1.1.18-11.el7 的所有 (散發套件,包括 RHEL 7.3 和 7.4) ,都會在叢集設定的值為 start-failure-is-fatalfalse時,引入叢集設定的行為變更。 這項變更會影響故障轉移工作流程。 如果主要複本發生中斷,叢集應該會故障轉移至其中一個可用的次要複本。 相反地,使用者會注意到叢集會持續嘗試啟動失敗的主要複本。 如果該主要復本因為永久中斷) 而無法上線 (,叢集永遠不會故障轉移至另一個可用的次要複本。

此問題會影響所有 SQL Server 版本,不論它們所使用的累積更新版本為何。

若要減輕此問題,請使用下列其中一種方法。

方法 1

依照下列步驟執行:

  1. 從現有的叢 start-failure-is-fatal 集移除覆寫。

    #RHEL、Ubuntu pcs 屬性 unset start-failure-is-fatal #或 pcs 屬性 set start-failure-is-fatal=true #SLES crm configure property start-failure-is-fatal=true

  2. cluster-recheck-interval減少值。

    # RHEL, Ubuntu pcs 屬性集 cluster-recheck-interval=<Xmin> # SLES crm configure property cluster-recheck-interval=<Xmin>

  3. 將中 failure-timeout 繼屬性新增至每個 AG 資源。

    # RHEL, Ubuntu pcs resource update ag1 meta failure-timeout=60s # SLES crm configure edit ag1 #在文本编辑器中,在任何 'param' 之後和任何 'op' 之前新增 'meta failure-timeout=60s'

    注意事項

    在此程式代碼中,請視需要取代 Xmin> 的值<。 如果復本停止運作,叢集會嘗試以值和 cluster-recheck-interval 值所failure-timeout系結的間隔重新啟動複本。 例如,如果 failure-timeout 設定為 60 秒且 cluster-recheck-interval 設定為 120 秒,則會以大於 60 秒但小於 120 秒的間隔嘗試重新啟動。 建議您將 設定為 60s ,並將 cluster-recheck-interval 設定failure-timeout為 大於 60 秒的值。 建議您不要將 設定 cluster-recheck-interval 為小型值。 如需詳細資訊,請參閱 Pacemaker 檔或參閱系統提供者。

方法 2

還原為 Pacemaker 1.1.16 版。

查詢存放區 注意事項

重要

如果您使用 查詢存放區,而且要從 SQL Server 2017 累積更新 2 (CU) 2 直接更新至 SQL Server 2017 累積更新 3 (CU3) 或任何更新版本的累積更新,則必須執行此腳本。 如果您先前已安裝 SQL Server 2017 累積更新 3 (CU3) 或任何 SQL Server 更新版本的 2017 年累積更新,則不需要執行此腳本。

SET NOCOUNT ON;
DROP TABLE IF EXISTS #tmpUserDBs;

SELECT [database_id], 0 AS [IsDone]
INTO #tmpUserDBs
FROM master.sys.databases
WHERE [database_id] > 4
 AND [state] = 0 -- must be ONLINE
 AND is_read_only = 0 -- cannot be READ_ONLY
 AND [database_id] NOT IN (SELECT dr.database_id FROM sys.dm_hadr_database_replica_states dr -- Except all local Always On secondary replicas
  INNER JOIN sys.dm_hadr_availability_replica_states rs ON dr.group_id = rs.group_id
  INNER JOIN sys.databases d ON dr.database_id = d.database_id
  WHERE rs.role = 2 -- Is Secondary
   AND dr.is_local = 1
   AND rs.is_local = 1)

DECLARE @userDB sysname;

WHILE (SELECT COUNT([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0) > 0
BEGIN
 SELECT TOP 1 @userDB = DB_NAME([database_id]) FROM #tmpUserDBs WHERE [IsDone] = 0

 -- PRINT 'Working on database ' + @userDB

 EXEC ('USE [' + @userDB + '];
DECLARE @clearPlan bigint, @clearQry bigint;
IF EXISTS (SELECT [actual_state] FROM sys.database_query_store_options WHERE [actual_state] IN (1,2))
BEGIN
 IF EXISTS (SELECT plan_id FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27'')
 BEGIN
  DROP TABLE IF EXISTS #tmpclearPlans;

  SELECT plan_id, query_id, 0 AS [IsDone]
  INTO #tmpclearPlans
  FROM sys.query_store_plan WHERE engine_version = ''14.0.3008.27''

  WHILE (SELECT COUNT(plan_id) FROM #tmpclearPlans WHERE [IsDone] = 0) > 0
  BEGIN
   SELECT TOP 1 @clearPlan = plan_id, @clearQry = query_id FROM #tmpclearPlans WHERE [IsDone] = 0
   EXECUTE sys.sp_query_store_unforce_plan @clearQry, @clearPlan;
   EXECUTE sys.sp_query_store_remove_plan @clearPlan;

   UPDATE #tmpclearPlans
   SET [IsDone] = 1
   WHERE plan_id = @clearPlan AND query_id = @clearQry
  END;

  PRINT ''- Cleared possibly affected plans in database [' + @userDB + ']''
 END
 ELSE
 BEGIN
  PRINT ''- No affected plans in database [' + @userDB + ']''
 END
END
ELSE
BEGIN
 PRINT ''- Query Store not enabled in database [' + @userDB + ']''
END')
  UPDATE #tmpUserDBs
  SET [IsDone] = 1
  WHERE [database_id] = DB_ID(@userDB)
END
混合式環境部署

當您將更新部署至混合式環境 (例如 Always On、複寫、叢集和鏡像) 時,建議您先參閱下列文章,再部署更新:

語言支援

SQL Server SU 目前為多語系。 因此,此 CU 套件不是單一語言特有的。 它適用於所有支持的語言。

已更新 (功能) 元件

一個 CU 套件包含所有 SQL Server 2017 元件的所有可用更新, (功能) 。 不過,累積更新套件只會更新您選取要提供服務的 SQL Server 實例上目前安裝的元件。 例如,如果 SQL Server 功能 (套用此 CU 之後,Analysis Services) 會新增至實例,您必須重新套用此 CU,才能將新功能更新至此 CU。

支援此更新

如果發生其他問題,或需要進行任何疑難解答,您可能必須建立服務要求。 一般的支援成本將適用於其他支持問題,以及不符合此特定累積更新套件資格的問題。 如需 Microsoft 客戶服務及支援電話號碼的完整清單,或建立個別的服務要求,請移至 Microsoft 支援網站

如何卸載此更新

如何在 Windows 上卸載此更新
  1. 在 控制台 中,開啟 [程式和功能] 專案,然後選取 [檢視已安裝的更新]
  2. 找出與 2017 SQL Server 下此累積更新套件相對應的專案。
  3. 按住 (,或以滑鼠右鍵按兩下) 項目,然後選取 [ 卸載]
如何在Linux上卸載此更新

若要在Linux上卸載此 CU,您必須將套件復原到舊版。 如需如何復原安裝的詳細資訊,請參閱復原 SQL Server

協力廠商資訊免責聲明

本文提及的協力廠商產品是由獨立廠商所製造,與 Microsoft 無涉。 Microsoft 不以暗示或其他方式擔保這些產品的效能或可靠性。

參考