SQL Server 2005 Build Versions

By: Editor
April 20, 2009 (Updated: Mar 22, 2011)

Introduction

One of the most important job responsibilities of a Database Administrator is to make sure that SQL Servers within the organizations are applied with the latest security patches, cumulative updates and services packs which are released by Microsoft. However, it is always challenging to keep track of all the security patches, cumulative updates released by Microsoft. In this article I have compiled an exhaustive list of all the security patches, cumulative updates and service packs for SQL Server 2005 Build Versions released by Microsoft.

For information on Cumulative Updates, Security Patches,  and Services Packs of latest SQL Server Versions, follow the links given below:

Indentifying SQL Server Version

Database Administrators can determine the version of SQL Server they are running by executing the below query.

SELECT
 	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition
GO

ProductVersion ProductLevel Edition
9.00.1399 RTM Developer Edition

The Product Version 9.00.1399 represents SQL Server 2005 RTM.



SQL Server 2005 Build Versions

Build KB Description Release Date
9.00.5266 KB2507769  Cumulative Update Package 3 (CU3) for SQL Server 2005 Service Pack 4 Mar 22, 2011
9.00.5259 KB2489409  Cumulative Update Package 2 (CU2) for SQL Server 2005 Service Pack 4 Feb 22, 2011
9.00.5254 KB2464079  Cumulative Update Package 1 (CU1) for SQL Server 2005 Service Pack 4 Dec 23, 2010
9.00.5000 KB2463332  SQL Server 2005 Service Pack 4 (SP4) Dec 17, 2010
9.00.4325 KB2507766  Cumulative Update Package 15 (CU15) for SQL Server 2005 Service Pack 3 Mar 22, 2011
9.00.4317 KB2489375  Cumulative Update Package 14 (CU14) for SQL Server 2005 Service Pack 3 Feb 21, 2011
9.00.4315 KB2438344   Cumulative Update Package 13 (CU13) for SQL Server 2005 Service Pack 3 Dec 23, 2010
9.00.4311 KB2345449   Cumulative Update Package 12 (CU12) for SQL Server 2005 Service Pack 3 Oct 18, 2010
9.00.4309 KB2258854   Cumulative Update Package 11 (CU11) for SQL Server 2005 Service Pack 3 Oct 9, 2010
9.00.4305 KB983329   Cumulative Update Package 10 (CU10) for SQL Server 2005 Service Pack 3 Jun 23, 2010
9.00.4294 KB980176   Cumulative Update Package 9 (CU9) for SQL Server 2005 Service Pack 3 Apr 19, 2010
9.00.4285 KB978915   Cumulative Update Package 8 (CU8) for SQL Server 2005 Service Pack 3 Feb 16, 2010
9.00.4273 KB960598   Cumulative Update Package 7 (CU7) for SQL Server 2005 Service Pack 3 Dec 21, 2009
9.00.4266 KB974648   Cumulative Update Package 6 (CU6) for SQL Server 2005 Service Pack 3 Oct 19, 2009
9.00.4230 KB972511   Cumulative Update Package 5 (CU5) for SQL Server 2005 Service Pack 3 Aug 17, 2009
9.00.4226 KB970279   Cumulative Update Package 4 (CU4) for SQL Server 2005 Service Pack 3 Jun 16, 2009
9.00.4220 KB967909   Cumulative Update Package 3 (CU3) for SQL Server 2005 Service Pack 3 Apr 20, 2009
9.00.4211 KB961930   Cumulative Update Package 2 (CU2) for SQL Server 2005 Service Pack 3 Feb 17, 2009
9.00.4207 KB959195  Cumulative Update Package 1 (CU1) for SQL Server 2005 Service Pack 3 Dec 20, 2008
9.00.4035    SQL Server 2005 Service Pack 3 (SP3) Dec 15, 2008
9.00.3356 KB976952   Cumulative Update Package 17 (CU17) for SQL Server 2005 Service Pack 2 Dec 21, 2009
9.00.3355 KB974647   Cumulative Update Package 16 (CU16) for SQL Server 2005 Service Pack 2 Oct 19, 2009
9.00.3330 KB972510   Cumulative Update Package 15 (CU15) for SQL Server 2005 Service Pack 2 Aug 18, 2009
9.00.3328 KB970278   Cumulative Update Package 14 (CU14) for SQL Server 2005 Service Pack 2 Jun 16, 2009
9.00.3225 KB967908   Cumulative Update Package 13 (CU13) for SQL Server 2005 Service Pack 2 Apr 21, 2009
9.00.3315 KB962970  Cumulative Update Package 12 (CU12) for SQL Server 2005 Service Pack 2 Feb 17, 2009
9.00.3310 KB959420  SQL Server 2005 Security Update Feb 10, 2009
9.00.3301 KB958735  Cumulative Update package 11 (CU11) for SQL Server 2005 Service Pack 2 Dec 16, 2008
9.00.3294 KB956854   Cumulative Update package 10 (CU10) for SQL Server 2005 Service Pack 2 Oct 20, 2008
9.00.3282 KB953752   Cumulative Update package 9 (CU9) for SQL Server 2005 Service Pack 2  Jun 16, 2008
9.00.3257 KB951217   Cumulative Update package 8 (CU8) for SQL Server 2005 Service Pack 2  Jun 18, 2008
9.00.3239 KB949095   Cumulative Update package 7 (CU7) for SQL Server 2005 Service Pack 2  Apr 17, 2008
9.00.3233 KB948108   SQL Server 2005 QFE Security Update  Jul 08, 2008
9.00.3228 KB946608   Cumulative Update package 6 (CU6) for SQL Server 2005 Service Pack 2  Feb 19, 2008
9.00.3215 KB943656  Cumulative Update package 5 (CU5) for SQL Server 2005 Service Pack 2 Dec 18, 2007
9.00.3200 KB941450   Cumulative Update package 4 (CU4) for SQL Server 2005 Service Pack 2  Oct 17, 2007
9.00.3186 KB939537   Cumulative Update package 3 (CU3) for SQL Server 2005 Service Pack 2  Aug 23, 2007
9.00.3175 KB936305   Cumulative Update package 2 (CU2) for SQL Server 2005 Service Pack 2  Jun 28, 2007
9.00.3161 KB935356   Cumulative Update package (CU1) for SQL Server 2005 Service Pack 2 Apr 16, 2007
9.00.3152 KB933097   Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2  Mar 07, 2007
9.00.3042  SQL Server 2005 Service Pack 2 (SP2) Feb 19, 2007
9.00.2153 KB918222  Cumulative hotfix package (build 2153) for SQL Server 2005 Service Pack 2 Sep 14, 2006
9.00.2047     SQL Server 2005 Service Pack 1 (SP1)  Apr 18, 2006
9.00.1399    SQL Server 2005 RTM Nov 07, 2005

Using XP_MSVER System Stored Procedure

You can also execute the xp_msver inbuilt system stored procedure to know more details related to SQL Server which you are currently running within the organization.

Use master
GO
EXEC xp_msver
GO

EXEC XP_MSVER System Stored Procedure Execution Results in SQL Server 2005


Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."