MSDE upgraded to SP4 but showing SP2

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Neil
    #1

    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


    Tags: None
    • Dan Guzman
      #2
      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
      Dan Guzman Blog
      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
      >

        Comment

        • Neil
          #3
          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


            Comment

            Previous template Next
            Working...