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
-thanksThat 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
>|||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:
> > 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,
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:
> 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:
> > > 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
> >
> >|||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:
>> 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:
>> > > 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
>> >
>> >
>|||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:
> 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:
> >> 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:
> >> > > 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
> >> >
> >> >
> >|||> 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.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:
>> 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:
>> >> 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:
>> >> > > 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
>> >> >
>> >> >
>> >
>|||Dan Guzman wrote:
> > 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.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:
> >> 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:
> >> >> 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:
> >> >> > > 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
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') 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:
> > 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.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:
> >> 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:
> >> >> 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:
> >> >> > > 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
> >> >> >
> >> >> >
> >> >
> >|||Running setup.bat from the sql2ksp3 folder did the trick after a reboot
- and running
SELECT SERVERPROPERTY('ProductLevel') 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:
> > 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.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:
> >> 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:
> >> >> 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:
> >> >> > > 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
> >> >> >
> >> >> >
> >> >
> >|||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('ProductLevel') 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:
>> > 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.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:
>> >> 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:
>> >> >> 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:
>> >> >> > > 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
>> >> >> >
>> >> >> >
>> >> >
>> >
>