Re: SP4 on SQL 7.0
From: Joe Drobnick (joe.drobnick@corpx.usa.net)
Date: 10/15/02
- Next message: Leigh Klasse: "Non-Admin Users remotely monitoring with Perfmon"
- Previous message: Dan Guzman: "Re: "Not a valid user" crashes sql 7"
- In reply to: Dan Guzman: "Re: SP4 on SQL 7.0"
- Next in thread: Dan Guzman: "Re: SP4 on SQL 7.0"
- Reply: Dan Guzman: "Re: SP4 on SQL 7.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Joe Drobnick" <joe.drobnick@corpx.usa.net> Date: Tue, 15 Oct 2002 07:27:50 -0700
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
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Leigh Klasse: "Non-Admin Users remotely monitoring with Perfmon"
- Previous message: Dan Guzman: "Re: "Not a valid user" crashes sql 7"
- In reply to: Dan Guzman: "Re: SP4 on SQL 7.0"
- Next in thread: Dan Guzman: "Re: SP4 on SQL 7.0"
- Reply: Dan Guzman: "Re: SP4 on SQL 7.0"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
