Re: did service pack got installed?

In regard to my last question, about resulting build number... I guess all
that matters is knowing what HotFixes have been applied.

With that said I assuming the best place to look for what HotFix(es) have
been applied is the "Add Remove Programs" console built into the OS.

What are your thoughts? Are there any utilities out there like the MDAC
Component Checker that quickly searches lists out service packs and HotFixes?

Thanks...

"Geoff N. Hiten" wrote:

> 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: did service pack got installed?
    ... What happens if you install two HotFixes? ... "Geoff N. Hiten" wrote: ... >>> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: did service pack got installed?
    ... Again, hotfixes are cumulative. ... > In regard to my last question, ... > Component Checker that quickly searches lists out service packs and ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: windows updates list
    ... I suppose the Add/Remove programs applet lists service packs ... The VBScript below will list updates installed regardless if Windows ... the user that installed it and installation date. ... Hotfixes Identified: ...
    (microsoft.public.win2000.general)
  • Re: windows updates list
    ... I suppose the Add/Remove programs applet lists service packs ... The VBScript below will list updates installed regardless if Windows ... the user that installed it and installation date. ... Hotfixes Identified: ...
    (microsoft.public.windowsxp.general)
  • Re: SQL Server Setup
    ... If you hit F5 while in the list, it'll remove the already-removed items from the list so it'll be updated. ... but the Programs & Features lists many items related to SQL Server. ... Microsoft SQL Server 2008 Browser ... Microsoft SQL Server 2008 Setup Support Files (English) ...
    (microsoft.public.sqlserver.setup)