Service packs

• Jon80

  SSCrazy

  Points: 2598

  More actions

  January 1, 2008 at 7:01 am

  #184989

  Are service packs available for the express edtion? Would these usually show up in the 'Microsoft Update' screen or do I need to download them manually?

• Kevin Brennan

  Right there with Babe

  Points: 738

  More actions

  January 2, 2008 at 9:39 am

  #764093

  Hi if you visit the following

  http://support.microsoft.com/kb/913089

  you can read all about obtaining the latest service packs for sql server 2005 (including express)

  however if you are in a hurry you can use the following links:

  To obtain SQL Server 2005 Express Edition SP2, visit the following Microsoft Web site:

  http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7 (http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7)

  OR

  To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP2, visit the following Microsoft Web site:

  http://www.microsoft.com/downloads/details.aspx?FamilyId=5b5528b9-13e1-4db9-a3fc-82116d598c3d (http://www.microsoft.com/downloads/details.aspx?FamilyId=5b5528b9-13e1-4db9-a3fc-82116d598c3d)

  Kevin Brennan M.Sc, MCDBA, MCSE,MCP+I

  CodeMinkey

• Jon80

  SSCrazy

  Points: 2598

  More actions

  January 2, 2008 at 11:40 am

  #764146

  Thank you

• rbarrera

  Mr or Mrs. 500

  Points: 575

  More actions

  January 15, 2008 at 2:42 pm

  #768348

  I'm a little confused at Microsoft's service packs concerning SQL Express. If you look at the latest cumulative update here:

  http://support.microsoft.com/kb/943656/

  It shows applicable to SQL Express. It's just a compilation of all hot fixes since SP2.

  If you look at the individual hotfixes since SP2 from this list:

  http://www.sqlservercentral.com/articles/Administration/2960/

  none of them apply to SQL Express (none that I could see).

  I'm wondering if SQL Express is left off of those hotfixes because since SQL Express is free, there's really not much support for it other than SP2. For kicks, I applied the latest non "not fully tested" update here: http://support.microsoft.com/kb/934459

  It allowed me to apply it to SQL Express. Now if it weren't applicable, wouldn't you think the service pack would detect that I was running SQL Express and stop the update process?

  Would applying any of these service packs to SQL Express cause any detrimental effects?

  Thanks from the SQL noob.