service pack appears to install but doesn't 1

[deb18]

I have been struggling for days to get a service pack to install on SQL Server 2000.

In order to positively assure that I didn't have bits and pieces of various old/mismatched patches hanging around, I took the radical step of reformatting the C-drive of the server and reinstalling the OS. I installed all the patches from Windows Update. I then installed SQL Server 2000. When I installed SP2 for SQL Server 2000, it confirmed that the SP was delivered successfully ...but look what Query Analyzer has to say about how the installation of SP2 went:

[tt]
select @@version
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

select serverproperty('productlevel')
RTM[/tt]

This server has absolutely nothing on it other than what I mentioned, above. I am unable to find any help on this anywhere.

Ultimately - i.e. if and when I get this SP on - I plan on installing SQL CE 2.0, but first I need to get the SQL Server 2000 service packs in place...

Any guidance would be greatly appreciated!!!

Thanks!

 

[SQLBill]

Have you tried installing SP1 and then SP3a?

-SQLBill

 

[deb18]

Thanks, it works now!