[dba-SQLServer]SQL Server 7 and SP 4

Thanks for that, Robert.  And I can now add 
	SP2 - 7.00.623

John


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Djabarov, Robert
> Sent: 15 August 2003 19:12
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer]SQL Server 7 and SP 4
> 
> 
> You need to go by @@version value.
> 
> SP3 (no additional hot fixes) - 961
> SP4 (no additional hot fixes) - 1063
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
> DJK(John) Robinson
> Sent: Friday, August 15, 2003 12:50 PM
> To: dba-sqlserver at databaseadvisors.com
> 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
> 
>