I have SQL 2005 Express installed. When I try to apply service pack 1 to this by going through the upgrade process, I get an error ' THe installer has encountered an unexpected error. The error code is 2259. Table(s) update failed'
Any ideas Help!
Ranjit Charles

Error Code 2259 applying SQL2005 service pack
ashok_gupta121
Sam,
I was using the full SP1 installer. I couldn't really find the SP1 refresh ..
Ranjit
Ron_S_MWA
Ranjit, are you trying to run the Express SP1 refresh package or the full SP1 installer
Thanks,
Sam Lester (MSFT)
Alejandro Mezcua
Ah, OK. That should be the issue. If you go to the SP1 page at http://www.microsoft.com/downloads/details.aspx FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en
It has a link midway down the page for the Express upgrades. Here's a snippet...
Overview
Note: To upgrade SQL Server 2005 Express Edition, obtain the SP1 version of Express Edition or Express Edition with Advanced Services.
Thanks,
Samuel Lester (MSFT)