[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