[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
>