共用方式為


KB4342123 - SQL Server 2017 的累積更新 10

發行日期: 2018 年 8 月 27 日
版本: 14.0.3037.1

摘要

本文說明 Microsoft SQL Server 2017 的累積更新套件 10 (CU10)。 此更新包含 SQL Server 2017 累積更新 9 版本之後發出的 21 個修正 程式,並更新下列組建中的元件:

  • SQL Server - 產品版本: 14.0.3037.1,檔案版本: 2017.140.3037.1
  • Analysis Services - 產品版本: 14.0.226.1,檔案版本: 2017.140.226.1

此更新中的已知問題

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

此更新中的改良功能和修正程式

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

注意

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

如需此累積更新中已修正的 Bug 和增強功能的詳細資訊,請參閱下列Microsoft知識庫文章。

錯誤參考 描述 修正區域 元件 平台
12201819 修正:篩選資料透視表專案並移除 SSAS 中的篩選條件後,總計錯誤(KB2932559) Analysis Services Analysis Services Windows
12227459 修正:資料庫同步處理需要很長的時間才能在 SQL Server 2017 中完成 (KB4345402) Analysis Services Analysis Services Windows
12245666 修正:當您在重新啟動 SSAS 2016 和 2017 之後執行 MDX 查詢時,不會傳回任何記錄(KB4340746) Analysis Services Analysis Services Windows
12229848 修正:當您在 SQL Server 2017 Master Data Services 中啟用 [需要核准] 許可權時,刪除作業無法在實體中運作(KB4346330) Master Data Services 用戶端 Windows
12210593 修正:當不需要時,在 Linux 上重新啟動 SQL Server 2017 的提示不正確(KB4053447) SQL Server 用戶端工具 命令行工具 Linux
12213556 修正:針對「已接受的NTLM SPN」變數設定的值會在 SQL Server 2017 啟動期間造成存取違規 (KB4345683) SQL Server 連線能力 通訊協定 Windows
12128370 修正:當您在 SQL Server 2017 的 AlwaysOn 可用性群組中備份資料庫時,會發生錯誤 3212 和 3013 (KB4346643) SQL Server Engine 備份 還原 Windows
12248777 修正:SQL Server 2016 和 2017 中基本可用性群組的次要復本 VSS 備份失敗(KB4341221) SQL Server Engine 備份 還原 Windows
12245662 修正:如果 SQL Server 中的次要複本上回報資料庫同步處理錯誤,主要復本的交易延遲 (KB4338576) SQL Server Engine 高可用性和災害復原 Windows
12247780 修正:在 Linux Docker 容器內執行 SQL Server 2017 時發生記憶體不足錯誤 (KB4347055) SQL Server Engine Linux Linux
12221447 修正:相較於 SQL Server 2016,當您執行包含 HASHBYTES 函式的查詢時,SQL Server 2017 的效能變慢 (KB4345228) SQL Server Engine 可程式性 Windows
12242742 修正:SQL Server 2016 和 2017 中針對單一查詢內死結發生報告許多xml_deadlock_report事件(KB4338715) SQL Server Engine 查詢執行 全部
12150907 改進:更新以支援 SQL Server 2017 中 USE HINT 選項中的 QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n (KB4342424) SQL Server Engine 查詢最佳化工具 全部
12171986 改進可讓 CREATE AVAILABILITY GROUP 和 ALTER AVAILABILITY GROUP DDL 設定 SQL Server 中僅限設定複本的SESSION_TIMEOUT (KB4344904) SQL Server Engine 複寫 全部
12249912 修正:變更追蹤 SQL Server 中 AlwaysOn 可用性群組的錯誤記錄檔中意外記錄的清除訊息 (KB4456883) SQL Server Engine 複寫 Windows
12203152 修正:當您在 SQL Server 2017 中開啟非對稱密鑰加密的對稱密鑰時發生錯誤(KB4346812) SQL Server Engine 安全基礎設施 Windows
12248752 修正:當您在 SQL Server 2016 和 2017 中啟用 DDM 函式時,就會發生敏感數據外洩 (KB4100582) SQL Server Engine 安全基礎設施 全部
12164662 修正:AUDIT_LOGIN和AUDIT_LOGIN_FAILED事件的事件通知會導致 SQL Server 2016 和 2017 中 TempDB 異常成長(KB4341398) SQL Server Engine Service Broker Windows
12177844 修正:sqlwepxxx.dll中發生記憶體流失,導致WmiPrvSe.exe進程當機(KB4133191) SQL Server Engine Service Broker Windows
12201714 修正:當您啟用大型頁面配置之後,MEMORYCLERK_SOSMEMMANAGER會變大並記錄FAIL_PAGE_ALLOCATION錯誤(KB4344103) SQL Server Engine SQL OS Windows
12251323 修正:即使 SQL Server 中有許多可用頁面,仍會發生記憶體不足錯誤(KB4347088) SQL Server Engine SQL OS Windows

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

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

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

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

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

如何從 Microsoft 更新目錄取得或下載 Windows 的這個累積更新套件

注意

未來 SQL Server 2017 累積更新發行之後,即可從 Microsoft 更新目錄下載這一點和所有先前的 OU。 不過,我們建議您一律安裝可用的最新累積更新。

下列更新可從 Microsoft 更新目錄取得:

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

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

若要將 Linux 上的 SQL Server 2017 更新至最新的 CU,您必須先完成設定累積更新存放庫 (部分機器翻譯)。 然後,使用特定於平台的適當更新命令更新您的 SQL Server 套件。

如需 CU 套件下載項目的安裝說明與直接連結,請參閱 SQL Server 2017 版本資訊 (部分機器翻譯)。

檔案資訊

檔案哈希資訊

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

certutil -hashfile SQLServer2017-KB4342123-x64.exe SHA256

File name SHA256 雜湊
SQLServer2017-KB4342123-x64.exe 29FBBA3E7738028A49E3DD9BB0EC9176ADEB939F3E0E40795A63A5C6559D38E4
累積更新套件檔案資訊

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

x64 型版本

SQL Server 2017 Analysis Services

File name 檔案版本 檔案大小 Date Time 平台
Asplatformhost.dll 2017.140.226.1 266408 27-Jul-18 1,658 x64
Microsoft.analysisservices.minterop.dll 14.0.226.1 741544 27-Jul-18 1,654 x86
Microsoft.analysisservices.server.core.dll 14.0.226.1 1380512 27-Jul-18 1,658 x86
Microsoft.analysisservices.server.tabular.dll 14.0.226.1 987112 27-Jul-18 1,658 x86
Microsoft.analysisservices.server.tabular.json.dll 14.0.226.1 522840 27-Jul-18 1,658 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 1,654 x86
Microsoft.data.mashup.dll 2.57.5068.261 180424 13-Jun-18 05:36 x86
Microsoft.data.mashup.oledb.dll 2.57.5068.261 37584 13-Jun-18 05:36 x86
Microsoft.data.mashup.preview.dll 2.57.5068.261 54,472 13-Jun-18 05:36 x86
Microsoft.data.mashup.providercommon.dll 2.57.5068.261 107728 13-Jun-18 05:36 x86
Microsoft.hostintegration.connectors.dll 2.57.5068.261 5223112 13-Jun-18 05:36 x86
Microsoft.mashup.container.exe 2.57.5068.261 26312 13-Jun-18 05:36 x64
Microsoft.mashup.container.netfx40.exe 2.57.5068.261 26824 13-Jun-18 05:36 x64
Microsoft.mashup.container.netfx45.exe 2.57.5068.261 26824 13-Jun-18 05:36 x64
Microsoft.mashup.eventsource.dll 2.57.5068.261 159440 13-Jun-18 05:36 x86
Microsoft.mashup.oauth.dll 2.57.5068.261 84176 13-Jun-18 05:36 x86
Microsoft.mashup.oledbprovider.dll 2.57.5068.261 67280 13-Jun-18 05:36 x86
Microsoft.mashup.shims.dll 2.57.5068.261 25808 13-Jun-18 05:36 x86
Microsoft.mashup.storage.xmlserializers.dll 1.0.0.0 151240 13-Jun-18 05:36 x86
Microsoft.mashupengine.dll 2.57.5068.261 13608144 13-Jun-18 05:36 x86
Microsoft.powerbi.adomdclient.dll 15.0.1.272 1106088 13-Jun-18 05:36 x86
Msmdctr.dll 2017.140.226.1 41520 27-Jul-18 1,658 x64
msmdlocal.dll 2017.140.226.1 40386216 27-Jul-18 16:30 x86
msmdlocal.dll 2017.140.226.1 60709544 27-Jul-18 1,658 x64
Msmdpump.dll 2017.140.226.1 9336408 27-Jul-18 1,658 x64
Msmdredir.dll 2017.140.226.1 7092392 27-Jul-18 16:30 x86
Msmdsrv.exe 2017.140.226.1 60609192 27-Jul-18 1,659 x64
msmgdsrv.dll 2017.140.226.1 7310504 27-Jul-18 16:30 x86
msmgdsrv.dll 2017.140.226.1 9006128 27-Jul-18 1,658 x64
Msolap.dll 2017.140.226.1 7777448 27-Jul-18 16:30 x86
Msolap.dll 2017.140.226.1 10258592 27-Jul-18 1,659 x64
Msolui.dll 2017.140.226.1 288816 27-Jul-18 16:30 x86
Msolui.dll 2017.140.226.1 312368 27-Jul-18 1,658 x64
Powerbiextensions.dll 2.57.5068.261 6606536 13-Jun-18 05:36 x86
Sql_as_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlboot.dll 2017.140.3037.1 199120 27-Jul-18 16:36 x64
Sqlceip.exe 14.0.3037.1 255632 27-Jul-18 1,658 x86
sqldumper.exe 2017.140.3037.1 142920 27-Jul-18 1,654 x64
sqldumper.exe 2017.140.3037.1 120904 27-Jul-18 16:56 x86
Tmapi.dll 2017.140.226.1 5821608 27-Jul-18 1,658 x64
Tmcachemgr.dll 2017.140.226.1 4164776 27-Jul-18 1,658 x64
Tmpersistence.dll 2017.140.226.1 1132224 27-Jul-18 1,658 x64
Tmtransactions.dll 2017.140.226.1 1641128 27-Jul-18 1,658 x64
Xe.dll 2017.140.3037.1 674888 27-Jul-18 1,654 x64
xmlrw.dll 2017.140.3037.1 305296 27-Jul-18 16:36 x64
xmlrw.dll 2017.140.3037.1 259144 27-Jul-18 16:57 x86
xmlrwbin.dll 2017.140.3037.1 191072 27-Jul-18 16:36 x86
xmlrwbin.dll 2017.140.3037.1 225864 27-Jul-18 1,658 x64
xmsrv.dll 2017.140.226.1 33350824 27-Jul-18 16:30 x86
xmsrv.dll 2017.140.226.1 25375400 27-Jul-18 1,659 x64

SQL Server 2017 Database Services Common Core

File name 檔案版本 檔案大小 Date Time 平台
Batchparser.dll 2017.140.3037.1 182304 27-Jul-18 16:30 x64
Batchparser.dll 2017.140.3037.1 161824 27-Jul-18 16:36 x86
Instapi140.dll 2017.140.3037.1 72224 27-Jul-18 16:36 x64
Instapi140.dll 2017.140.3037.1 63,952 27-Jul-18 16:57 x86
Isacctchange.dll 2017.140.3037.1 30792 27-Jul-18 16:57 x86
Isacctchange.dll 2017.140.3037.1 32288 27-Jul-18 1,658 x64
Microsoft.analysisservices.adomdclient.dll 14.0.226.1 1091560 27-Jul-18 16:30 x86
Microsoft.analysisservices.adomdclient.dll 14.0.226.1 1088672 27-Jul-18 1,658 x86
Microsoft.analysisservices.core.dll 14.0.226.1 1381544 27-Jul-18 16:30 x86
Microsoft.analysisservices.xmla.dll 14.0.226.1 742960 27-Jul-18 16:30 x86
Microsoft.analysisservices.xmla.dll 14.0.226.1 744424 27-Jul-18 1,658 x86
Microsoft.sqlserver.edition.dll 14.0.3037.1 38472 27-Jul-18 16:57 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3037.1 79904 27-Jul-18 16:36 x86
Microsoft.sqlserver.mgdsqldumper.v4x.dll 2017.140.3037.1 83488 27-Jul-18 16:36 x64
Msasxpress.dll 2017.140.226.1 33328 27-Jul-18 16:30 x86
Msasxpress.dll 2017.140.226.1 37424 27-Jul-18 1,658 x64
Pbsvcacctsync.dll 2017.140.3037.1 69664 27-Jul-18 16:57 x86
Pbsvcacctsync.dll 2017.140.3037.1 84040 27-Jul-18 1,658 x64
Sql_common_core_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
sqldumper.exe 2017.140.3037.1 142920 27-Jul-18 1,654 x64
sqldumper.exe 2017.140.3037.1 120904 27-Jul-18 16:56 x86
Sqlftacct.dll 2017.140.3037.1 56904 27-Jul-18 16:57 x86
Sqlftacct.dll 2017.140.3037.1 64072 27-Jul-18 1,658 x64
Sqlmanager.dll 2017.140.17218.0 734952 10-May-18 01:38 x64
Sqlmanager.dll 2017.140.17218.0 602848 10-May-18 01:39 x86
Sqlmgmprovider.dll 2017.140.3037.1 372880 27-Jul-18 16:57 x86
Sqlmgmprovider.dll 2017.140.3037.1 417824 27-Jul-18 1,658 x64
Sqlsecacctchg.dll 2017.140.3037.1 34,960 27-Jul-18 16:57 x86
Sqlsecacctchg.dll 2017.140.3037.1 38,984 27-Jul-18 1,658 x64
Sqlsvcsync.dll 2017.140.3037.1 273576 27-Jul-18 16:36 x86
Sqlsvcsync.dll 2017.140.3037.1 357448 27-Jul-18 16:36 x64
Sqltdiagn.dll 2017.140.3037.1 60,560 27-Jul-18 16:30 x86
Sqltdiagn.dll 2017.140.3037.1 67736 27-Jul-18 16:31 x64
Svrenumapi140.dll 2017.140.3037.1 1175112 27-Jul-18 16:36 x64
Svrenumapi140.dll 2017.140.3037.1 896976 27-Jul-18 16:57 x86

SQL Server 2017 sql_dreplay_client

File name 檔案版本 檔案大小 Date Time 平台
Dreplayclient.exe 2017.140.3037.1 120976 27-Jul-18 16:57 x86
Dreplaycommon.dll 2017.140.3037.1 701904 27-Jul-18 16:57 x86
Dreplayserverps.dll 2017.140.3037.1 34336 27-Jul-18 16:36 x86
Dreplayutil.dll 2017.140.3037.1 312784 27-Jul-18 16:57 x86
Instapi140.dll 2017.140.3037.1 72224 27-Jul-18 16:36 x64
Sql_dreplay_client_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlresourceloader.dll 2017.140.3037.1 30752 27-Jul-18 16:36 x86

SQL Server 2017 sql_dreplay_controller

File name 檔案版本 檔案大小 Date Time 平台
Dreplaycommon.dll 2017.140.3037.1 701904 27-Jul-18 16:57 x86
Dreplaycontroller.exe 2017.140.3037.1 351776 27-Jul-18 16:57 x86
Dreplayprocess.dll 2017.140.3037.1 173088 27-Jul-18 16:57 x86
Dreplayserverps.dll 2017.140.3037.1 34336 27-Jul-18 16:36 x86
Instapi140.dll 2017.140.3037.1 72224 27-Jul-18 16:36 x64
Sql_dreplay_controller_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlresourceloader.dll 2017.140.3037.1 30752 27-Jul-18 16:36 x86

SQL Server 2017 Database Services 核心實例

File name 檔案版本 檔案大小 Date Time 平台
Batchparser.dll 2017.140.3037.1 182304 27-Jul-18 16:30 x64
C1.dll 18.10.40116.18 909312 09-May-18 22:59 x64
C2.dll 18.10.40116.18 5325312 09-May-18 22:59 x64
Cl.exe 18.10.40116.18 176128 09-May-18 22:59 x64
Databasemailprotocols.dll 14.0.17178.0 48352 10-May-18 01:46 x86
Datacollectorcontroller.dll 2017.140.3037.1 227872 27-Jul-18 1,658 x64
Dcexec.exe 2017.140.3037.1 75808 27-Jul-18 1,658 x64
Fssres.dll 2017.140.3037.1 92624 27-Jul-18 1,658 x64
Hadrres.dll 2017.140.3037.1 189512 27-Jul-18 1,658 x64
Hkcompile.dll 2017.140.3037.1 1422992 27-Jul-18 1,658 x64
Hkengine.dll 2017.140.3037.1 5859912 27-Jul-18 1,658 x64
Hkruntime.dll 2017.140.3037.1 162960 27-Jul-18 1,708 x64
Link.exe 12.10.40116.18 1001472 09-May-18 22:59 x64
Microsoft.analysisservices.applocal.xmla.dll 14.0.226.1 742488 27-Jul-18 1,658 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 1,654 x86
Microsoft.sqlautoadmin.autobackupagent.dll 14.0.3037.1 237208 27-Jul-18 1,708 x86
Microsoft.sqlautoadmin.sqlautoadmin.dll 14.0.3037.1 80928 27-Jul-18 16:57 x86
Microsoft.sqlserver.vdiinterface.dll 2017.140.3037.1 71312 27-Jul-18 16:36 x64
Microsoft.sqlserver.xe.core.dll 2017.140.3037.1 66,632 27-Jul-18 16:35 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 153672 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 160840 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.linq.dll 2017.140.3037.1 306640 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.targets.dll 2017.140.3037.1 76360 27-Jul-18 1,654 x64
Msobj120.dll 12.10.40116.18 113664 09-May-18 22:59 x64
Mspdb120.dll 12.10.40116.18 543232 09-May-18 22:59 x64
Mspdbcore.dll 12.10.40116.18 543232 09-May-18 22:59 x64
Msvcp120.dll 12.10.40116.18 645120 09-May-18 22:59 x64
Msvcr120.dll 12.10.40116.18 948736 09-May-18 22:59 x64
Odsole70.dll 2017.140.3037.1 92816 27-Jul-18 1,658 x64
Opends60.dll 2017.140.3037.1 34336 27-Jul-18 16:36 x64
Qds.dll 2017.140.3037.1 1169984 27-Jul-18 19:50 x64
Rsfxft.dll 2017.140.3037.1 34448 27-Jul-18 16:36 x64
Secforwarder.dll 2017.140.3037.1 40400 27-Jul-18 16:55 x64
Sqagtres.dll 2017.140.3037.1 75808 27-Jul-18 1,658 x64
Sql_engine_core_inst_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlaamss.dll 2017.140.3037.1 91712 27-Jul-18 1,708 x64
Sqlaccess.dll 2017.140.3037.1 476192 27-Jul-18 1,658 x64
Sqlagent.exe 2017.140.3037.1 583712 27-Jul-18 1,658 x64
Sqlagentctr140.dll 2017.140.3037.1 62096 27-Jul-18 16:56 x64
Sqlagentctr140.dll 2017.140.3037.1 52,880 27-Jul-18 16:57 x86
Sqlagentlog.dll 2017.140.3037.1 32920 27-Jul-18 16:31 x64
Sqlagentmail.dll 2017.140.3037.1 55328 27-Jul-18 16:36 x64
Sqlboot.dll 2017.140.3037.1 199120 27-Jul-18 16:36 x64
Sqlceip.exe 14.0.3037.1 255632 27-Jul-18 1,658 x86
Sqlcmdss.dll 2017.140.3037.1 74312 27-Jul-18 1,658 x64
Sqlctr140.dll 2017.140.3037.1 113736 27-Jul-18 16:57 x86
Sqlctr140.dll 2017.140.3037.1 130632 27-Jul-18 1,658 x64
Sqldk.dll 2017.140.3037.1 2796176 27-Jul-18 19:50 x64
Sqldtsss.dll 2017.140.3037.1 109088 27-Jul-18 17:15 x64
Sqlevn70.rll 2017.140.3037.1 2037832 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3678280 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3298376 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3403848 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3788360 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3589704 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3638736 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3341264 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3368520 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3786784 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3782096 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 1499208 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 3823568 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 1446472 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 2092496 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 3482656 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 3918920 27-Jul-18 16:57 x64
Sqlevn70.rll 2017.140.3037.1 3214880 27-Jul-18 16:57 x64
Sqlevn70.rll 2017.140.3037.1 3597896 27-Jul-18 1,658 x64
Sqlevn70.rll 2017.140.3037.1 3915848 27-Jul-18 1,658 x64
Sqlevn70.rll 2017.140.3037.1 4027976 27-Jul-18 1,658 x64
Sqlevn70.rll 2017.140.3037.1 3292704 27-Jul-18 1,658 x64
Sqliosim.com 2017.140.3037.1 314912 27-Jul-18 16:55 x64
Sqliosim.exe 2017.140.3037.1 3019920 27-Jul-18 1,658 x64
Sqllang.dll 2017.140.3037.1 41240720 27-Jul-18 19:59 x64
Sqlmin.dll 2017.140.3037.1 40454288 27-Jul-18 19:59 x64
Sqlolapss.dll 2017.140.3037.1 109128 27-Jul-18 1,658 x64
Sqlos.dll 2017.140.3037.1 26,256 27-Jul-18 16:57 x64
Sqlpowershellss.dll 2017.140.3037.1 69728 27-Jul-18 1,658 x64
Sqlrepss.dll 2017.140.3037.1 64664 27-Jul-18 1,658 x64
Sqlresld.dll 2017.140.3037.1 30864 27-Jul-18 16:36 x64
Sqlresourceloader.dll 2017.140.3037.1 33,824 27-Jul-18 16:36 x64
Sqlscm.dll 2017.140.3037.1 72736 27-Jul-18 16:36 x64
Sqlscriptdowngrade.dll 2017.140.3037.1 27,792 27-Jul-18 16:36 x64
Sqlscriptupgrade.dll 2017.140.3037.1 5874208 27-Jul-18 16:36 x64
Sqlserverspatial140.dll 2017.140.3037.1 732816 27-Jul-18 1,658 x64
Sqlservr.exe 2017.140.3037.1 487568 27-Jul-18 19:50 x64
Sqlsvc.dll 2017.140.3037.1 163400 27-Jul-18 1,658 x64
Sqltses.dll 2017.140.3037.1 9562768 27-Jul-18 19:50 x64
Sqsrvres.dll 2017.140.3037.1 262688 27-Jul-18 1,658 x64
Svl.dll 2017.140.3037.1 153744 27-Jul-18 1,708 x64
Xe.dll 2017.140.3037.1 674888 27-Jul-18 1,654 x64
xmlrw.dll 2017.140.3037.1 305296 27-Jul-18 16:36 x64
xmlrwbin.dll 2017.140.3037.1 225864 27-Jul-18 1,658 x64
Xpadsi.exe 2017.140.3037.1 91232 27-Jul-18 1,658 x64
Xplog70.dll 2017.140.3037.1 77384 27-Jul-18 1,708 x64
Xpqueue.dll 2017.140.3037.1 76360 27-Jul-18 16:36 x64
Xprepl.dll 2017.140.3037.1 103496 27-Jul-18 16:36 x64
Xpsqlbot.dll 2017.140.3037.1 32408 27-Jul-18 16:36 x64
Xpstar.dll 2017.140.3037.1 438416 27-Jul-18 1,658 x64

SQL Server 2017 Database Services Core 共用

File name 檔案版本 檔案大小 Date Time 平台
Batchparser.dll 2017.140.3037.1 182304 27-Jul-18 16:30 x64
Batchparser.dll 2017.140.3037.1 161824 27-Jul-18 16:36 x86
Bcp.exe 2017.140.3037.1 121376 27-Jul-18 1,658 x64
Commanddest.dll 2017.140.3037.1 245904 27-Jul-18 1,658 x64
Datacollectorenumerators.dll 2017.140.3037.1 117832 27-Jul-18 1,658 x64
Datacollectortasks.dll 2017.140.3037.1 187544 27-Jul-18 1,658 x64
Distrib.exe 2017.140.3037.1 204872 27-Jul-18 1,658 x64
Dteparse.dll 2017.140.3037.1 113184 27-Jul-18 1,658 x64
Dteparsemgd.dll 2017.140.3037.1 90696 27-Jul-18 1,658 x64
Dtepkg.dll 2017.140.3037.1 139296 27-Jul-18 1,658 x64
Dtexec.exe 2017.140.3037.1 73872 27-Jul-18 1,658 x64
Dts.dll 2017.140.3037.1 3000352 27-Jul-18 1,658 x64
Dtscomexpreval.dll 2017.140.3037.1 475280 27-Jul-18 1,658 x64
Dtsconn.dll 2017.140.3037.1 497296 27-Jul-18 1,658 x64
Dtshost.exe 2017.140.3037.1 106056 27-Jul-18 1,658 x64
Dtslog.dll 2017.140.3037.1 123344 27-Jul-18 1,658 x64
Dtsmsg140.dll 2017.140.3037.1 546888 27-Jul-18 16:36 x64
Dtspipeline.dll 2017.140.3037.1 1266320 27-Jul-18 1,708 x64
Dtspipelineperf140.dll 2017.140.3037.1 49736 27-Jul-18 1,658 x64
Dtuparse.dll 2017.140.3037.1 89240 27-Jul-18 1,658 x64
Dtutil.exe 2017.140.3037.1 149968 27-Jul-18 1,658 x64
Exceldest.dll 2017.140.3037.1 260752 27-Jul-18 1,658 x64
Excelsrc.dll 2017.140.3037.1 282768 27-Jul-18 1,658 x64
Execpackagetask.dll 2017.140.3037.1 169544 27-Jul-18 1,658 x64
Flatfiledest.dll 2017.140.3037.1 388168 27-Jul-18 1,658 x64
Flatfilesrc.dll 2017.140.3037.1 400456 27-Jul-18 1,658 x64
Foreachfileenumerator.dll 2017.140.3037.1 96408 27-Jul-18 1,658 x64
Hkengperfctrs.dll 2017.140.3037.1 59536 27-Jul-18 1,658 x64
Logread.exe 2017.140.3037.1 635032 27-Jul-18 1,658 x64
Mergetxt.dll 2017.140.3037.1 65056 27-Jul-18 16:36 x64
Microsoft.analysisservices.applocal.core.dll 14.0.226.1 1381536 27-Jul-18 1,658 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 02-May-18 00:56 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3037.1 91168 27-Jul-18 1,658 x86
Microsoft.sqlserver.manageddts.dll 14.0.3037.1 615496 27-Jul-18 1,658 x86
Microsoft.sqlserver.replication.dll 2017.140.3037.1 1665056 27-Jul-18 1,658 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 153672 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 160840 27-Jul-18 1,654 x64
Msdtssrvrutil.dll 2017.140.3037.1 103568 27-Jul-18 1,658 x64
Msgprox.dll 2017.140.3037.1 271904 27-Jul-18 1,658 x64
Msxmlsql.dll 2017.140.3037.1 1448080 27-Jul-18 1,658 x64
Oledbdest.dll 2017.140.3037.1 262728 27-Jul-18 1,658 x64
Oledbsrc.dll 2017.140.3037.1 290376 27-Jul-18 1,658 x64
Osql.exe 2017.140.3037.1 76832 27-Jul-18 16:36 x64
Qrdrsvc.exe 2017.140.3037.1 473752 27-Jul-18 1,658 x64
Rawdest.dll 2017.140.3037.1 207944 27-Jul-18 1,658 x64
Rawsource.dll 2017.140.3037.1 195656 27-Jul-18 1,658 x64
Rdistcom.dll 2017.140.3037.1 860112 27-Jul-18 1,658 x64
Recordsetdest.dll 2017.140.3037.1 187344 27-Jul-18 1,658 x64
Replagnt.dll 2017.140.3037.1 32288 27-Jul-18 1,658 x64
Repldp.dll 2017.140.3037.1 292448 27-Jul-18 1,658 x64
Replerrx.dll 2017.140.3037.1 155720 27-Jul-18 1,658 x64
Replisapi.dll 2017.140.3037.1 363616 27-Jul-18 1,658 x64
Replmerg.exe 2017.140.3037.1 526432 27-Jul-18 1,658 x64
Replprov.dll 2017.140.3037.1 804816 27-Jul-18 1,658 x64
Replrec.dll 2017.140.3037.1 976928 27-Jul-18 1,658 x64
Replsub.dll 2017.140.3037.1 447008 27-Jul-18 1,658 x64
Replsync.dll 2017.140.3037.1 155720 27-Jul-18 1,658 x64
Spresolv.dll 2017.140.3037.1 253472 27-Jul-18 1,658 x64
Sql_engine_core_shared_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlcmd.exe 2017.140.3037.1 250440 27-Jul-18 1,658 x64
Sqldiag.exe 2017.140.3037.1 1260496 27-Jul-18 1,658 x64
Sqldistx.dll 2017.140.3037.1 226888 27-Jul-18 16:36 x64
Sqllogship.exe 14.0.3037.1 105624 27-Jul-18 16:36 x64
Sqlmergx.dll 2017.140.3037.1 362056 27-Jul-18 1,658 x64
Sqlresld.dll 2017.140.3037.1 28,824 27-Jul-18 16:36 x86
Sqlresld.dll 2017.140.3037.1 30864 27-Jul-18 16:36 x64
Sqlresourceloader.dll 2017.140.3037.1 30752 27-Jul-18 16:36 x86
Sqlresourceloader.dll 2017.140.3037.1 33,824 27-Jul-18 16:36 x64
Sqlscm.dll 2017.140.3037.1 72736 27-Jul-18 16:36 x64
Sqlscm.dll 2017.140.3037.1 62496 27-Jul-18 16:57 x86
Sqlsvc.dll 2017.140.3037.1 136264 27-Jul-18 16:57 x86
Sqlsvc.dll 2017.140.3037.1 163400 27-Jul-18 1,658 x64
Sqltaskconnections.dll 2017.140.3037.1 184392 27-Jul-18 1,658 x64
Sqlwep140.dll 2017.140.3037.1 107040 27-Jul-18 16:36 x64
Ssdebugps.dll 2017.140.3037.1 36304 27-Jul-18 1,658 x64
Ssisoledb.dll 2017.140.3037.1 217672 27-Jul-18 1,658 x64
Ssradd.dll 2017.140.3037.1 76872 27-Jul-18 1,658 x64
Ssravg.dll 2017.140.3037.1 77384 27-Jul-18 1,658 x64
Ssrdown.dll 2017.140.3037.1 62024 27-Jul-18 1,658 x64
Ssrmax.dll 2017.140.3037.1 74824 27-Jul-18 1,658 x64
Ssrmin.dll 2017.140.3037.1 75336 27-Jul-18 1,658 x64
Ssrpub.dll 2017.140.3037.1 63048 27-Jul-18 1,658 x64
Ssrup.dll 2017.140.3037.1 62024 27-Jul-18 1,658 x64
Txagg.dll 2017.140.3037.1 365008 27-Jul-18 1,658 x64
Txbdd.dll 2017.140.3037.1 170128 27-Jul-18 1,658 x64
Txdatacollector.dll 2017.140.3037.1 362056 27-Jul-18 1,658 x64
Txdataconvert.dll 2017.140.3037.1 295888 27-Jul-18 1,658 x64
Txderived.dll 2017.140.3037.1 607184 27-Jul-18 1,658 x64
Txlookup.dll 2017.140.3037.1 528016 27-Jul-18 1,658 x64
Txmerge.dll 2017.140.3037.1 232912 27-Jul-18 1,658 x64
Txmergejoin.dll 2017.140.3037.1 277064 27-Jul-18 1,658 x64
Txmulticast.dll 2017.140.3037.1 127632 27-Jul-18 1,658 x64
Txrowcount.dll 2017.140.3037.1 127048 27-Jul-18 1,658 x64
Txsort.dll 2017.140.3037.1 256656 27-Jul-18 1,658 x64
Txsplit.dll 2017.140.3037.1 598112 27-Jul-18 1,658 x64
Txunionall.dll 2017.140.3037.1 183328 27-Jul-18 1,658 x64
Xe.dll 2017.140.3037.1 674888 27-Jul-18 1,654 x64
xmlrw.dll 2017.140.3037.1 305296 27-Jul-18 16:36 x64
Xmlsub.dll 2017.140.3037.1 262728 27-Jul-18 1,658 x64

SQL Server 2017 sql_extensibility

File name 檔案版本 檔案大小 Date Time 平台
Launchpad.exe 2017.140.3037.1 1125008 27-Jul-18 17:23 x64
Sql_extensibility_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlsatellite.dll 2017.140.3037.1 925136 27-Jul-18 17:15 x64

SQL Server 2017 全文檢索引擎

File name 檔案版本 檔案大小 Date Time 平台
Fd.dll 2017.140.3037.1 668744 27-Jul-18 1,658 x64
Fdhost.exe 2017.140.3037.1 116296 27-Jul-18 1,708 x64
Fdlauncher.exe 2017.140.3037.1 62616 27-Jul-18 16:36 x64
Sql_fulltext_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlft140ph.dll 2017.140.3037.1 71120 27-Jul-18 16:36 x64

SQL Server 2017 sql_inst_mr

File name 檔案版本 檔案大小 Date Time 平台
Imrdll.dll 14.0.3037.1 25120 27-Jul-18 16:36 x86
Sql_inst_mr_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64

SQL Server 2017 Integration Services

File name 檔案版本 檔案大小 Date Time 平台
Attunity.sqlserver.cdccontroltask.dll 5.0.0.70 75248 02-May-18 00:56 x86
Attunity.sqlserver.cdcsplit.dll 5.0.0.70 36336 02-May-18 00:56 x86
Attunity.sqlserver.cdcsrc.dll 5.0.0.70 76272 02-May-18 00:56 x86
Commanddest.dll 2017.140.3037.1 202272 27-Jul-18 16:57 x86
Commanddest.dll 2017.140.3037.1 245904 27-Jul-18 1,658 x64
Dteparse.dll 2017.140.3037.1 101920 27-Jul-18 16:57 x86
Dteparse.dll 2017.140.3037.1 113184 27-Jul-18 1,658 x64
Dteparsemgd.dll 2017.140.3037.1 85088 27-Jul-18 16:57 x86
Dteparsemgd.dll 2017.140.3037.1 90696 27-Jul-18 1,658 x64
Dtepkg.dll 2017.140.3037.1 118304 27-Jul-18 16:57 x86
Dtepkg.dll 2017.140.3037.1 139296 27-Jul-18 1,658 x64
Dtexec.exe 2017.140.3037.1 67728 27-Jul-18 16:57 x86
Dtexec.exe 2017.140.3037.1 73872 27-Jul-18 1,658 x64
Dts.dll 2017.140.3037.1 2550880 27-Jul-18 16:57 x86
Dts.dll 2017.140.3037.1 3000352 27-Jul-18 1,658 x64
Dtscomexpreval.dll 2017.140.3037.1 419400 27-Jul-18 16:57 x86
Dtscomexpreval.dll 2017.140.3037.1 475280 27-Jul-18 1,658 x64
Dtsconn.dll 2017.140.3037.1 399504 27-Jul-18 16:57 x86
Dtsconn.dll 2017.140.3037.1 497296 27-Jul-18 1,658 x64
Dtsdebughost.exe 2017.140.3037.1 96800 27-Jul-18 16:57 x86
Dtsdebughost.exe 2017.140.3037.1 114128 27-Jul-18 1,658 x64
Dtshost.exe 2017.140.3037.1 91208 27-Jul-18 16:57 x86
Dtshost.exe 2017.140.3037.1 106056 27-Jul-18 1,658 x64
Dtslog.dll 2017.140.3037.1 104520 27-Jul-18 16:57 x86
Dtslog.dll 2017.140.3037.1 123344 27-Jul-18 1,658 x64
Dtsmsg140.dll 2017.140.3037.1 546888 27-Jul-18 16:36 x64
Dtsmsg140.dll 2017.140.3037.1 542752 27-Jul-18 16:57 x86
Dtspipeline.dll 2017.140.3037.1 1060936 27-Jul-18 1,707 x86
Dtspipeline.dll 2017.140.3037.1 1266320 27-Jul-18 1,708 x64
Dtspipelineperf140.dll 2017.140.3037.1 44104 27-Jul-18 16:57 x86
Dtspipelineperf140.dll 2017.140.3037.1 49736 27-Jul-18 1,658 x64
Dtuparse.dll 2017.140.3037.1 81480 27-Jul-18 16:57 x86
Dtuparse.dll 2017.140.3037.1 89240 27-Jul-18 1,658 x64
Dtutil.exe 2017.140.3037.1 126096 27-Jul-18 16:57 x86
Dtutil.exe 2017.140.3037.1 149968 27-Jul-18 1,658 x64
Exceldest.dll 2017.140.3037.1 216096 27-Jul-18 16:57 x86
Exceldest.dll 2017.140.3037.1 260752 27-Jul-18 1,658 x64
Excelsrc.dll 2017.140.3037.1 231968 27-Jul-18 16:57 x86
Excelsrc.dll 2017.140.3037.1 282768 27-Jul-18 1,658 x64
Execpackagetask.dll 2017.140.3037.1 136736 27-Jul-18 16:57 x86
Execpackagetask.dll 2017.140.3037.1 169544 27-Jul-18 1,658 x64
Flatfiledest.dll 2017.140.3037.1 334368 27-Jul-18 16:57 x86
Flatfiledest.dll 2017.140.3037.1 388168 27-Jul-18 1,658 x64
Flatfilesrc.dll 2017.140.3037.1 345672 27-Jul-18 16:57 x86
Flatfilesrc.dll 2017.140.3037.1 400456 27-Jul-18 1,658 x64
Foreachfileenumerator.dll 2017.140.3037.1 81992 27-Jul-18 16:57 x86
Foreachfileenumerator.dll 2017.140.3037.1 96408 27-Jul-18 1,658 x64
Isdeploymentwizard.exe 14.0.3037.1 467088 27-Jul-18 17:23 x86
Isdeploymentwizard.exe 14.0.3037.1 466576 27-Jul-18 17:23 x64
Isserverexec.exe 14.0.3037.1 150624 27-Jul-18 16:57 x86
Isserverexec.exe 14.0.3037.1 148624 27-Jul-18 1,658 x64
Microsoft.analysisservices.applocal.core.dll 14.0.226.1 1382960 27-Jul-18 16:30 x86
Microsoft.analysisservices.applocal.core.dll 14.0.226.1 1381536 27-Jul-18 1,658 x86
Microsoft.applicationinsights.dll 2.7.0.13435 329872 27-Jul-18 1,654 x86
Microsoft.data.datafeedclient.dll 13.1.1.0 171208 02-May-18 00:56 x86
Microsoft.sqlserver.astasks.dll 14.0.3037.1 72776 27-Jul-18 1,658 x86
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3037.1 108616 27-Jul-18 16:57 x86
Microsoft.sqlserver.bulkinserttaskconnections.dll 2017.140.3037.1 113736 27-Jul-18 1,658 x64
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3037.1 91168 27-Jul-18 16:57 x86
Microsoft.sqlserver.integrationservice.hadoopcomponents.dll 14.0.3037.1 91168 27-Jul-18 1,658 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3037.1 496200 27-Jul-18 16:36 x86
Microsoft.sqlserver.integrationservices.isserverdbupgrade.dll 14.0.3037.1 496160 27-Jul-18 16:36 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3037.1 83,600 27-Jul-18 16:57 x86
Microsoft.sqlserver.integrationservices.server.dll 14.0.3037.1 85064 27-Jul-18 1,658 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3037.1 415888 27-Jul-18 1,714 x86
Microsoft.sqlserver.integrationservices.wizard.common.dll 14.0.3037.1 415888 27-Jul-18 17:15 x86
Microsoft.sqlserver.manageddts.dll 14.0.3037.1 614032 27-Jul-18 16:57 x86
Microsoft.sqlserver.manageddts.dll 14.0.3037.1 615496 27-Jul-18 1,658 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3037.1 253984 27-Jul-18 16:57 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3037.1 254016 27-Jul-18 1,658 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 153672 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 143432 27-Jul-18 1,654 x86
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 160840 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 147016 27-Jul-18 16:56 x86
Msdtssrvr.exe 14.0.3037.1 219792 27-Jul-18 1,658 x64
Msdtssrvrutil.dll 2017.140.3037.1 91680 27-Jul-18 16:57 x86
Msdtssrvrutil.dll 2017.140.3037.1 103568 27-Jul-18 1,658 x64
Msmdpp.dll 2017.140.226.1 9194152 27-Jul-18 1,658 x64
Oledbdest.dll 2017.140.3037.1 214672 27-Jul-18 16:57 x86
Oledbdest.dll 2017.140.3037.1 262728 27-Jul-18 1,658 x64
Oledbsrc.dll 2017.140.3037.1 234528 27-Jul-18 16:57 x86
Oledbsrc.dll 2017.140.3037.1 290376 27-Jul-18 1,658 x64
Rawdest.dll 2017.140.3037.1 167968 27-Jul-18 16:57 x86
Rawdest.dll 2017.140.3037.1 207944 27-Jul-18 1,658 x64
Rawsource.dll 2017.140.3037.1 154656 27-Jul-18 16:57 x86
Rawsource.dll 2017.140.3037.1 195656 27-Jul-18 1,658 x64
Recordsetdest.dll 2017.140.3037.1 150600 27-Jul-18 16:57 x86
Recordsetdest.dll 2017.140.3037.1 187344 27-Jul-18 1,658 x64
Sql_is_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlceip.exe 14.0.3037.1 255632 27-Jul-18 1,658 x86
Sqldest.dll 2017.140.3037.1 215072 27-Jul-18 16:57 x86
Sqldest.dll 2017.140.3037.1 260752 27-Jul-18 1,658 x64
Sqltaskconnections.dll 2017.140.3037.1 156704 27-Jul-18 16:57 x86
Sqltaskconnections.dll 2017.140.3037.1 184392 27-Jul-18 1,658 x64
Ssisoledb.dll 2017.140.3037.1 176792 27-Jul-18 16:57 x86
Ssisoledb.dll 2017.140.3037.1 217672 27-Jul-18 1,658 x64
Txagg.dll 2017.140.3037.1 303648 27-Jul-18 16:57 x86
Txagg.dll 2017.140.3037.1 365008 27-Jul-18 1,658 x64
Txbdd.dll 2017.140.3037.1 137760 27-Jul-18 16:57 x86
Txbdd.dll 2017.140.3037.1 170128 27-Jul-18 1,658 x64
Txbestmatch.dll 2017.140.3037.1 494664 27-Jul-18 16:57 x86
Txbestmatch.dll 2017.140.3037.1 605328 27-Jul-18 1,658 x64
Txcache.dll 2017.140.3037.1 147488 27-Jul-18 16:57 x86
Txcache.dll 2017.140.3037.1 180368 27-Jul-18 1,658 x64
Txcharmap.dll 2017.140.3037.1 250400 27-Jul-18 16:57 x86
Txcharmap.dll 2017.140.3037.1 288328 27-Jul-18 1,658 x64
Txcopymap.dll 2017.140.3037.1 146976 27-Jul-18 16:57 x86
Txcopymap.dll 2017.140.3037.1 180368 27-Jul-18 1,658 x64
Txdataconvert.dll 2017.140.3037.1 254496 27-Jul-18 16:57 x86
Txdataconvert.dll 2017.140.3037.1 295888 27-Jul-18 1,658 x64
Txderived.dll 2017.140.3037.1 517192 27-Jul-18 16:57 x86
Txderived.dll 2017.140.3037.1 607184 27-Jul-18 1,658 x64
Txfileextractor.dll 2017.140.3037.1 162336 27-Jul-18 16:57 x86
Txfileextractor.dll 2017.140.3037.1 198800 27-Jul-18 1,658 x64
Txfileinserter.dll 2017.140.3037.1 160800 27-Jul-18 16:57 x86
Txfileinserter.dll 2017.140.3037.1 196752 27-Jul-18 1,658 x64
Txgroupdups.dll 2017.140.3037.1 232520 27-Jul-18 16:57 x86
Txgroupdups.dll 2017.140.3037.1 291912 27-Jul-18 1,658 x64
Txlineage.dll 2017.140.3037.1 111688 27-Jul-18 16:57 x86
Txlineage.dll 2017.140.3037.1 138312 27-Jul-18 1,658 x64
Txlookup.dll 2017.140.3037.1 448032 27-Jul-18 16:57 x86
Txlookup.dll 2017.140.3037.1 528016 27-Jul-18 1,658 x64
Txmerge.dll 2017.140.3037.1 178248 27-Jul-18 16:57 x86
Txmerge.dll 2017.140.3037.1 232912 27-Jul-18 1,658 x64
Txmergejoin.dll 2017.140.3037.1 223264 27-Jul-18 16:57 x86
Txmergejoin.dll 2017.140.3037.1 277064 27-Jul-18 1,658 x64
Txmulticast.dll 2017.140.3037.1 104008 27-Jul-18 16:57 x86
Txmulticast.dll 2017.140.3037.1 127632 27-Jul-18 1,658 x64
Txpivot.dll 2017.140.3037.1 181832 27-Jul-18 16:57 x86
Txpivot.dll 2017.140.3037.1 224936 27-Jul-18 1,658 x64
Txrowcount.dll 2017.140.3037.1 102984 27-Jul-18 16:57 x86
Txrowcount.dll 2017.140.3037.1 127048 27-Jul-18 1,658 x64
Txsampling.dll 2017.140.3037.1 137248 27-Jul-18 16:57 x86
Txsampling.dll 2017.140.3037.1 172688 27-Jul-18 1,658 x64
Txscd.dll 2017.140.3037.1 170128 27-Jul-18 16:57 x86
Txscd.dll 2017.140.3037.1 222304 27-Jul-18 1,658 x64
Txsort.dll 2017.140.3037.1 209440 27-Jul-18 16:57 x86
Txsort.dll 2017.140.3037.1 256656 27-Jul-18 1,658 x64
Txsplit.dll 2017.140.3037.1 510608 27-Jul-18 16:57 x86
Txsplit.dll 2017.140.3037.1 598112 27-Jul-18 1,658 x64
Txtermextraction.dll 2017.140.3037.1 8615056 27-Jul-18 16:57 x86
Txtermextraction.dll 2017.140.3037.1 8676496 27-Jul-18 1,658 x64
Txtermlookup.dll 2017.140.3037.1 4108360 27-Jul-18 16:57 x86
Txtermlookup.dll 2017.140.3037.1 4158560 27-Jul-18 1,658 x64
Txunionall.dll 2017.140.3037.1 140872 27-Jul-18 16:57 x86
Txunionall.dll 2017.140.3037.1 183328 27-Jul-18 1,658 x64
Txunpivot.dll 2017.140.3037.1 161824 27-Jul-18 16:57 x86
Txunpivot.dll 2017.140.3037.1 201288 27-Jul-18 1,658 x64
Xe.dll 2017.140.3037.1 674888 27-Jul-18 1,654 x64
Xe.dll 2017.140.3037.1 597064 27-Jul-18 16:55 x86

SQL Server 2017 sql_polybase_core_inst

File name 檔案版本 檔案大小 Date Time 平台
Dms.dll 13.0.9124.18 523944 10-May-18 04:42 x86
Dmsnative.dll 2016.130.9124.18 78504 10-May-18 04:42 x64
Dwengineservice.dll 13.0.9124.18 45,736 10-May-18 04:42 x86
Instapi140.dll 2017.140.3037.1 72224 27-Jul-18 16:36 x64
Microsoft.sqlserver.datawarehouse.backup.backupmetadata.dll 13.0.9124.18 74,928 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.catalog.dll 13.0.9124.18 213672 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.common.dll 13.0.9124.18 1799336 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.configuration.dll 13.0.9124.18 116904 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.datamovement.common.dll 13.0.9124.18 390312 10-May-18 04:41 x86
Microsoft.sqlserver.datawarehouse.datamovement.manager.dll 13.0.9124.18 196272 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagetypes.dll 13.0.9124.18 131248 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.datamovement.messagingprotocol.dll 13.0.9124.18 63144 10-May-18 04:41 x86
Microsoft.sqlserver.datawarehouse.diagnostics.dll 13.0.9124.18 55,464 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.distributor.dll 13.0.9124.18 93872 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.engine.dll 13.0.9124.18 792752 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.engine.statsstream.dll 13.0.9124.18 87720 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.eventing.dll 13.0.9124.18 78000 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.fabric.appliance.dll 13.0.9124.18 42152 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.fabric.interface.dll 13.0.9124.18 37,032 10-May-18 04:41 x86
Microsoft.sqlserver.datawarehouse.fabric.polybase.dll 13.0.9124.18 47,792 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.fabric.xdbinterface.dll 13.0.9124.18 27304 10-May-18 04:41 x86
Microsoft.sqlserver.datawarehouse.failover.dll 13.0.9124.18 32424 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.hadoop.hadoopbridge.dll 13.0.9124.18 129,704 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.loadercommon.dll 13.0.9124.18 95,400 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.loadmanager.dll 13.0.9124.18 109232 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.dll 13.0.9124.18 264360 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 105128 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 119464 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 122,536 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118952 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 129192 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 121512 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 116392 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 149680 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 103,080 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.localization.resources.dll 13.0.9124.18 118440 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.nodes.dll 13.0.9124.18 70,312 10-May-18 04:41 x86
Microsoft.sqlserver.datawarehouse.nulltransaction.dll 13.0.9124.18 28840 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.parallelizer.dll 13.0.9124.18 43,688 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.resourcemanagement.dll 13.0.9124.18 83624 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.setup.componentupgradelibrary.dll 13.0.9124.18 136872 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.dll 13.0.9124.18 2341040 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.dll 13.0.9124.18 3860136 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 110760 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123560 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 128,176 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124080 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 136872 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 124,584 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 121512 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 156328 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 108712 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sql.parser.resources.dll 13.0.9124.18 123048 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.sqldistributor.dll 13.0.9124.18 70,312 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.transactsql.scriptdom.dll 13.0.9124.18 2756264 10-May-18 04:42 x86
Microsoft.sqlserver.datawarehouse.utilities.dll 13.0.9124.18 751784 10-May-18 04:42 x86
Mpdwinterop.dll 2017.140.3037.1 408648 27-Jul-18 1,658 x64
Mpdwsvc.exe 2017.140.3037.1 7325256 27-Jul-18 17:15 x64
Pdwodbcsql11.dll 2017.140.3037.1 2263192 27-Jul-18 1,658 x64
Secforwarder.dll 2017.140.3037.1 40400 27-Jul-18 16:55 x64
Sharedmemory.dll 2016.130.9124.18 64,688 10-May-18 01:29 x64
Sqldk.dll 2017.140.3037.1 2714112 27-Jul-18 16:57 x64
sqldumper.exe 2017.140.3037.1 142920 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 1499208 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 3915848 27-Jul-18 1,658 x64
Sqlevn70.rll 2017.140.3037.1 3214880 27-Jul-18 16:57 x64
Sqlevn70.rll 2017.140.3037.1 3918920 27-Jul-18 16:57 x64
Sqlevn70.rll 2017.140.3037.1 3823568 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 2092496 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 2037832 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3589704 27-Jul-18 1,654 x64
Sqlevn70.rll 2017.140.3037.1 3597896 27-Jul-18 1,658 x64
Sqlevn70.rll 2017.140.3037.1 1446472 27-Jul-18 16:56 x64
Sqlevn70.rll 2017.140.3037.1 3786784 27-Jul-18 1,654 x64
Sqlos.dll 2017.140.3037.1 26,256 27-Jul-18 16:57 x64
Sqlsortpdw.dll 2016.130.9124.18 4348072 10-May-18 04:42 x64
Sqltses.dll 2017.140.3037.1 9717248 27-Jul-18 1,707 x64

SQL Server 2017 sql_shared_mr

File name 檔案版本 檔案大小 Date Time 平台
Smrdll.dll 14.0.3037.1 25120 27-Jul-18 16:36 x86
Sql_engine_core_shared_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64

SQL Server 2017 sql_tools_extensions

File name 檔案版本 檔案大小 Date Time 平台
Autoadmin.dll 2017.140.3037.1 1450056 27-Jul-18 16:57 x86
Dtaengine.exe 2017.140.3037.1 205896 27-Jul-18 1,707 x86
Dteparse.dll 2017.140.3037.1 101920 27-Jul-18 16:57 x86
Dteparse.dll 2017.140.3037.1 113184 27-Jul-18 1,658 x64
Dteparsemgd.dll 2017.140.3037.1 85088 27-Jul-18 16:57 x86
Dteparsemgd.dll 2017.140.3037.1 90696 27-Jul-18 1,658 x64
Dtepkg.dll 2017.140.3037.1 118304 27-Jul-18 16:57 x86
Dtepkg.dll 2017.140.3037.1 139296 27-Jul-18 1,658 x64
Dtexec.exe 2017.140.3037.1 67728 27-Jul-18 16:57 x86
Dtexec.exe 2017.140.3037.1 73872 27-Jul-18 1,658 x64
Dts.dll 2017.140.3037.1 2550880 27-Jul-18 16:57 x86
Dts.dll 2017.140.3037.1 3000352 27-Jul-18 1,658 x64
Dtscomexpreval.dll 2017.140.3037.1 419400 27-Jul-18 16:57 x86
Dtscomexpreval.dll 2017.140.3037.1 475280 27-Jul-18 1,658 x64
Dtsconn.dll 2017.140.3037.1 399504 27-Jul-18 16:57 x86
Dtsconn.dll 2017.140.3037.1 497296 27-Jul-18 1,658 x64
Dtshost.exe 2017.140.3037.1 91208 27-Jul-18 16:57 x86
Dtshost.exe 2017.140.3037.1 106056 27-Jul-18 1,658 x64
Dtslog.dll 2017.140.3037.1 104520 27-Jul-18 16:57 x86
Dtslog.dll 2017.140.3037.1 123344 27-Jul-18 1,658 x64
Dtsmsg140.dll 2017.140.3037.1 546888 27-Jul-18 16:36 x64
Dtsmsg140.dll 2017.140.3037.1 542752 27-Jul-18 16:57 x86
Dtspipeline.dll 2017.140.3037.1 1060936 27-Jul-18 1,707 x86
Dtspipeline.dll 2017.140.3037.1 1266320 27-Jul-18 1,708 x64
Dtspipelineperf140.dll 2017.140.3037.1 44104 27-Jul-18 16:57 x86
Dtspipelineperf140.dll 2017.140.3037.1 49736 27-Jul-18 1,658 x64
Dtuparse.dll 2017.140.3037.1 81480 27-Jul-18 16:57 x86
Dtuparse.dll 2017.140.3037.1 89240 27-Jul-18 1,658 x64
Dtutil.exe 2017.140.3037.1 126096 27-Jul-18 16:57 x86
Dtutil.exe 2017.140.3037.1 149968 27-Jul-18 1,658 x64
Exceldest.dll 2017.140.3037.1 216096 27-Jul-18 16:57 x86
Exceldest.dll 2017.140.3037.1 260752 27-Jul-18 1,658 x64
Excelsrc.dll 2017.140.3037.1 231968 27-Jul-18 16:57 x86
Excelsrc.dll 2017.140.3037.1 282768 27-Jul-18 1,658 x64
Flatfiledest.dll 2017.140.3037.1 334368 27-Jul-18 16:57 x86
Flatfiledest.dll 2017.140.3037.1 388168 27-Jul-18 1,658 x64
Flatfilesrc.dll 2017.140.3037.1 345672 27-Jul-18 16:57 x86
Flatfilesrc.dll 2017.140.3037.1 400456 27-Jul-18 1,658 x64
Foreachfileenumerator.dll 2017.140.3037.1 81992 27-Jul-18 16:57 x86
Foreachfileenumerator.dll 2017.140.3037.1 96408 27-Jul-18 1,658 x64
Microsoft.sqlserver.astasks.dll 14.0.3037.1 71312 27-Jul-18 16:57 x86
Microsoft.sqlserver.astasksui.dll 14.0.3037.1 185920 27-Jul-18 17:23 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3037.1 408136 27-Jul-18 16:57 x86
Microsoft.sqlserver.chainer.infrastructure.dll 14.0.3037.1 408136 27-Jul-18 1,658 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3037.1 2093200 27-Jul-18 16:57 x86
Microsoft.sqlserver.configuration.sco.dll 14.0.3037.1 2093200 27-Jul-18 1,658 x86
Microsoft.sqlserver.manageddts.dll 14.0.3037.1 614032 27-Jul-18 16:57 x86
Microsoft.sqlserver.manageddts.dll 14.0.3037.1 615496 27-Jul-18 1,658 x86
Microsoft.sqlserver.management.integrationservices.dll 14.0.3037.1 253984 27-Jul-18 16:57 x86
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 153672 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.configuration.dll 2017.140.3037.1 143432 27-Jul-18 1,654 x86
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 160840 27-Jul-18 1,654 x64
Microsoft.sqlserver.xevent.dll 2017.140.3037.1 147016 27-Jul-18 16:56 x86
Msdtssrvrutil.dll 2017.140.3037.1 91680 27-Jul-18 16:57 x86
Msdtssrvrutil.dll 2017.140.3037.1 103568 27-Jul-18 1,658 x64
msmgdsrv.dll 2017.140.226.1 7310504 27-Jul-18 16:30 x86
Oledbdest.dll 2017.140.3037.1 214672 27-Jul-18 16:57 x86
Oledbdest.dll 2017.140.3037.1 262728 27-Jul-18 1,658 x64
Oledbsrc.dll 2017.140.3037.1 234528 27-Jul-18 16:57 x86
Oledbsrc.dll 2017.140.3037.1 290376 27-Jul-18 1,658 x64
Sql_tools_extensions_keyfile.dll 2017.140.3037.1 101960 27-Jul-18 1,658 x64
Sqlresld.dll 2017.140.3037.1 28,824 27-Jul-18 16:36 x86
Sqlresld.dll 2017.140.3037.1 30864 27-Jul-18 16:36 x64
Sqlresourceloader.dll 2017.140.3037.1 30752 27-Jul-18 16:36 x86
Sqlresourceloader.dll 2017.140.3037.1 33,824 27-Jul-18 16:36 x64
Sqlscm.dll 2017.140.3037.1 72736 27-Jul-18 16:36 x64
Sqlscm.dll 2017.140.3037.1 62496 27-Jul-18 16:57 x86
Sqlsvc.dll 2017.140.3037.1 136264 27-Jul-18 16:57 x86
Sqlsvc.dll 2017.140.3037.1 163400 27-Jul-18 1,658 x64
Sqltaskconnections.dll 2017.140.3037.1 156704 27-Jul-18 16:57 x86
Sqltaskconnections.dll 2017.140.3037.1 184392 27-Jul-18 1,658 x64
Txdataconvert.dll 2017.140.3037.1 254496 27-Jul-18 16:57 x86
Txdataconvert.dll 2017.140.3037.1 295888 27-Jul-18 1,658 x64
Xe.dll 2017.140.3037.1 674888 27-Jul-18 1,654 x64
Xe.dll 2017.140.3037.1 597064 27-Jul-18 16:55 x86
xmlrw.dll 2017.140.3037.1 305296 27-Jul-18 16:36 x64
xmlrw.dll 2017.140.3037.1 259144 27-Jul-18 16:57 x86
xmlrwbin.dll 2017.140.3037.1 191072 27-Jul-18 16:36 x86
xmlrwbin.dll 2017.140.3037.1 225864 27-Jul-18 1,658 x64

此更新的注意事項

先決條件

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

重新啟動資訊

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

登錄資訊

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

重要注意事項

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

  • Pacemaker:使用最新可用 Pacemaker 版本的發行版中會進行行為變更。 提供緩和方法。

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

Analysis Services CU 組建版本

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

累積更新 (CU)

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

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

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

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

重要

所有使用最新可用 Pacemaker 套件 1.1.18-11.el7 的散發套件(包括 RHEL 7.3 和 7.4),如果叢集設定值為 false,則會引入行為變更start-failure-is-fatal。 此變更會影響容錯移轉工作流程。 如果主要複本發生中斷,則叢集應該要容錯移轉至其中一個可用的次要複本。 但是,使用者卻發現叢集繼續嘗試啟動失敗的主要複本。 如果該主要複本永遠無法上線 (因為永久中斷),則叢集永遠不會容錯移轉至其他可用的次要複本。

不論 SQL Server 版本的累積更新版本為何,此問題都會影響所有 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 # In the text editor, add 'meta failure-timeout=60s' after any 'param's and before any 'op's

    注意

    在此程式代碼中,請適當地取代 Xmin> 的值<。 如果複本中斷,叢集會嘗試以 failure-timeout 值和 cluster-recheck-interval 值所繫結的間隔重新啟動複本。 例如,如果 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 (CU2) 更新至 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
混合式環境部署

當您將更新部署至混合式環境時(例如 AlwaysOn、複寫、叢集和鏡像),建議您在部署更新之前參考下列文章:

語言支援

SQL Server SU 目前多語系。 因此,此 CU 套件並非專屬於一種語言。 它適用於所有支持的語言。

元件(功能) 已更新

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

此更新的支援

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

如何卸載此更新

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

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

協力廠商資訊免責聲明

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

參考資料