Issue with Installation of Service Pack 3a

All,
I successfully ran SQL Server Service Pack 3a on a machine that has two
instances of SQL Server. I ran the service pack against both instances. It
all appeared to run fine and I rebooted.
However, when I run the following select statement in Query Analyser:
select @.@.version
It is showing me:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
It is not registering as Microsoft SQL Server 2000 - 8.00.760 to indicate
that the instances are at service pack 3a.
Did my service pack really run successfully? Is this a known issue?
Thanks,
Andrea Wright
andrea.wright@.ips-sendero.comHi Andrea,
The version of sql server you are running is 8.00.818 which is a hotfixed
version of SQL server later than than sp3 (which is version 8.00.760).
Actually the 818 version is coming with the public critical SQL server
security roll up fix MS03-031. I Expect you have installed this SQL server
security fix after you've installed sp3.
Regards,
Jago
"Andrea Wright" wrote:
> All,
> I successfully ran SQL Server Service Pack 3a on a machine that has two
> instances of SQL Server. I ran the service pack against both instances. It
> all appeared to run fine and I rebooted.
> However, when I run the following select statement in Query Analyser:
> select @.@.version
> It is showing me:
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> It is not registering as Microsoft SQL Server 2000 - 8.00.760 to indicate
> that the instances are at service pack 3a.
> Did my service pack really run successfully? Is this a known issue?
> Thanks,
> Andrea Wright
> andrea.wright@.ips-sendero.com
>
>|||Jago,
Thanks for your quick response.
I installed the following in this order:
Hotfix that fixed the security issue and the Slammer virus (Microsoft SQL
Server 2000 - 8.00.679)
Service Pack 3 (not sure of the number this put it at)
Service Pack 3a (Microsoft SQL Server 2000 - 8.00.760)
I did not realize there was another hotfix, and I didn't apply one manually.
Is this one perhaps coming with Windows updates?
Thanks,
Andrea
"Jago" <Jago@.discussions.microsoft.com> wrote in message
news:B676216C-B1D0-4F05-A8A8-213BD997DC76@.microsoft.com...
> Hi Andrea,
> The version of sql server you are running is 8.00.818 which is a hotfixed
> version of SQL server later than than sp3 (which is version 8.00.760).
> Actually the 818 version is coming with the public critical SQL server
> security roll up fix MS03-031. I Expect you have installed this SQL server
> security fix after you've installed sp3.
> Regards,
> Jago
> "Andrea Wright" wrote:
>> All,
>> I successfully ran SQL Server Service Pack 3a on a machine that has two
>> instances of SQL Server. I ran the service pack against both instances.
>> It
>> all appeared to run fine and I rebooted.
>> However, when I run the following select statement in Query Analyser:
>> select @.@.version
>> It is showing me:
>> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
>> It is not registering as Microsoft SQL Server 2000 - 8.00.760 to indicate
>> that the instances are at service pack 3a.
>> Did my service pack really run successfully? Is this a known issue?
>> Thanks,
>> Andrea Wright
>> andrea.wright@.ips-sendero.com
>>|||Hi Andre,
No was not coming with windows update
Jago
"Andrea Wright" wrote:
> Jago,
> Thanks for your quick response.
> I installed the following in this order:
> Hotfix that fixed the security issue and the Slammer virus (Microsoft SQL
> Server 2000 - 8.00.679)
> Service Pack 3 (not sure of the number this put it at)
> Service Pack 3a (Microsoft SQL Server 2000 - 8.00.760)
> I did not realize there was another hotfix, and I didn't apply one manually.
> Is this one perhaps coming with Windows updates?
> Thanks,
> Andrea
> "Jago" <Jago@.discussions.microsoft.com> wrote in message
> news:B676216C-B1D0-4F05-A8A8-213BD997DC76@.microsoft.com...
> > Hi Andrea,
> >
> > The version of sql server you are running is 8.00.818 which is a hotfixed
> > version of SQL server later than than sp3 (which is version 8.00.760).
> > Actually the 818 version is coming with the public critical SQL server
> > security roll up fix MS03-031. I Expect you have installed this SQL server
> > security fix after you've installed sp3.
> >
> > Regards,
> >
> > Jago
> >
> > "Andrea Wright" wrote:
> >
> >> All,
> >>
> >> I successfully ran SQL Server Service Pack 3a on a machine that has two
> >> instances of SQL Server. I ran the service pack against both instances.
> >> It
> >> all appeared to run fine and I rebooted.
> >>
> >> However, when I run the following select statement in Query Analyser:
> >> select @.@.version
> >>
> >> It is showing me:
> >> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> >>
> >> It is not registering as Microsoft SQL Server 2000 - 8.00.760 to indicate
> >> that the instances are at service pack 3a.
> >>
> >> Did my service pack really run successfully? Is this a known issue?
> >>
> >> Thanks,
> >> Andrea Wright
> >> andrea.wright@.ips-sendero.com
> >>
> >>
> >>
>
>|||To confirm whether you are on SP3a, run the following command.
select serverproperty('productLevel')
Andrea Wright wrote:
> All,
> I successfully ran SQL Server Service Pack 3a on a machine that has two
> instances of SQL Server. I ran the service pack against both instances. It
> all appeared to run fine and I rebooted.
> However, when I run the following select statement in Query Analyser:
> select @.@.version
> It is showing me:
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> It is not registering as Microsoft SQL Server 2000 - 8.00.760 to indicate
> that the instances are at service pack 3a.
> Did my service pack really run successfully? Is this a known issue?
> Thanks,
> Andrea Wright
> andrea.wright@.ips-sendero.com
>|||"Jonathan Yong" <jyong@.someplace.net> wrote in message
news:eP150unsEHA.624@.TK2MSFTNGP09.phx.gbl...
> To confirm whether you are on SP3a, run the following command.
> select serverproperty('productLevel')
And it should return... ? I "thought" I had SP3a - I definitely applied it
and received no errors. But I just ran this and it returns "SP3". When I
select @.@.version, I get 8.00.760.
>
> Andrea Wright wrote:
> > All,
> >
> > I successfully ran SQL Server Service Pack 3a on a machine that has two
> > instances of SQL Server. I ran the service pack against both instances.
It
> > all appeared to run fine and I rebooted.
> >
> > However, when I run the following select statement in Query Analyser:
> > select @.@.version
> >
> > It is showing me:
> > Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> >
> > It is not registering as Microsoft SQL Server 2000 - 8.00.760 to
indicate
> > that the instances are at service pack 3a.
> >
> > Did my service pack really run successfully? Is this a known issue?
> >
> > Thanks,
> > Andrea Wright
> > andrea.wright@.ips-sendero.com
> >
> >|||Mine says SP3 as well - the a is missing...
-- Andrea
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:ug0$JutsEHA.3320@.TK2MSFTNGP15.phx.gbl...
> "Jonathan Yong" <jyong@.someplace.net> wrote in message
> news:eP150unsEHA.624@.TK2MSFTNGP09.phx.gbl...
>> To confirm whether you are on SP3a, run the following command.
>> select serverproperty('productLevel')
> And it should return... ? I "thought" I had SP3a - I definitely applied it
> and received no errors. But I just ran this and it returns "SP3". When I
> select @.@.version, I get 8.00.760.
>>
>> Andrea Wright wrote:
>> > All,
>> >
>> > I successfully ran SQL Server Service Pack 3a on a machine that has two
>> > instances of SQL Server. I ran the service pack against both
>> > instances.
> It
>> > all appeared to run fine and I rebooted.
>> >
>> > However, when I run the following select statement in Query Analyser:
>> > select @.@.version
>> >
>> > It is showing me:
>> > Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
>> >
>> > It is not registering as Microsoft SQL Server 2000 - 8.00.760 to
> indicate
>> > that the instances are at service pack 3a.
>> >
>> > Did my service pack really run successfully? Is this a known issue?
>> >
>> > Thanks,
>> > Andrea Wright
>> > andrea.wright@.ips-sendero.com
>> >
>> >
>|||AFIK, SQL Server doesn't differentiate between SP 3 and SP 3a with Select
@.@.version or any other method in the database itself. You can look in the
registry for the correct version. If you're running SQL Server, run regedit
and locate HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion.
Then look at the CSDVersion value. It should be 8.00.761 for SP 3a,
8.00.760 for SP 3. There's also a file or two you can check for version
info in Windows Explorer, but I don't remember which ones off the top of my
head.
Thanks,
Michael C., MCDBA
"Andrea Wright" <andrea.wright@.ips-sendero.com#nospam> wrote in message
news:%23XbgujRtEHA.1040@.TK2MSFTNGP10.phx.gbl...
> Mine says SP3 as well - the a is missing...
> -- Andrea
> "Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
> news:ug0$JutsEHA.3320@.TK2MSFTNGP15.phx.gbl...
>> "Jonathan Yong" <jyong@.someplace.net> wrote in message
>> news:eP150unsEHA.624@.TK2MSFTNGP09.phx.gbl...
>> To confirm whether you are on SP3a, run the following command.
>> select serverproperty('productLevel')
>> And it should return... ? I "thought" I had SP3a - I definitely applied
>> it
>> and received no errors. But I just ran this and it returns "SP3". When I
>> select @.@.version, I get 8.00.760.
>>
>>
>> Andrea Wright wrote:
>> > All,
>> >
>> > I successfully ran SQL Server Service Pack 3a on a machine that has
>> > two
>> > instances of SQL Server. I ran the service pack against both
>> > instances.
>> It
>> > all appeared to run fine and I rebooted.
>> >
>> > However, when I run the following select statement in Query Analyser:
>> > select @.@.version
>> >
>> > It is showing me:
>> > Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
>> >
>> > It is not registering as Microsoft SQL Server 2000 - 8.00.760 to
>> indicate
>> > that the instances are at service pack 3a.
>> >
>> > Did my service pack really run successfully? Is this a known issue?
>> >
>> > Thanks,
>> > Andrea Wright
>> > andrea.wright@.ips-sendero.com
>> >
>> >
>>
>