SQLServerCentral Article

SQL Server 2005 Build List

,

This is a list of the builds for SQL Server 2005. There are other build lists available here.

A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let me know (sjones @ sqlservercentral.com).

All builds are listed in reverse order, so the newest are at the top and the earliest at the bottom. You can find your build number with:

select @@Version

in a query window. This gives you the current version you are running and it should match up with one of the builds listed below.

Major Builds

RTM9.00.1399.06
SP19.00.2047
SP29.00.3042
SP39.00.4035
SP49.00.5000

Note that Service Packs include all builds below that Service Pack level. So any builds listed below Service Pack 1 are included in Service Pack 1. Those below Service Pack 2 (including Service Pack 1), are included in SP2, etc. Hotfixes may or may not include updates below them because there are two trees of code. The cumulative updates do include all hotfixes before them.

You can also download a CSV of the builds attached to this article.

BuildKb ArticleURLDescription
9.00.53242716427http://support.microsoft.com/kb/2716427

MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE: October 9, 2012

9.00.52962615425http://support.microsoft.com/kb/2615425/FIX: "Msg 7359" error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated
9.00.52952598903http://support.microsoft.com/kb/2598903FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
9.00.52942572407http://support.microsoft.com/kb/2572407/FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005
9.00.52922494123 http://support.microsoft.com/kb/2494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE
9.00.52662507769 http://support.microsoft.com/kb/2507769/ Cumulative Update 3 for SQL Server 2005 Service Pack 4
9.00.52592489409 http://support.microsoft.com/kb/2489409 Cumulative Update 2 for SQL Server 2005 Service Pack 4
9.00.5057249129http://support.microsoft.com/kb/2598903MS11-049 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
9.00.50542463332http://support.microsoft.com/kb/2464079Cumulative Update 1 for SQL Server 2005 Service Pack 4
9.00.50002463332http://support.microsoft.com/kb/2463332SQL Server 2005 Service Pack 4
0.00.43422598903http://support.microsoft.com/kb/2598903FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
9.00.4340249112http://support.microsoft.com/kb/2494112MS11-049 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2
9.00.43252507766http://support.microsoft.com/kb/2507766/Cumulative update package 15 for SQL Server 2005 Service Pack 3
9.00.43172489375http://support.microsoft.com/kb/2489375Cumulative update package 14 for SQL Server 2005 Service Pack 3
9.00.43152438344 http://support.microsoft.com/kb/2438344Cumulative update package 13 for SQL Server 2005 Service Pack 3
9.00.43112345449http://support.microsoft.com/kb/2345449Cumulative update package 12 for SQL Server 2005 Service Pack 3
9.00.43092258854http://support.microsoft.com/kb/2258854Cumulative update package 11 for SQL Server 2005 Service Pack 3
9.00.4305983329http://support.microsoft.com/kb/983329/Cumulative update package 10 for SQL Server 2005 Service Pack 3
9.00.4294980176http://support.microsoft.com/kb/980176/Cumulative update package 9 for SQL Server 2005 Service Pack 3
9.00.4290960598http://support.microsoft.com/kb/960598Post SP3 Hot fix, documented on the "All Builds" page at Microsoft for this SP. You receive error 8623 and non-yielding scheduler error intermittently when you try to clean up old expired notifications in SQL Server 2008
9.00.4285978915http://support.microsoft.com/default.aspx?scid=kb;en-us;978915Cumulative update package 8 for SQL Server 2005 Service Pack 3
9.00.4273960598http://support.microsoft.com/kb/960598Cumulative update package 7 for SQL Server 2005 Service Pack 3
9.00.4266974648http://support.microsoft.com/kb/974648/Cumulative update package 6 for SQL Server 2005 Service Pack 3
9.00.4262970894http://support.microsoft.com/kb/970894/MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009
9.00.4230972511http://support.microsoft.com/kb/972511/Cumulative update package 5 for SQL Server 2005 Service Pack 3
9.00.4226970279http://support.microsoft.com/kb/970279/Service Pack 3 Cumulative Update 4
9.00.4220967909http://support.microsoft.com/kb/967909/Service Pack 3 Cumulative Update 3
9.00.4211961930http://support.microsoft.com/kb/961930Service Pack 3 Cumulative Update 2
9.00.4207959195http://support.microsoft.com/kb/961930Service Pack 3 Cumulative Update 1
9.00.40602494113http://support.microsoft.com/kb/2494113
9.00.4053MS09-062http://www.microsoft.com/technet/security/bulletin/MS09-062.mspxVulnerabilities in GDI+ Could Allow Remote Code Execution
9.00.4035955706http://support.microsoft.com/kb/955706Service Pack 3
9.00.4028SQL Server 2005 Service Pack 3 (SP3) - CTP
9.00.3356976952http://support.microsoft.com/kb/976952/Cumulative update package 17 for SQL Server 2005 Service Pack 2
9.00.3355974647http://support.microsoft.com/kb/974647/en-usCumulative update package 16 for SQL Server 2005 Service Pack 2
9.00.3353970896http://support.microsoft.com/kb/970896MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009
9.00.3330972510http://support.microsoft.com/kb/972510/en-usCumulative update package 15 for SQL Server 2005 Service Pack 2
9.00.3328970278http://support.microsoft.com/kb/970278/en-usCumulative update package 14 for SQL Server 2005 Service Pack 2
9.00.3325967908http://support.microsoft.com/kb/967908Cumulative update package 13 for SQL Server 2005 Service Pack 2
9.00.3318967199http://support.microsoft.com/kb/967199FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider
9.00.3315962970 http://support.microsoft.com/kb/962970Cumulative update package 12 for SQL Server 2005 Service Pack 2
9.00.3310960090 http://support.microsoft.com/kb/960090MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009
9.00.3301958735http://support.microsoft.com/kb/958735Cumulative Update 11 for Service Pack 2
9.00.3295959132http://support.microsoft.com/kb/959132/FIX: Error message when you install Cumulative Update 10 or Cumulative Update 9 for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system
9.00.3294956854http://support.microsoft.com/kb/956854/Cumulative update package 10 for SQL Server 2005 Service Pack 2 as of Octboer 21, 2008
9.00.3289xxhttp://support.microsoft.com/kb/937137Hotfix now rolled into CU 10. Listed in the Post-SP2 builds
9.00.3282953752http://support.microsoft.com/kb/953752/Cumulative update package 9 for SQL Server 2005 Service Pack 2 as of August 19, 2008
9.00.3260954950http://support.microsoft.com/kb/954950/FIX: Error message when you run a distributed query in SQL Server 2005: "OLE DB provider 'SQLNCLI' for linked server '' returned message 'No transaction is active'"
9.00.3259954669http://support.microsoft.com/kb/954669/FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
9.00.3257951217http://support.microsoft.com/kb/951217/Cumulative update package 8 for SQL Server 2005 Service Pack 2 as of June 16, 2008
9.00.3239949095http://support.microsoft.com/kb/949095/Cumulative update package 7 for SQL Server 2005 Service Pack 2 available as of April 28, 2008
9.00.3232949959http://support.microsoft.com/kb/949959/Merge Replication Hotfix
9.00.3231949687http://support.microsoft.com/kb/949687/FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction"
9.00.3228946608http://support.microsoft.com/kb/946608/Cumulative Update 6 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.
9.00.3215943656http://support.microsoft.com/kb/943656/Cumulative Update 5 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.
9.00.3200941450http://support.microsoft.com/default.aspx?scid=kb;en-us;941450Cumulative Update 4 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.
9.00.3186939537http://support.microsoft.com/kb/939537Cumulative update package 3 for SQL Server 2005 Service Pack 2
9.00.3182N/AN/AOn-demand build with hotfixes: 50001298, 50001324, and 50001440
9.00.3180939942http://support.microsoft.com/kb/939942/FIX: You receive an error message when you try to access a report after you configure SQL Server 2005 Reporting Services to run under the SharePoint integrated mode
9.00.3179N/AN/AOn-demand build with hotfixes: 50001482 and 50001194
9.00.3178N/AN/AOn-demand build with hotfixes: 50001193 and 50001352
9.00.3177N/AN/AOn-demand build with hotfixes: 50001391, 50001367, 50001379, 50001408, and 50001397
9.00.3175936305http://support.microsoft.com/kb/936305Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
9.00.3171937745http://support.microsoft.com/kb/937745FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections
9.00.3169937041http://support.microsoft.com/kb/93704FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed
9.00.3166936185http://support.microsoft.com/kb/936185FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high
9.00.3162935360http://support.microsoft.com/kb/935360/(http://support.microsoft.com/kb/935360/) FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension...
9.00.3162935922http://support.microsoft.com/kb/935922/FIX: Error message when you install Microsoft Dynamics CRM 3.0: "Setup failed to validate specified Reporting Services Report Server"
9.00.3162932610http://support.microsoft.com/kb/932610/FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred...
9.00.3162935829http://support.microsoft.com/kb/935829/http://support.microsoft.com/kb/935829/
9.00.3162935830http://support.microsoft.com/kb/935830/FIX: A server may start slowly if you have SQL Server 2005 Analysis Services installed and if many objects are stored on the server
9.00.3162935832http://support.microsoft.com/kb/935832/FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services
9.00.3161935356http://support.microsoft.com/kb/935356Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available
9.00.3159934459http://support.microsoft.com/kb/934459FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context
9.00.3156934226http://support.microsoft.com/kb/934226FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server Error 14607)"
9.00.3155933549http://support.microsoft.com/kb/933549FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005
9.00.3154934106http://support.microsoft.com/kb/934106FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database
9.00.3154934109http://support.microsoft.com/kb/934109FIX: The Distribution Agent generates an access violation when you configure a transaction publication to run an additional script after the snapshot is applied
9.00.3154934188http://support.microsoft.com/kb/934188FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005
9.00.3153933564http://support.microsoft.com/kb/933564FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005
9.00.31529333097http://support.microsoft.com/kb/933097Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
9.00.31529333097http://support.microsoft.com/kb/933097Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
9.00.3080970895http://support.microsoft.com/kb/970895/MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009
9.00.3077960089http://support.microsoft.com/default.aspx/kb/960089MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009
9.00.3073954606http://support.microsoft.com/kb/954606MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
9.00.3068948109http://support.microsoft.com/kb/948109Description of the security update for SQL Server 2005 GDR: July 8, 2008
9.00.3054934458http://support.microsoft.com/kb/934458FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053
9.00.3050933508http://support.microsoft.com/kb/933508Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended
9.00.3043http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspxService Pack 2 Refresh
9.00.3042N/AService Pack 2 Original
9.00.3026929376http://support.microsoft.com/kb/929376FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load
9.00.2233937544http://support.microsoft.com/kb/937544FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database
9.00.2227934066http://support.microsoft.com/kb/934066FIX: The row of data on the publisher and the row of data on the subscriber may be inconsistent in a merge publication after synchronization has occurred in SQL Server 2005
9.00.2224932990http://support.microsoft.com/kb/932990FIX: You cannot obtain statements in the current batch in SQL Server 2005 by using the DBCC INPUTBUFFER statement, trace flag 1204, deadlock graph event class, or Activity Monitor
9.00.2221931593http://support.microsoft.com/kb/932555FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047
9.00.2219931329http://support.microsoft.com/kb/931329FIX: Error message when you run a query in Microsoft SQL Server 2005: "Msg 8624, Level 16, State 116 Internal Query Processor Error
9.00.2218931843http://support.microsoft.com/kb/931843FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped
9.00.2215931666http://support.microsoft.com/kb/931666FIX: An assertion violation may be logged after you install SQL Server 2005 or after you add more processors to a server that is running SQL Server 2005
9.00.2214930505http://support.microsoft.com/kb/930505FIX: Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: "Could not find stored procedure"
9.00.2214929240http://support.microsoft.com/kb/929240FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005
9.00.2214930775http://support.microsoft.com/kb/930775FIX: Error message when you try to retrieve rows from a cursor that uses the OPTION (RECOMPILE) query hint in SQL Server 2005
9.00.2211930284http://support.microsoft.com/kb/930284FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005
9.00.2211930283http://support.microsoft.com/kb/930283FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005
9.00.2209929278http://support.microsoft.com/kb/929278FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390
9.00.2208929404http://support.microsoft.com/kb/929404FIX: Error message when you perform a transaction log backup operation and another data backup operation in parallel in SQL Server 2005: "Error 3633"
9.00.2208929179http://support.microsoft.com/kb/929179FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005
9.00.2207928789http://support.microsoft.com/kb/928789FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue"
9.00.2207928394http://support.microsoft.com/kb/928394FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005
9.00.2207928372http://support.microsoft.com/kb/928372FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: "A severe error occurred on the current command"
9.00.2206928083http://support.microsoft.com/kb/928083FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005
9.00.2202927643http://support.microsoft.com/kb/927643FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005
9.00.2201927289http://support.microsoft.com/kb/927289FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication
9.00.2198926612http://support.microsoft.com/kb/926612FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005
9.00.2198926106http://support.microsoft.com/kb/926106FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services
9.00.2198925277http://support.microsoft.com/kb/925277FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005
9.00.2198924807http://support.microsoft.com/kb/924807FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005
9.00.2198924686http://support.microsoft.com/kb/924686FIX: The database mirroring session may remain in the synchronizing state and may stop responding when a database failover occurs in SQL Server 2005
9.00.2198926613http://support.microsoft.com/kb/926613FIX: You may receive inconsistent results when you query a table that is published in a transactional replication in SQL Server 2005
9.00.2196926024http://support.microsoft.com/kb/926024FIX: The query performance is very slow when you use a fast forward-only cursor to run a query in SQL Server 2005
9.00.2195926240http://support.microsoft.com/kb/926240FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source
9.00.2183924291http://support.microsoft.com/kb/924291FIX: Error message when you execute a user-defined function in SQL Server 2005: "Invalid length parameter passed to the SUBSTRING function"
9.00.2181923605http://support.microsoft.com/kb/923605FIX: A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors
9.00.2176922594http://support.microsoft.com/kb/922594FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered"
9.00.2175922579http://support.microsoft.com/kb/922579FIX: The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005
9.00.2175921536http://support.microsoft.com/kb/921536FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005
9.00.2175920794http://support.microsoft.com/kb/920794FIX: The size of the e-mail message is very large when you use Database Mail in SQL Server 2005 to send query results to users
9.00.2167921295http://support.microsoft.com/kb/921295FIX: You may receive an incorrect result when you try to run a Multidimensional Expressions (MDX) query by using SQL Server 2005
9.00.2167921293http://support.microsoft.com/kb/921293FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005
9.00.2164919243http://support.microsoft.com/kb/919243FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005
9.00.2164918832http://support.microsoft.com/kb/918832FIX: An inefficient or incorrect SQL query is generated when you try to use SQL Server 2005 to browse a ROLAP dimension
9.00.2153919224http://support.microsoft.com/kb/919224/en-usError message when you connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio on a computer that has a 64-bit processor
9.00.2153918222http://support.microsoft.com/kb/918222/en-usCumulative hotfix package (build 2153) for SQL Server 2005 is available
9.00.2050http://support.microsoft.com/kb/932555FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047
9.00.2047N/AService Pack 1
9.00.1561932556http://support.microsoft.com/kb/932556FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds
9.00.1558926493http://support.microsoft.com/kb/926493
FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005
9.00.1551922527http://support.microsoft.com/kb/922527FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package has been cancelled"
9.00.1545919193http://support.microsoft.com/kb/919193FIX: A forward-only cursor may be implicitly converted to a keyset cursor in SQL Server 2005
9.00.1532916046N/AKB916046 : FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005>KB916046 : FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005http://support.microsoft.com/kb/916046
9.00.1528915307http://support.microsoft.com/kb/915307FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes
9.00.1528915306http://support.microsoft.com/kb/915306FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication
9.00.1528915309http://support.microsoft.com/kb/915309FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL
9.00.1528915308http://support.microsoft.com/kb/915308FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005
9.00.1519913494http://support.microsoft.com/kb/932557FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
9.00.1406932557http://support.microsoft.com/kb/932557FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
9.00.1399N/ARTM
9.00.1314Sept 2005 CTP
9.00.1187June 2005 CTP
9.00.1116April 2005 CTP
9.00.1090March 2005 CTP
9.00.981December 2004 CTP
9.00.951October CTP (2004)
9.00.917Internal build
9.00.852Beta 2
9.00.849Internal build
9.00.844Internal build
9.00.836Express Edition Technical Preview
9.00.823IDW4 - Internal
9.00.790IDW3 - Internal
9.00.767IDW2 - Internal
9.00.747IDW - Internal build
9.00.645MS Internal
9.00.608Beta 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Again, if you find something not listed, let me know.

 

Resources

Rate

4.98 (53)

You rated this post out of 5. Change rating

Share

Share

Rate

4.98 (53)

You rated this post out of 5. Change rating