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:

> 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...
> messagebox
>
>
|||> 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