Prev: Problem connecting to SQL Server from Access Database
Next: Select from a access table
From: Neil on 12 Jun 2008 17:56
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


From: Dan Guzman on 12 Jun 2008 22:26
> 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(a)nospam.net> wrote in message
news:7Zg4k.3672$L_.2828(a)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
>

From: Neil on 13 Jun 2008 00:04

"Dan Guzman" <guzmanda(a)nospam-online.sbcglobal.net> wrote in message
news:XVk4k.7694$uE5.1782(a)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


 | 
Pages: 1
Prev: Problem connecting to SQL Server from Access Database
Next: Select from a access table