Re: SP4 on SQL 7.0

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 10/16/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Tue, 15 Oct 2002 20:06:06 -0500

SP4 is a prerequisite for installing the hotfix so it should have
already been installed. If you want to verify that SP4 was installed
beforehand, I guess you could check the version of one of the DLLs
installed by SP4 but not updated by the hotfix. For example, the
product version property of ums.dll will show 7.00.1063 if SP4 was
installed. 

--
Hope this helps.
Dan Guzman
SQL Server MVP
"Joe Drobnick" <joe.drobnick@corpx.usa.net> wrote in message
news:2f4001c27457$0a1ffb00$35ef2ecf@TKMSFTNGXA11...
> Dan,
>
> Geez,I guess I should put on the dunce cap and sit in the
> corner for awhile!  Thanks for the info and sorry for the
> waste of time.
>
> I knew that 1077 was the hotfix level, but is it assumed
> that sp4 is installed if 1077 is reported?
>
> Thanks,
> Joe
>
> >-----Original Message-----
> >The service pack reported by @@version is the OS SP, not
> the SQL SP.
> >The reported SQL build number (1077) indicates the
> security hotfix is
> >installed.   See Q327068
> ><http://support.microsoft.com/default.aspx?scid=KB;EN-
> US;Q327068> for
> >details.
> >
> >
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >-----------------------
> >SQL FAQ links (courtesy  Neil Pike):
> >
> >http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> >http://www.sqlserverfaq.com
> >http://www.mssqlserver.com/faq
> >-----------------------
> >
> >"Joe Drobnick" <joe.drobnick@corpx.usa.net> wrote in
> message
> >news:299a01c2744b$c2e9d9f0$2ae2c90a@phx.gbl...
> >> Arvind,
> >>
> >> I attached the file, but I don't see any errors, and
> only
> >> exit 0 codes.  I rebooted the server again just in case
> >> something did not run on boot the last time and still
> the
> >> same result. I suspect that if we install sp4 again, we
> >> would not have any way to backout unless we restore from
> >> backup.
> >>
> >> We did NOT install sp4 via terminal service connection,
> >> which I read in the sp4 instructions on MS website. Is
> it
> >> true that sp4 should not be installed via terminal
> service
> >> connection? We have a lot of servers that run without
> >> monitor/keyboard/mouse.
> >>
> >> Result of select @@VERSION:
> >>
> >> Microsoft SQL Server  7.00 - 7.00.1077 (Intel X86)
> >> Sep  6 2002 15:10:15
> >> Copyright (c) 1988-2002 Microsoft Corporation
> >> Standard Edition on Windows NT 5.0 (Build 2195:
> >> Service Pack 3)
> >>
> >> Thanks for the help,
> >> Joe
> >>
> >> >-----Original Message-----
> >> >Joe,
> >> >The version should have updated if SP4 installed
> >> successfully.
> >> >Can you take a look at the logfile(C:\winnt\sqlsp.log)
> to
> >> see if it points
> >> >to the cause of the problem?
> >> >
> >> >--
> >> >This posting is provided "AS IS" with no warranties,
> and
> >> confers no rights.
> >> >
> >> >Arvind Krishnan
> >> >SQL Server Development Team
> >> >Microsoft Corporation
> >> >
> >> >
> >> >"Joe Drobnick" <joe.drobnick@corpx.usa.net> wrote in
> >> message
> >> >news:226c01c273b6$00da8c00$3bef2ecf@TKMSFTNGXA10...
> >> >> I installed sp4 on SQL 7.0 with no errors. When I do
> a
> >> >> select @@VERSION it still shows sp3. If I use the
> >> hfnetchk
> >> >> tool, it reports I am on SP3 and need to go to sp4.
> >> >>
> >> >> I did also do the hotfix to bring the version up to
> >> >> 7.00.1077.
> >> >>
> >> >> Any ideas why sp4 does not show up?
> >> >>
> >> >> Thanks,
> >> >> Joe
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SP4 on SQL 7.0
    ... the SQL SP. ... I suspect that if we install sp4 again, ... >>>SQL Server Development Team ...
    (microsoft.public.sqlserver.security)
  • Re: Reinstalling MSDE 2000 fails (MDAC?)
    ... can I patch setup for using this new hotfix? ... > if named then ..\Program Files\Microsoft SQL Server\MSSQL$InstanceName ... > delete this folder ... > Since you tried to reinstall, you will also find the attempt to install in ...
    (microsoft.public.sqlserver.setup)
  • Re: Conflicting info between the global Security Bulletin and some SPi Security Bulletin
    ... According the Security Bulletin for the release of SP4, ... you will see that the updated patch was first included in SP3 ... and they install SP 4 when it come out. ... Then they elect to upgrade to WMP 7.1, but they use a download of the ...
    (microsoft.public.win2000.security)
  • Re: MS03-31 install issue
    ... Just want to make sure it is the hotfix for SQL2K. ... Columnist, SQL Server Professional ... >Install SP3 for SQL Server 2000 first before applying the hotfix. ... >The installer exits with the "no instance on this machine>qualifies" error. ...
    (microsoft.public.sqlserver.security)
Loading