installing sp3?

I am using SQL 2000 Developers Edition with sp2
trying to install sp3a because it is a prereq for reporting services.
I installed sql2ksp3.exe. Everything seems to install fine and a messagebox
is
returned with a the "package has been installed succesful" message.
I restarted sql then ran the @.@. version query and still sp2
I restarted Window, then ran the query again with the same result
What my next step?
--
---
Yes, I searched first :)> I restarted sql then ran the @.@. version query and still sp2
AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
you get if you run
SELECT SERVERPROPERTY('ProductLevel')
?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||SELECT SERVERPROPERTY('ProductLevel')
returns "sp2"
by the way:
@.@.version returns
sql 8.00.534 . thats not my OS.
"Dejan Sarka" wrote:
> > I restarted sql then ran the @.@. version query and still sp2
> AFAIK @.@.version gives you the SP of the OS, not of the SQL Server. What do
> you get if you run
> SELECT SERVERPROPERTY('ProductLevel')
> ?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||It only installed the setup locally, now you need to run the setup. The
default setup install location is c:\sql2ksp3
Jeff
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> I am using SQL 2000 Developers Edition with sp2
> trying to install sp3a because it is a prereq for reporting services.
> I installed sql2ksp3.exe. Everything seems to install fine and a
messagebox
> is
> returned with a the "package has been installed succesful" message.
> I restarted sql then ran the @.@. version query and still sp2
> I restarted Window, then ran the query again with the same result
> What my next step?
> --
> ---
> Yes, I searched first :)|||ok, i see now. Thanks Jeff Dillon!!
"Jeff Dillon" wrote:
> It only installed the setup locally, now you need to run the setup. The
> default setup install location is c:\sql2ksp3
> Jeff
> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
> news:F4074DFD-0CA9-4843-82D5-969D431D2866@.microsoft.com...
> > I am using SQL 2000 Developers Edition with sp2
> >
> > trying to install sp3a because it is a prereq for reporting services.
> >
> > I installed sql2ksp3.exe. Everything seems to install fine and a
> messagebox
> > is
> > returned with a the "package has been installed succesful" message.
> >
> > I restarted sql then ran the @.@. version query and still sp2
> >
> > I restarted Window, then ran the query again with the same result
> >
> > What my next step?
> > --
> > ---
> > Yes, I searched first :)
>
>|||> by the way:
> @.@.version returns
> sql 8.00.534 . thats not my OS.
In your first post you did not mention version number, but you metioned
service pack explicitly, and @.@.version returns explicit service pack of the
OS.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com