Re: did service pack got installed?

Ahh. Aaron changed the format and separated the build list from the "How to
determine.." article. I didn't notice that. Here is the definitive build
list:

http://www.aspfaq.com/sql2000Builds.asp

Geoff N. Hiten
Senoir Database Administrator
Microsoft SQL Server MVP



"BATMAN" <BATMAN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC0D9778-C9B9-4408-B3C4-FD475C93A120@xxxxxxxxxxxxxxxx
> We're trying to determine if any hot fixes exist on one of our servers.
> Is
> there a build list that exist that indicates versions since RTM?
>
> Thanks...
>
>
>
> "Geoff N. Hiten" wrote:
>
>> Yes.
>>
>> > Microsoft SQL Server 2000 - 8.00.2039
>> _____________________________ ^^^^
>>
>> Those are the build numbers. 2039 = SP4.
>>
>> http://www.aspfaq.com/show.asp?id=2160
>>
>> Doesn't have SP4 listed yet, but it probably will soon.
>>
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>>
>>
>> "Carlos" <ch_sanin@xxxxxxxxx> wrote in message
>> news:OtqQmxslFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I just tried to install service pack 4, and even though it apparently
>> > installed fine, I get the following after querying the version
>> > (i.e. select @@version)
>> >
>> > Microsoft SQL Server 2000 - 8.00.2039
>> > (Intel X86) May 3 2005 23:18:38
>> > Copyright (c) 1988-2003
>> > Microsoft Corporation Developer Edition
>> > on Windows NT 5.1
>> > (Build 2600: Service Pack 2)
>> >
>> > Can someone help me on how can I find out if the installation
>> > was ok?
>> >
>> > Thanks,
>> >
>> > Carlos
>> >
>>
>>
>>


.

Relevant Pages

  • Re: Failed SQL Cluster Install Advice
    ... Microsoft SQL Server MVP ... SQL cluster questions" that if you have time I would love to hear your ... "Geoff N. Hiten" wrote: ... > systems with all the changes and have decided to install everything> from ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 - beta period expired??
    ... I am having the same problem with the April ctp and just installed it. ... hr install for me and I dont want to do again if not necessary. ... >>> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Time-out error (Error # 845)
    ... >> Geoff N. Hiten ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server Licenses
    ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ... > Q314947 but it never asked for a license during the install. ...
    (microsoft.public.sqlserver.server)
  • Re: AWE - SQL Server 2000 - Memory usage
    ... >> Geoff N. Hiten ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)