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.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
>
>
|||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...[vbcol=seagreen]
> 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:
|||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...
>
>
|||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.
[vbcol=seagreen]
>
> Andrea Wright wrote:
It[vbcol=seagreen]
indicate[vbcol=seagreen]
|||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...
> 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.
> It
> indicate
>
|||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\Cu rrentVersion.
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...
>