|
Home > Archive > MS SQL Server > October 2006 > Check version of SQL 2000 w/ select @@version
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Check version of SQL 2000 w/ select @@version
|
|
| frizzzdog 2006-10-24, 6:33 pm |
| 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
| |
| Hilary Cotter 2006-10-24, 6:33 pm |
| 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.googlegroups.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
>
| |
| frizzzdog 2006-10-24, 6:33 pm |
| 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
| |
| John Bell 2006-10-24, 6:33 pm |
| 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:
>
>
| |
| frizzzdog 2006-10-24, 6:33 pm |
| 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:[color=darkred
]
> Hi
>
> Have you extracted the service pack and then run the upgrade or just
> extracted it?
>
> John
>
> "frizzzdog" wrote:
>
| |
| Dan Guzman 2006-10-24, 6:33 pm |
| 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.googlegroups.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:
>
| |
| newscorrespondent@charter.net 2006-10-24, 6:33 pm |
| Have you tried:
SELECT SERVERPROPERTY('prod
uctversion') Version,
SERVERPROPERTY ('productlevel') Level,
SERVERPROPERTY ('edition') Edition,
SERVERPROPERTY ('LicenseType') LicenseType,
SERVERPROPERTY ('Engine Edition') EngineEdition,
SERVERPROPERTY ('InstanceName') InstanceName,
SERVERPROPERTY ('IsClustered') IsClustered,
SERVERPROPERTY ('IsFullTextInstalle
d') IsFullTextInstalled,
SERVERPROPERTY ('IsIntegratedSecuri
tyOnly') IsIntegratedSecurity
Only,
SERVERPROPERTY ('IsSingleUser') IsSingleUser,
SERVERPROPERTY ('IsSyncWithBackup')
IsSyncWithBackup,
SERVERPROPERTY ('MachineName') MachineName,
SERVERPROPERTY ('ProcessID') ProcessID,
SERVERPROPERTY ('ServerName') ServerName
| |
| frizzzdog 2006-10-24, 6:33 pm |
| 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:[color=darkred
]
> 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.googlegroups.com...
| |
| Dan Guzman 2006-10-24, 6:33 pm |
| > 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\S
OFTWARE\Microsoft\Mi
crosoft 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('Prod
uctLevel') 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.googlegroups.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:
>
| |
| frizzzdog 2006-10-24, 6:33 pm |
|
Dan Guzman wrote:[color=darkred
]
>
> 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\S
OFTWARE\Microsoft\Mi
crosoft 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('Prod
uctLevel') 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.googlegroups.com...
| |
| frizzzdog 2006-10-24, 6:33 pm |
| Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('Prod
uctLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:[color=darkred
]
>
> 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\S
OFTWARE\Microsoft\Mi
crosoft 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('Prod
uctLevel') 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.googlegroups.com...
| |
| frizzzdog 2006-10-24, 6:33 pm |
| Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('Prod
uctLevel') resulted in SP3 for text output -
thanks!
I think personally I was reading some other (bogus and misleading )
blogs off scroogle.org then choosing "google scraper" - this way Im not
a stat for google but rather use their engine via scroogle.org -
besides they've got some hilarious not so PC comments about big bro
google on the search engine. That is running sql2ksp.exe then
sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
just a lab I'm setting up so will stick with SP3 sorry for the
confusion.. I also wonder out loud if I have an msdn subscription but
don't see office server 2007 as a download there yet do you know if the
msdn subscriber community will be privy to this release prior to final
release later this year? Thanks again, you were very helpful and onward
to laying down the tracks to Sharepoint 2003 (via a couple of vmware
workstations).
Marc
Dan Guzman wrote:[color=darkred
]
>
> 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\S
OFTWARE\Microsoft\Mi
crosoft 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('Prod
uctLevel') 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.googlegroups.com...
| |
| Dan Guzman 2006-10-24, 6:33 pm |
| Glad to see you got it installed.
> Sorry heard SP4 isn't for the faint of heart
That's a bit of an exaggeration, IMHO. We have SP4 installed on all of our
SQL 2000 servers plus the AWE hotfix
(http://support.microsoft.com/default.aspx?kbid=899761) and have had no
problems. Note that SP3 is no longer supported. See
http://support.microsoft.com/gp/lifesupsps#Windows
> I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year?
I see the Office 2007 beta 2 downloads currently available on MSDN for
Grove, Project and Sharepoint server.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"frizzzdog" <mlajoinie@gmail.com> wrote in message
news:1159703063.424054.269200@m7g2000cwm.googlegroups.com...
> Running setup.bat from the sql2ksp3 folder did the trick after a reboot
> - and running
> SELECT SERVERPROPERTY('Prod
uctLevel') resulted in SP3 for text output -
> thanks!
> I think personally I was reading some other (bogus and misleading )
> blogs off scroogle.org then choosing "google scraper" - this way Im not
> a stat for google but rather use their engine via scroogle.org -
> besides they've got some hilarious not so PC comments about big bro
> google on the search engine. That is running sql2ksp.exe then
> sql2kasp.exe. Sorry heard SP4 isn't for the faint of heart - this is
> just a lab I'm setting up so will stick with SP3 sorry for the
> confusion.. I also wonder out loud if I have an msdn subscription but
> don't see office server 2007 as a download there yet do you know if the
> msdn subscriber community will be privy to this release prior to final
> release later this year? Thanks again, you were very helpful and onward
> to laying down the tracks to Sharepoint 2003 (via a couple of vmware
> workstations).
> Marc
>
> Dan Guzman wrote:
>
|
|
|
|
|