I am running an old instance ot SS2005 Express.
I was on SP2 (Build 9.00.3042.00) and needed to get to the latest maintenance level (SP4).
Everything in the installation process went well. I stopped SQL Server before the upgrade
and rebooted the server after the installation. When I performed a @@Version, the Build didn't show any different (9.00.3042.00).
I noticed in something peculiar in the filestructure.
My old path of C:\Program Files\Microsoft SQL Server\MSSQL.1
was still present (no problem), but a new path of
C:\Program Files\Microsoft SQL Server\MSSQL.2 (still no problem).
But for whatever reason, when I launch SQL Server Express ...
Go to the complete details ...