Re: did service pack got installed?
- From: "Geoff N. Hiten" <sqlcraftsman@xxxxxxxxx>
- Date: Tue, 2 Aug 2005 13:38:49 -0400
Again, hotfixes are cumulative. Each Hotfix includes all lower numbered
hotfixes.
GNH
"BATMAN" <BATMAN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83CF1A31-EF10-434A-8CA2-1E4077A58DE9@xxxxxxxxxxxxxxxx
> 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
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
.
- References:
- did service pack got installed?
- From: Carlos
- Re: did service pack got installed?
- From: Geoff N. Hiten
- Re: did service pack got installed?
- From: BATMAN
- Re: did service pack got installed?
- From: Geoff N. Hiten
- Re: did service pack got installed?
- From: BATMAN
- did service pack got installed?
- Prev by Date: Re: did service pack got installed?
- Next by Date: Re: datafile and log file on cluster
- Previous by thread: Re: did service pack got installed?
- Next by thread: do not see management studio after installing SS2005 Beta 2
- Index(es):
Relevant Pages
|
