Sql Server2000 Service Packs

  • I just installed SQL Server2000 Developer Edition ("Release A" on the CD). In the box is a CD for SP3a (do I need to do SP3 first?). How do I find out what SP's need to be installed?

  • You can install SP3a by itself with no other sp's installed.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • I just found out that I have 8.00.194. The documentation says I am shy of SP1, SP2, SP3, SP3a. Should I do any of these?

    Thanks for the help.

  • All SQL Service packs, that I know of are cummulative. Instlling sp3a gives you all the fixes in all prior patches.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • Dek,

    Ray is correct. As far as I know the sp's are cumulative. You only need to install sp3a

    AJ Ahrens

    webmaster@kritter.net



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • Also, don't forget to get any other security and hotfixes after SP3a. Check at http://www.microsoft.com/technet/security/current.asp



    Mark

  • I installed SP3a, but notice on the MS site that SQL Server 2000 "should have SP's installed for Data Components and for Analysis Services." MY Developer Edition CD came only with the SP3a for "Desktop Engine."

    1. do I need the other two SPs?

    2. if so, do they need to be installed in any sequence (like, do I need to uninstall the Desktop Engine patch, before I install the three SPs?

    Thanks.

  • Data components is the normal service pack, Sql2ksp3.exe that you already installed.

    Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you do not know it, you probably won't need it.

    It is has its own service pack, Sql2kasp3.exe and you can install it after the data components service pack. I am not sure if it is necessary, just never got the idea to do it first.

  • quote:


    Data components is the normal service pack, Sql2ksp3.exe that you already installed.

    Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you do not know it, you probably won't need it.

    It is has its own service pack, Sql2kasp3.exe and you can install it after the data components service pack. I am not sure if it is necessary, just never got the idea to do it first.

    Sorry that it seems I'm belaboring the point, but as I look at the MS technet site for downloads for SQL Server 2000 http://www.microsoft.com/sql/downloads/2000/sp3.asp, and scroll down to about the middle of the page, it says :

    "This service pack includes the following files:

    Sql2ksp3.exe. Updates for database components.

    Sql2kasp3.exe. Updates for Analysis Services components.

    Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).

    Note: The service pack files for SP3a have the same names as the files for SP3."

    I installed the last one only as it was the only one on my Develop Edition CD.

    Am I okay with that, or do I need to get the Sql2ksp3.exe installed also?


  • I was wondering if anyone knew if the S2K cumulative patch is the same as the latest S2K hotfix? And if there is any word on when S2K sp4 (assuming it will include sp3a and the cumulative patch) will be available?

    Thanks!

  • You where right in asking again.

    Could you install Sql2kdesksp3.exe? The name does not cover the usage. It is not the service pack for sqlserver on a desktop, it is the service pack for MSDE, the SQLServer version that is redistributed with programs.

    If you really have the developer edition you will need Sql2ksp3.exe. You can try it anyway. If it does not find a sqlserver service, it will just refuse to install.

  • Yes, I do have the SQL Server 2000 Develop Edition CD and since it took the SP3a I asked to be installed, by definition, I must have used the right then? Is that really the bottom line?

  • Right.

    To check you can try the statement <code>select @@version</code> in query analyzer.

    It should give version 8.00.818

    The properties of the server in enterprise manager also give the SP number.

  • quote:


    I just installed SQL Server2000 Developer Edition ("Release A" on the CD). In the box is a CD for SP3a (do I need to do SP3 first?). How do I find out what SP's need to be installed?


    This site http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=3&tabid=4 maintains an updated list on service packs and version numbers.

    Frank

    http://www.insidesql.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • I did the SELECT @@VERSION and got "8.00.760." What next?

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply