Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SP 4.0 setup

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-06-25 : 08:18:17
Rajesh writes "Previously SP3 was installed on SQL Server 7.0 and the security checker provided by Microsoft (hotfixchecker) used to identify as such. After applying SP4 on the SQL Server 7.0 the service pack gets installed but now the hot fix checker gives the message - SQL Server 7.0 Gold
The latest SP for this product is not installed. Currently SQL Server Gold is installed. The latest service pack is SQL Server 7.0 SP4.

In Query Analyzer - Select @@version gives the following output -
Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
Apr 9 2002 14:18:16
Copyright (c) 1988-2002 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

I have even tried to reinstall the SP4, and the Server instantly recognizes that the SP is already installed and after getting confirmation continues to reinstall the same.

Can you tell me what the problem is ?"

SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-25 : 10:56:55
If you mean hfnetcheck then maybe it hasn't been updated for SP4 ?
All the docs mention SQL7 upto SP3 and SQL2000 upto SP1. Unfortunately we don't have any SP4 servers around to test on.

Also have you tried MBSA ? Much nicer output than a cmd prompt

Jasper Smith

Go to Top of Page

- Advertisement -