[dba-SQLServer]SQL Server 7 and SP 4

Hello John and Robert,

Thank you very much,

What we can all derive from this is that the build informs us that the SP is
applied.

What I do not understand is why the SP's are so wrong, on SQL Desktop
edition, is returns SP1 even though it started out at SP 2 and I then reved
it to SP4.

Anyway, thank you guys for your help.

Does anyone know of a way to rectify the incorrect reported verion number ?

Possibly an update in the registry (much as I do not wish to do so)

Regards from Ireland

Mark Breen




----- Original Message ----- 
From: "DJK(John) Robinson" <djkr at msn.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Friday, August 15, 2003 6:50 PM
Subject: RE: [dba-SQLServer]SQL Server 7 and SP 4


> Mark
>
> I have heard (NB: hearsay, not personal first-hand experience) that SP4
does
> not leave the usual obvious evidence of having been installed.  By which I
> mean that Help\About still says *after* successful installation whatever
it
> said beforehand.
>
> But then of course it would also say that if the installation had totally
> failed.  Maybe there is a bug clearance in SP4 that you could check fairly
> easily? - to gain some confidence that the installation may have
succeeded,
> at least partly?!
>
> I may get the chance to try this myself over the weekend, and will report
my
> experience if I do.
>
> HTH a bit
> John
>
>
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf
> > Of Mark L. Breen
> > Sent: 15 August 2003 17:36
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: [dba-SQLServer]SQL Server 7 and SP 4
> >
> >
> > Hello All,
> >
> > Firstly, I have had a good look at the knowledge base and
> > also in Deja to check to see if my question has already been
> > answered.  There are a few similiar issues reported but I do
> > not think that there is a matching one.
> >
> > I have SQL 7.0 SP 2 installed  on Windows 2000 SP 2.
> >
> > Two days ago, I tried to install SQL 7.0 SP4 on the machine.
> > Everything went smoothly except for an error message
> > suggesting that 'something' is trying to overwrite the
> > certain system files and that they are from an unknown
> > source.  The message box does offer the choice to ignore,
> > which I presumed at the time allows the installtion to proceed.
> >
> > The remainder of the installation went without any other
> > issues.  When I finished the installation, the version is
> > still the same, it appears that the SP2 has not been applied.
> >  I am confused because it appeared to have worked.
> >
> > Does anyone have any suggestions or similiar experience ?
> > There seem to be a number of similiar issues with failed
> > installations of SP's.
> >
> > Your help and time is appriciated,
> >
> > Thanks in advance,
> >
> > Mark Breen
> > Ireland
> >
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>