MSDE upgraded to SP4 but showing SP2   

I just upgraded my SQL 7 to SP4 (actually MSDE 1.0). I used sql70sp4.exe 
from the Microsoft site, ran the setup program, and everything seemed to 
work fine, and I restarted my system. Now the value of @@version is this:

Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86)
 Apr  9 2002 14:18:16
 Copyright (c) 1988-2002 Microsoft Corporation
 Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

According to http://support.microsoft.com/kb/889543, 7.00.1063 is the 
correct version for SP4; and the date, 4/9/02 is correct as well. However, 
it still says "Build 2600: Service Pack 2," instead of "Build 1381: Service 
Pack 4". Anyone know why? Thanks,

Neil

date: Thu, 12 Jun 2008 16:56:48 -0500   author:   Neil

Re: MSDE upgraded to SP4 but showing SP2   

> According to http://support.microsoft.com/kb/889543, 7.00.1063 is the 
> correct version for SP4; and the date, 4/9/02 is correct as well. However, 
> it still says "Build 2600: Service Pack 2," instead of "Build 1381: 
> Service Pack 4". Anyone know why? Thanks,

The service pack number in the @@VERSION string is the OS service pack 
level, not the SQL Server one.  7.00.1063 indices the SQL service pack level 
was installed.

You might consider upgrading to SQL 2005 Express Edition.  SQL 7 is 
currently two major versions behind, soon to be three.

-- 
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Neil"  wrote in message 
news:7Zg4k.3672$L_.2828@flpi150.ffdc.sbc.com...
>I just upgraded my SQL 7 to SP4 (actually MSDE 1.0). I used sql70sp4.exe 
>from the Microsoft site, ran the setup program, and everything seemed to 
>work fine, and I restarted my system. Now the value of @@version is this:
>
> Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86)
> Apr  9 2002 14:18:16
> Copyright (c) 1988-2002 Microsoft Corporation
> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> According to http://support.microsoft.com/kb/889543, 7.00.1063 is the 
> correct version for SP4; and the date, 4/9/02 is correct as well. However, 
> it still says "Build 2600: Service Pack 2," instead of "Build 1381: 
> Service Pack 4". Anyone know why? Thanks,
>
> Neil
>

date: Thu, 12 Jun 2008 21:26:27 -0500   author:   Dan Guzman

Re: MSDE upgraded to SP4 but showing SP2   

"Dan Guzman"  wrote in message 
news:XVk4k.7694$uE5.1782@flpi144.ffdc.sbc.com...
>> According to http://support.microsoft.com/kb/889543, 7.00.1063 is the 
>> correct version for SP4; and the date, 4/9/02 is correct as well. 
>> However, it still says "Build 2600: Service Pack 2," instead of "Build 
>> 1381: Service Pack 4". Anyone know why? Thanks,
>
> The service pack number in the @@VERSION string is the OS service pack 
> level, not the SQL Server one.  7.00.1063 indices the SQL service pack 
> level was installed.
>
> You might consider upgrading to SQL 2005 Express Edition.  SQL 7 is 
> currently two major versions behind, soon to be three.
>
Ah, right. I misread a part of the description on the website, so that I 
thought it was referring to SQL Server. Thanks!

As for upgrading, yes, we're going to be going to SQL 2005 very soon (as 
soon as I get a chance).

Thanks,

Neil

date: Thu, 12 Jun 2008 23:04:18 -0500   author:   Neil