Re: did service pack got installed?

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: did service pack got installed?
    ... >> Geoff N. Hiten ... >> Microsoft SQL Server MVP ... >>> I just tried to install service pack 4, ...
    (microsoft.public.sqlserver.setup)
  • Re: 2000 Developer Edition & Windows Advanced 2003 Server - options?
    ... but otherwise just do a normal install. ... > Hey thanks Geoff, ... > SQL Server 2000 SP2 and below is not supported by this version of Windows. ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Error during Instance Install
    ... I have logged onto each machine previous with the install account. ... "Geoff N. Hiten" wrote: ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: ServerProtect v Officescan client on server?
    ... With Trend C/S/M SMB there is no longer a distinction between workstations ... > We have a couple of Terminal Servers that we could not install a Trend ... >>> Geoff ...
    (microsoft.public.backoffice.smallbiz2000)
Loading