SQL Server 2005

The below table reflects the builds released for SQL Server 2005 as well as key comments that relate to the build where appropriate.

 

The current recommended Build is SP4 with MS12-060 (GDR) and MS12-070 (QFE) which gives you build 9.00.5324.

 

 

Patch Build Type* Released Comment

MS12-070

9.00.5324

QFE

2012 Oct

For use with SP4 if you are on the QFE path of patching.

MS12-070

9.00.5069

GDR

2012 Oct

For use with SP4 if you are on the GDR path of patching.

MS12-060

NA

GDR

2012 Aug

Replaces MS12-027.

Critical patch for SQL Server 2005 SP4 (not Express Edition) which updates the MSCOMCTL.OCX file to version 6.01.9834. It is not required if you only have SQL Server Management Studio Express (SSMSE) 2005 installed.

MS12-027

NA

GDR

2012 Apr

Critical patch for SQL Server 2005 SP4 (not Express Edition) which updates the MSCOMCTL.OCX file to version 6.01.9833. It is not required if you only have SQL Server Management Studio Express (SSMSE) 2005 installed.

MS11_049

9.0.5292

QFE

2011 Jun

Use with SP4.

Known issues with QFE ref: KB2543893.

MS11_049

9.0.5057

GDR

2011 Jun

Use with SP4.

Known issues with GDR ref: KB2543893.

MS11_049

9.0.4340

QFE

2011 Jun

Use with SP3.

MS11_049

9.0.4060

GDR

2011 Jun

Use with SP3.

SP4_CU3

9.00.5266

QFE

2011 Mar

Final CU for SP4 during Mainstream Support phase.

SP3_CU15 9.00.4325 QFE 2011 Mar

Final CU for SP3 during Mainstream Support phase.

SP4_CU2 9.00.5259 QFE 2011 Feb
SP3_CU14 9.00.4317 GFE 2011 Feb
SP4_CU1 9.00.5254 QFE 2010 Dec
SP4 9.00.5000 SP 2010 Dec SP does not include SP3_CU12. EOL** (SP Max 2016 Apr)
SP3_CU13 9.00.4315 QFE 2010 Dec
SP3_CU12 9.00.4311 QFE 2010 Oct
SP3_CU11 9.00.4309 QFE 2010 Aug
SP3_CU10 9.00.4305 QFE 2010 Jun
SP3_CU9 9.00.4294 QFE 2010 Apr
SP3_CU8 9.00.4285 QFE 2010 Feb
SP3_CU7 9.00.4273 QFE 2009 Dec
SP2_CU17 9.00.3356 QFE 2009 Dec
SP3_CU6 9.00.4266 QFE 2009 Oct Trace Flag 4199 was added. Known issue with CU ref: KB978145.
SP2_CU16 9.00.3355 QFE 2009 Oct Known issue with CU ref: KB975783.
SP3_CU5 9.00.4230 QFE 2009 Aug Known issue with CU ref: KB975783.
SP2_CU15 9.00.3330 QFE 2009 Aug Known issue with CU ref: KB975783.
SP3_CU4 9.00.4226 QFE 2009 Jun ‘Lock Pages in Memory’ support for Standard Edition x64 was introduced. Known issue with CU ref: KB975783.
SP2_CU14 9.00.3328 QFE 2009 Jun Known issue with CU ref: KB975783.
SP3_CU3 9.00.4220 QFE 2009 Apr Known issue with CU ref: KB975783.
SP2_CU13 9.00.3325 QFE 2009 Apr Known issue with CU ref: KB975783.
SP3_CU2 9.00.4211 QFE 2009 Feb
SP2_CU12 9.00.3315 QFE 2009 Feb Known issue with CU ref: KB975783.
SP3_CU1 9.00.4207 QFE 2008 Dec
SP2_CU11 9.00.3301 QFE 2008 Dec
SP3 9.00.4035 SP 2008 Dec SP does not include SP2_CU10/11. EOL** (SP 2012 Jan)
SP2_CU10 9.00.3294 QFE 2008 Oct
SP2_CU9 9.00.3282 QFE 2008 Aug
MS08_040 9.00.3068 GDR 2008 Jul Known issues with GDR ref:KB941203.
MS08_040 9.00.3233 QFE 2008 Jul Known issues with QFE ref:KB941203.
SP2_CU8 9.00.3257 QFE 2008 Jun
SP2_CU7 9.00.3239 QFE 2008 Apr
SP2_CU6 9.00.3228 QFE 2008 Feb
SP2_CU5 9.00.3215 QFE 2007 Dec Known issues with QFE ref: KB948920.Allows SQL Server Management Studio to connect to an instance of SQL Server 2008 or SQL Server 2008 R2.
SP2_CU4 9.00.3200 QFE 2007 Oct
SP2_CU3 9.00.3186 QFE 2007 Aug
SP2_CU2 9.00.3175 QFE 2007 Jun
SP2_CU1 9.0.3152 QFE 2007 Mar
SP2 9.00.3042 SP 2007 Feb EOL** (SP 2010 Jan)
SP1_CU1 9.00.2153 QFE 2006 Sep
SP1 9.00.2047 SP 2006 Apr EOL** (SP 2008 Apr)
RTM 9.00.1399 2005 Nov EOL** (MS 2011 Apr, ES 2016 Apr, SP 2007 Jul)

* Build Types can be either:

SP – Service Pack (This patch is recommended to be applied if it is supported by your application and testing in a non-Production environment is successful.)

GDR – General Distribution Release (Same recommendation as a Service Pack.)

QFE – Quick Fix Engineering (This type of patch should only be applied if it contains a fix to an issue being experienced.)

** EOL – End of Life for Product

SP (Service Pack Support End Date)

MS (Mainstream Support End Date)

ES (Extended Support End Date)