Patch tracker / KB5040940
KB5040940: Microsoft SQL Server 2017 for x64-base Security Update (July 2024)
KB5040940 is a High security update for Microsoft SQL Server 2017 for x64-base, released 2024-07-09. It closes 37 CVEs with a maximum CVSS of 8.8. Get it from the Microsoft Update Catalog below, and see where it sits against the rest of the month on the patch tracker.
Microsoft security update released 2024-07-09. Fixes 37 CVEs.
No exploitation is confirmed for the CVEs in this update and the EPSS exploitation probability is currently 1.8%. That can change: CVEs from past updates regularly get exploited months later, which is why deploying on your normal cadence, without exceptions that linger, is what keeps this one boring.
SQL Server updates deploy per instance, usually via the downloaded package or your server patching tool rather than client update rings. The install guidance below covers the options. For the bigger picture: how the Microsoft patching tools fit together, this month's Patch Tuesday summary, and every update ranked by real-world risk.
Updated July 25, 2026. Data refreshed on every build from MSRC, CISA KEV, and FIRST EPSS.
Download KB5040940
Get the official update for KB5040940. The download and file size for each supported product are on the Microsoft Update Catalog page.
Update summary
Senserva AI Opinion for KB5040940
Database administrators on SQL Server 2016, 2017, or 2019 face 37 closed CVEs in this July update, including CVE-2024-38088 and CVE-2024-38087, topping out at Severity High, CVSS 8.8. This scale of rollup is unusual and suggests deferred patching should not continue past this cycle. Coordinate downtime carefully since a rollup this large may need a longer maintenance window than typical monthly updates.
Do this: Allocate a longer maintenance window for this large 37-CVE SQL Server update given its scope.
AI-generated from public data, 2026-07-07. Verify against the vendor advisory before acting.
Senserva AI Opinion and rich prompt for KB5040940
Copy this prompt into Claude, ChatGPT, or Copilot. The facts are included, sourced from this page.
Full tracking and change history for KB5040940
Senserva began recording day-to-day change history on 2026-07-07, and refreshes it several times a day. Release dates are historical where Microsoft publishes them; revision history is tracked from that date forward, so it does not include changes made before then.
Exploitation and severity
Fixes 37 CVEs. Most severe CVSS 8.8 (High). EPSS exploit probability up to 1.8%.
Among the lower half of tracked Microsoft updates by EPSS exploit probability.
What to do
Moderate priority: schedule it in your normal patch cycle. Senserva flags whether KB5040940 is missing on your devices.
Check if KB5040940 is installed
Copy-paste PowerShell: one machine, or your whole fleet in one pass. No output means the update is not installed.
Get-HotFix covers Windows updates. Office, SharePoint, and Exchange server updates show under installed updates in Programs and Features, or check the Update Catalog history.
Writing about KB5040940? Cite this page
Copy-paste for a blog post, forum answer, or internal doc. The link always carries the current risk data.
CVEs fixed by this update
Sorted exploited-first, then by CVSS. Every CVE links to its Senserva page with the full risk facts, references, and a ready-to-paste AI prompt.
Affected products
Also released in July 2024
The highest-risk updates from the same release:
The full month, summarized: Microsoft Patch Tuesday.
How to install KB5040940
This is a SQL Server update. It deploys per instance:
- Manual or scripted install of the package from the Update Catalog above, instance by instance, starting with test.
- Microsoft Update can offer SQL Server updates when the machine opts in to updates for other Microsoft products.
- Verify afterward by checking the instance build number against the update's target build.
Common questions about KB5040940
Is KB5040940 urgent?
KB5040940 is rated High. Include it in your normal patch cycle unless your environment raises its priority.
How do I download KB5040940?
From the Microsoft Update Catalog (linked on this page), or let Intune, Windows Update for Business, Windows Autopatch, or WSUS deliver it. The catalog page lists the download for each supported product.
How do I deploy KB5040940 with Intune?
Assign a Windows Update ring (quality update policy) to the device groups and the update flows on the ring's deferral schedule. For urgent updates, Intune expedite policies can bypass the ring deferrals. Verify the rollout with update compliance reporting rather than assuming delivery.
Can I ask my own AI about KB5040940?
Yes. This page includes a free, ready-to-paste AI prompt containing KB5040940's key facts: severity, CVE count, exploitation status, and the download link. Copy it into Claude, ChatGPT, or Copilot for a rollout plan; the data is refreshed twice a day (5 AM and 3 PM US Central).
Authoritative references
See this and every Microsoft update ranked by real-world risk on the Microsoft Patch Tracker.
