Check version of SQL 2000 w/ select @@version

Can anybody tell me when i complete the sp4 upgrade to my sql server
2000 why when I type "select @.@.version" under sql query analyzer it
doesn't releft latest upgrade to sevice pack 4?
ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
2000 00:57:48
Any reply to help would be much appreciated... email:
mlajoinie@.gmail.com
-thanks
That is rtm. Better reapply the sp again.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159588073.880553.264310@.m73g2000cwd.googlegr oups.com...
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks
>
|||Thanks, but I have reapplied this sp4 with same results, also tried it
on a sql 2000 dvlp ed. on xp with same results. I read something about
having the services stopped prior to running the service pack so tried
that too with same results after the select @.@.version command. Are
there any cmd lines to force the sp upgrade?
frizzzdog wrote:
> Can anybody tell me when i complete the sp4 upgrade to my sql server
> 2000 why when I type "select @.@.version" under sql query analyzer it
> doesn't releft latest upgrade to sevice pack 4?
> ie. it still shows Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
> 2000 00:57:48
> Any reply to help would be much appreciated... email:
> mlajoinie@.gmail.com
> -thanks
|||Hi
Have you extracted the service pack and then run the upgrade or just
extracted it?
John
"frizzzdog" wrote:

> Thanks, but I have reapplied this sp4 with same results, also tried it
> on a sql 2000 dvlp ed. on xp with same results. I read something about
> having the services stopped prior to running the service pack so tried
> that too with same results after the select @.@.version command. Are
> there any cmd lines to force the sp upgrade?
> frizzzdog wrote:
>
|||John,
I extracted the service pack then ran it from a saved folder with same
reszults from sql query. Read somewhere that the services must stopped
when running the service pack but only saw it once. Any more thoughts -
same results from the query...
Marc
John Bell wrote:[vbcol=seagreen]
> Hi
> Have you extracted the service pack and then run the upgrade or just
> extracted it?
> John
> "frizzzdog" wrote:
|||Do you have multiple SQL 2000 instances installed? Each must be upgraded
independently.
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159637870.608584.51190@.m73g2000cwd.googlegro ups.com...
> John,
> I extracted the service pack then ran it from a saved folder with same
> reszults from sql query. Read somewhere that the services must stopped
> when running the service pack but only saw it once. Any more thoughts -
> same results from the query...
> Marc
> John Bell wrote:
>
|||Have you tried:
SELECT SERVERPROPERTY('productversion') Version,
SERVERPROPERTY ('productlevel') Level,
SERVERPROPERTY ('edition') Edition,
SERVERPROPERTY ('LicenseType') LicenseType,
SERVERPROPERTY ('Engine Edition') EngineEdition,
SERVERPROPERTY ('InstanceName') InstanceName,
SERVERPROPERTY ('IsClustered') IsClustered,
SERVERPROPERTY ('IsFullTextInstalled') IsFullTextInstalled,
SERVERPROPERTY ('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly,
SERVERPROPERTY ('IsSingleUser') IsSingleUser,
SERVERPROPERTY ('IsSyncWithBackup') IsSyncWithBackup,
SERVERPROPERTY ('MachineName') MachineName,
SERVERPROPERTY ('ProcessID') ProcessID,
SERVERPROPERTY ('ServerName') ServerName
|||Dan, under Microsoft SQL Server folder, isn't this where I'd see my
named instances? Running straight SQL Server 2000, not MSDE, if that
helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
sql2kasp.exe are run it afterwards), I still get the RTM return value -
not anything with reflected SP3 in return. Can I integrate SP3 into
bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
install SP3 ?
thanks, Marc
Dan Guzman wrote:[vbcol=seagreen]
> Do you have multiple SQL 2000 instances installed? Each must be upgraded
> independently.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159637870.608584.51190@.m73g2000cwd.googlegro ups.com...
|||> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances?
Yes, but only if the default installation location(s) was chosen. You can
see all installed instances from Service Manager or under the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.

> When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return.
Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
sql2ksp3 setup will prompt you for the target instance after the EULA
dialog. Also, be sure you are connecting to that same instance when you
verify the installation. Personally, I prefer to use SELECT
SERVERPROPERTY('ProductLevel') so I don't have to remember the build
numbers.
The AS service pack (sql2kasp.exe) isn't related to the database engine
version. Also, your original post said SP4 but you now mention SP3.
Service packs are cumulative so you don't need to install both.

> Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
in about that.
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@.gmail.com> wrote in message
news:1159664323.042983.24610@.k70g2000cwa.googlegro ups.com...
> Dan, under Microsoft SQL Server folder, isn't this where I'd see my
> named instances? Running straight SQL Server 2000, not MSDE, if that
> helps. When I run, the SP3 package save and extract (sql2ksp3.exe then
> sql2kasp.exe are run it afterwards), I still get the RTM return value -
> not anything with reflected SP3 in return. Can I integrate SP3 into
> bart's PE CD with SQL 2000 so that when I reinstall, it'll extract and
> install SP3 ?
> thanks, Marc
> Dan Guzman wrote:
>
|||Dan Guzman wrote:[vbcol=seagreen]
> Yes, but only if the default installation location(s) was chosen. You can
> see all installed instances from Service Manager or under the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
>
> Just to be clear, did you run setup.bat from the sql2ksp3 folder? The
> sql2ksp3 setup will prompt you for the target instance after the EULA
> dialog. Also, be sure you are connecting to that same instance when you
> verify the installation. Personally, I prefer to use SELECT
> SERVERPROPERTY('ProductLevel') so I don't have to remember the build
> numbers.
> The AS service pack (sql2kasp.exe) isn't related to the database engine
> version. Also, your original post said SP4 but you now mention SP3.
> Service packs are cumulative so you don't need to install both.
>
> Sorry, but I know nothing about bart's PE CD. Maybe someone else can jump
> in about that.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "frizzzdog" <mlajoinie@.gmail.com> wrote in message
> news:1159664323.042983.24610@.k70g2000cwa.googlegro ups.com...