SQL Server 2000 Build Numbers and Version History

SQL Server 2000 reports an 8.0 engine version, commonly written as 8.00. Its history includes service packs and post-SP4 fixes for which a Microsoft reference survives.

SQL Server 2000 RTM, SP4 and version prefix

Version prefix
8.0
Original release (RTM)
8.0.194
Final service pack (SP4)
8.0.2039

This release is out of regular support.

Microsoft engine history checked .

Read SQL Server 2000 SP4 and post-SP4 builds

Build 8.0.2039 identifies the SP4 baseline. A later 8.0 build can come from a post-SP4 security update or hotfix. Match the full build and KB instead of recording every SP4-era server as 8.0.2039. Use @@VERSION for old inventories that include SQL Server 7.0 as well.

Run SELECT SERVERPROPERTY('ProductVersion'); to get the full engine build. SQL Server version queries

SQL Server 2000 build history and KB articles

Find the exact build or KB in the table. Use the release date and update label to confirm the match. A dash means the source did not provide that field.

Windows builds

Original release
BuildUpdateFile versionKB articlesRelease date
8.0.1948.00.194SQL Server 2000 RTM or MSDE 2.0———
GDR
BuildUpdateFile versionKB articlesRelease date
8.0.2065SP4 · GDR2000.80.2065.0KB983808 (archive)
8.0.2050GDR2000.80.2050.0KB948110 (archive)
Service pack
BuildUpdateFile versionKB articlesRelease date
8.0.20408.00.2040Post-SP4 AWE fix (899761)—KB899761—
8.0.20398.00.2039SQL Server 2000 SP4———
8.0.8188.00.818821277 MS03-031: Security patch for SQL Server 2000 Service Pack 32000.80.818.0KB821277 (archive)KB821280 (archive)KB821337 (archive)KB826161 (archive)—
8.0.7608.00.760SQL Server 2000 SP3 or SP3a (8.00.766 ssnetlib.dll)———
8.0.5348.00.534SQL Server 2000 SP2———
8.0.3848.00.384SQL Server 2000 SP1———
Hotfix
BuildUpdateFile versionKB articlesRelease date
8.0.2305SP4 · QFE security update2000.80.2305.0KB983811
8.0.2301SP4 · QFE security update2000.80.2301.0KB983809 (archive)
8.0.22838.00.2283Post-SP4 hotfix for MS09-004 (971524)—KB971524—
8.0.2279Hotfix2000.80.2279.0KB959678 (archive)—
8.0.2271Hotfix2000.80.2271.0KB946584 (archive)—
8.0.2265Hotfix2000.80.2265.0KB944985 (archive)—
8.0.2249Hotfix2000.80.2249.0KB936232 (archive)—
8.0.2248Hotfix2000.80.2248.0KB935950 (archive)—
8.0.2245Hotfix2000.80.2245.0KB933573 (archive)—
8.0.2244SP4 · Hotfix2000.80.2244.0KB934203 (archive)—
8.0.2242Hotfix2000.80.2242.0KB929131 (archive)—
8.0.2238SP4 · Hotfix2000.80.2238.0KB931932 (archive)—
8.0.2236Hotfix2000.80.2236.0KB930484 (archive)—
8.0.2234Hotfix2000.80.2234.0KB929440 (archive)—
8.0.2232Hotfix2000.80.2232.0KB928568 (archive)—
8.0.2231Hotfix2000.80.2231.0KB928079 (archive)—
8.0.2229SP4 · Hotfix2000.80.2229.0KB927186 (archive)—
8.0.2226Hotfix2000.80.2226.0KB925684 (archive)KB925732 (archive)—
8.0.2223Hotfix2000.80.2223.0KB925419 (archive)KB925678 (archive)—
8.0.2218Hotfix2000.80.2218.0KB925297 (archive)—
8.0.2217Hotfix2000.80.2217.0KB924664 (archive)—
8.0.2215Hotfix2000.80.2215.0KB923327 (archive)KB923563 (archive)KB923796 (archive)KB924662 (archive)—
8.0.2207Hotfix2000.80.2207.0KB923344 (archive)—
8.0.2201Hotfix2000.80.2201.0KB920930 (archive)—
8.0.2199Hotfix2000.80.2199.0KB919221 (archive)—
8.0.2197Hotfix2000.80.2197.0KB919068 (archive)KB919133 (archive)KB919399 (archive)—
8.0.2196Hotfix2000.80.2196.0KB919165 (archive)—
8.0.2194Hotfix2000.80.2194.0KB917565 (archive)KB917972 (archive)—
8.0.2192SP4 · Hotfix2000.80.2192.0KB917606 (archive)—
8.0.2191Hotfix2000.80.2191.0KB916698 (archive)KB916950 (archive)—
8.0.2189SP4 · Hotfix2000.80.2189.0KB913438 (archive)KB916652 (archive)—
8.0.2187Hotfix2000.80.2187.0KB914384 (archive)KB915340 (archive)—
8.0.2180Hotfix2000.80.2180.0KB913684 (archive)KB913789 (archive)—
8.0.2172Hotfix2000.80.2172.0KB910707 (archive)—
8.0.2171Hotfix2000.80.2171.0KB909369 (archive)—
8.0.2166SP4 · Hotfix2000.80.2166.0KB909734 (archive)—
8.0.2159Hotfix2000.80.2159.0KB907250 (archive)—
8.0.2156SP4 · Hotfix2000.80.2156.0KB906790 (archive)—
8.0.2151SP4 · Hotfix2000.80.2151.0KB903742 (archive)KB904244 (archive)—
8.0.2148Hotfix2000.80.2148.0KB899430 (archive)KB899431 (archive)KB900390 (archive)KB900404 (archive)KB901212 (archive)KB902150 (archive)KB902955 (archive)—
8.0.1037Hotfix2000.80.1037.0KB930484 (archive)—
8.0.1036Hotfix2000.80.1036.0KB929410 (archive)—
8.0.1035Hotfix2000.80.1035.0KB917593 (archive)—
8.0.1034Hotfix2000.80.1034.0KB915328 (archive)—
8.0.1029Hotfix2000.80.1029.0KB902852 (archive)—
8.0.1027Hotfix2000.80.1027.0KB900416 (archive)—
8.0.1025SP3 · Hotfix2000.80.1025.0KB899428 (archive)KB899430 (archive)—
8.0.1024Hotfix2000.80.1024.0KB898709 (archive)—
8.0.1021Hotfix2000.80.1021.0KB887700 (archive)—
8.0.1020SP3 · Hotfix2000.80.1020.0KB896985 (archive)—
8.0.1019Hotfix2000.80.1019.0KB897572 (archive)—
8.0.1017Hotfix2000.80.1017.0KB896425 (archive)—
8.0.1014Hotfix2000.80.1014.0KB895123 (archive)KB895187 (archive)—
8.0.1013Hotfix2000.80.1013.0KB891866 (archive)—
8.0.1009Hotfix2000.80.1009.0KB894257 (archive)—
8.0.10078.00.1007Update.exe Hotfix Installer Baseline 2 (891640)2000.80.1007.0KB891640KB893312 (archive)—
8.0.1003Hotfix2000.80.1003.0KB892923 (archive)—
8.0.1001Hotfix2000.80.1001.0KB892205 (archive)—
8.0.1000Hotfix2000.80.1000.0KB891585 (archive)—
8.0.997Hotfix2000.80.997.0KB891311 (archive)—
8.0.996Hotfix2000.80.996.0KB891017 (archive)KB891268 (archive)—
8.0.994Hotfix2000.80.994.0KB890767 (archive)KB890768 (archive)KB890942 (archive)—
8.0.993SP3 · Hotfix2000.80.993.0KB888444 (archive)KB890742 (archive)KB890925 (archive)—
8.0.990Hotfix2000.80.990.0KB890200 (archive)—
8.0.988Hotfix2000.80.988.0KB889166 (archive)—
8.0.985Hotfix2000.80.985.0KB889239 (archive)—
8.0.9778.00.977Update.exe Hotfix Installer Baseline 1 (884856)—KB884856—
8.0.973Hotfix2000.80.973.0KB884554 (archive)—
8.0.972Hotfix2000.80.972.0KB885290 (archive)—
8.0.970Hotfix2000.80.970.0KB872842 (archive)—
8.0.967Hotfix2000.80.967.0KB878501 (archive)—
8.0.955Hotfix2000.80.955.0KB867798 (archive)—
8.0.952Hotfix2000.80.952.0KB867879 (archive)—
8.0.949SP3 · Hotfix2000.80.949.0KB843266 (archive)—
8.0.948Hotfix2000.80.948.0KB843263 (archive)—
8.0.937Hotfix2000.80.937.0KB841776 (archive)—
8.0.936Hotfix2000.80.936.0KB841627 (archive)—
8.0.935Hotfix2000.80.935.0KB841401 (archive)—
8.0.934Hotfix2000.80.934.0KB841404 (archive)—
8.0.926Hotfix2000.80.926.0KB839523 (archive)—
8.0.923Hotfix2000.80.923.0KB838460 (archive)—
8.0.922Hotfix2000.80.922.0KB837970 (archive)—
8.0.919Hotfix2000.80.919.0KB837957 (archive)—
8.0.910Hotfix2000.80.910.0KB834798 (archive)—
8.0.891Hotfix2000.80.891.0KB836141 (archive)—
8.0.879Hotfix2000.80.879.0KB832977 (archive)—
8.0.876Hotfix2000.80.876.0KB831997 (archive)KB831999 (archive)—
8.0.873SP3 · Hotfix2000.80.873.0KB830887 (archive)—
8.0.871Hotfix2000.80.871.0KB830860 (archive)—
8.0.866Hotfix2000.80.866.0KB830366 (archive)—
8.0.865Hotfix2000.80.865.0KB828945 (archive)—
8.0.857Hotfix2000.80.857.0KB828308 (archive)—
8.0.852Hotfix2000.80.852.0KB830466 (archive)—
8.0.850Hotfix2000.80.850.0KB826815 (archive)—
8.0.845Hotfix2000.80.845.0KB826364 (archive)—
8.0.844Hotfix2000.80.844.0KB826080 (archive)—
8.0.837Hotfix2000.80.837.0KB820788 (archive)KB821548 (archive)—
8.0.816Hotfix2000.80.816.0KB818766 (archive)—
8.0.811Hotfix2000.80.811.0KB818897 (archive)KB819248 (archive)—
8.0.804Hotfix2000.80.804.0KB818729 (archive)—
8.0.794Hotfix2000.80.794.0KB816440 (archive)KB817709 (archive)—
8.0.769SP3 · Hotfix2000.80.769.0KB814893 (archive)—
8.0.7658.00.765Post SP3 hotfix rollup2000.80.765.0KB811611 (archive)KB813769 (archive)—
8.0.762SP3 · Hotfix—KB814032 (archive)—
8.0.743SP2 · Hotfix2000.80.743.0KB818406 (archive)KB818763 (archive)—
8.0.730Hotfix2000.80.730.0KB813769 (archive)—
8.0.715Hotfix2000.80.715.0KB811611 (archive)—
8.0.714SP2 · Hotfix2000.80.714.0KB811478 (archive)—
8.0.7018.00.701Hotfix Installer v.1 released———
8.0.552Hotfix—KB313005 (archive)—
8.0.469Hotfix—KB313005 (archive)—
8.0.443Hotfix—KB307538 (archive)—
Other build
BuildUpdateFile versionKB articlesRelease date
8.0.22828.00.2282MS09-004: KB959420 October 29, 20082000.80.2282.0KB959420KB960083 (archive)
8.0.22738.00.2273MS08-040 - KB 948111 July 08, 2008—KB948111—
8.0.2246Update2000.80.2246.0KB935465 (archive)—
8.0.2055Update2000.80.2055.0KB959420 (archive)—
8.0.929Update2000.80.929.0KB839529 (archive)—
8.0.847Update2000.80.847.0KB826433 (archive)—

Download release CSVBuild data and APIPlan a SQL Server patchFind SQL Server security updates

SQL Server 2000 release sources