I have applied SP4 to a SQL Server 2000 (Standard Edition) on a Windows 2000 server seemingly without any errors or issues.
I ran the following as part of verification process which sugggests that SP4 has not been applied:
SELECT SERVERPROPERTY('ProductLevel') returns "RTM"
SELECT SERVERPROPERTY('ProductVersion') returns "8.00.194"
When I click on the "support information" link for "Microsoft SQL Server 2000" in "Add/Remove Programs" the version returned is "8.00.2039" which suggests SP4 has been applied, MDAC 2.81 is applied which comes with SP4. I have spent most of the day looking through microsoft knowledgebase and a number of forums but have found no references to this issue. has anyone experianced this??