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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SP 4.0 setup
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 06/25/2002 :  08:18:17  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

United Kingdom
846 Posts

Posted - 06/25/2002 :  10:56:55  Show Profile  Visit jasper_smith's Homepage  Reply with Quote
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. en-us Q305385

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

Jasper Smith

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000