MSDE upgraded to SP4 but showing SP2

[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

[Dan Guzman]

Post by Neil
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,
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/

Post by 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
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,
Service Pack 4". Anyone know why? Thanks,
Neil

[Neil]

Post by Dan Guzman

Post by Neil
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,

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