Error Code 2259 applying SQL2005 service pack

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

Ranjit, are you trying to run the Express SP1 refresh package or the full SP1 installer?

Thanks,
Sam Lester (MSFT)

|||

Sam,

I was using the full SP1 installer. I couldn't really find the SP1 refresh ..

Ranjit

|||

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

Service Pack 1 for Microsoft SQL Server 2005 is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:

Enterprise Enterprise Evaluation Developer Standard Workgroup