[dba-SQLServer]SQL Server 7 and SP 4

First, I'd start making backups :)

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark L.
Breen
Sent: Friday, August 15, 2003 2:51 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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
>
>


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com