How to Determine Service Pack Level

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chaplain Doug - 27 Jan 2006 17:32 GMT

SQL Server 2000. I have SQL Server 2000 installed as part of Small Business
Server 2003. I am a SQL novice, so please answer gracefully and clearly.
How do I determine what service pack level I am on (i.e., 3, 3a, or 4) and
where do I get the latest service packs. Is there anything like "auto
update", or a wizard that leads one through the update process for SQL Server
2000 like there is for Windows Server and the Office products? Thanks and
God bless.

Signature

Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Reply to this Message

Chaplain Doug - 27 Jan 2006 17:47 GMT

I went to the SQL Server 2000 download page for Service Pack 4. The
following files were listed, with the directions to "download the ones
appropriate for you." How do I determine which of these are appropriate for
me!?

ReadmeSql2k32asp4.htm
ReadmeSql2k32desksp4.htm
ReadmeSql2k32sp4.htm
ReadmeSql2k64sp4.htm
SQL2000.AS-KB884525-SP4-x86-ENU.EXE
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
SQL2000-KB884525-SP4-ia64-ENU.EXE
SQL2000-KB884525-SP4-x86-ENU.EXE

Signature

Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

> SQL Server 2000. I have SQL Server 2000 installed as part of Small Business
> Server 2003. I am a SQL novice, so please answer gracefully and clearly.
[quoted text clipped - 3 lines]
> 2000 like there is for Windows Server and the Office products? Thanks and
> God bless.

Reply to this Message

Chaplain Doug - 27 Jan 2006 18:36 GMT

I found a script that gave me the following:

Version 8.00.760
SP3
Standard Edition

So which of the following file(s) do I download from the Microsoft download
site?

ReadmeSql2k32asp4.htm
ReadmeSql2k32desksp4.htm
ReadmeSql2k32sp4.htm
ReadmeSql2k64sp4.htm
SQL2000.AS-KB884525-SP4-x86-ENU.EXE
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
SQL2000-KB884525-SP4-ia64-ENU.EXE
SQL2000-KB884525-SP4-x86-ENU.EXE

Signature

Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

Reply to this Message

Jasper Smith - 27 Jan 2006 21:48 GMT

SQL2000-KB884525-SP4-x86-ENU.EXE
ReadmeSql2k32sp4.htm

Signature

HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

>I found a script that gave me the following:
>
[quoted text clipped - 26 lines]
>> and
>> God bless.

Reply to this Message

Chaplain Doug - 27 Jan 2006 23:49 GMT

Thanks Jasper. How can I decipher the cryptic file names in the future.
That is, what do all of the "SQL2000-KB884525-SP4-x86-ENU.EXE" mean? I
understand "SQL2000" and "SP4." What does all the rest of the stuff mean?

Signature

Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

> SQL2000-KB884525-SP4-x86-ENU.EXE
> ReadmeSql2k32sp4.htm
[quoted text clipped - 29 lines]
> >> and
> >> God bless.

Reply to this Message

Hugo Kornelis - 28 Jan 2006 22:47 GMT

>Thanks Jasper. How can I decipher the cryptic file names in the future.
>That is, what do all of the "SQL2000-KB884525-SP4-x86-ENU.EXE" mean? I
>understand "SQL2000" and "SP4." What does all the rest of the stuff mean?

Hi Doug,

KB884525 - the Knowledge Base article that describes Service Pack 4.

x86 - the processor family (if you're on 64-bit, download the ia64
version instead)

ENU - language: US English

Signature

Hugo Kornelis, SQL Server MVP

Reply to this Message

Chaplain Doug - 29 Jan 2006 00:02 GMT

Merci Beaucoup Hugo! Adios.

Signature

Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

> >Thanks Jasper. How can I decipher the cryptic file names in the future.
> >That is, what do all of the "SQL2000-KB884525-SP4-x86-ENU.EXE" mean? I
[quoted text clipped - 8 lines]
>
> ENU - language: US English

Reply to this Message