MSDE upgraded to SP4 but showing SP2

Re: MSDE upgraded to SP4 but showing SP2


"Dan Guzman" <guzmanda@nospa m-online.sbcgloba l.netwrote in message
news:XVk4k.7694 $uE5.1782@flpi1 44.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

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" <nospam@nospam. netwrote in message
news:7Zg4k.3672 $L_.2828@flpi15 0.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
>

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