can't open an .msc file to monitor SQL server on another machine

I need to be able to monitor our SQL server's performance on a new machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
Paul
That is not how Enterprise Manager work. You need to install the client tools on the client machine
where you want to run Enterprise Manager. You then, on that client machine, register the SQL Servers
you want to work against.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it's
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>
|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
machine[vbcol=seagreen]
open it[vbcol=seagreen]
it's
>
|||Then why the need to transfer the msc file? What purpose would that serve? Perhaps I'm
misunderstanding what you want to achieve?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> tools on the client machine
> machine, register the SQL Servers
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> machine
> open it
> it's
>
|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
in[vbcol=seagreen]
but
>
|||I see, you are talking about performance monitor, not Enterprise Manager. Sorry, I haven't used
perfmon enough to know whether the msc file is portable and if so between which OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if the need arises again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.gbl...
>I have a monitor that graphs SQL Server access methods, processor time, disk
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Perhaps I'm
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> in
> but
>

can't open an .msc file to monitor SQL server on another machine

I need to be able to monitor our SQL server's performance on a new machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
PaulThat is not how Enterprise Manager work. You need to install the client tools on the client machine
where you want to run Enterprise Manager. You then, on that client machine, register the SQL Servers
you want to work against.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it's
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> >I need to be able to monitor our SQL server's performance on a new
machine
> > but simply copying the .msc file I use to this machine and trying to
open it
> > isn't working. I get this error message:
> >
> > MMC cannot open the selected file
> >
> > If it matters, the problelm machine is Windows 2000 and mine is XP.
> >
> > I thought that I might need to just open MMC and create a new .msc but
it's
> > been so long I can't really remember how to do it at all!
> >
> > Need some help here...
> >
> > Paul
> >
> >
>|||Then why the need to transfer the msc file? What purpose would that serve? Perhaps I'm
misunderstanding what you want to achieve?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
>> That is not how Enterprise Manager work. You need to install the client
> tools on the client machine
>> where you want to run Enterprise Manager. You then, on that client
> machine, register the SQL Servers
>> you want to work against.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Paul" <noone@.executespammers.org> wrote in message
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> >I need to be able to monitor our SQL server's performance on a new
> machine
>> > but simply copying the .msc file I use to this machine and trying to
> open it
>> > isn't working. I get this error message:
>> >
>> > MMC cannot open the selected file
>> >
>> > If it matters, the problelm machine is Windows 2000 and mine is XP.
>> >
>> > I thought that I might need to just open MMC and create a new .msc but
> it's
>> > been so long I can't really remember how to do it at all!
>> >
>> > Need some help here...
>> >
>> > Paul
>> >
>> >
>|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> > Already did that.
> >
> > Paul
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> >> That is not how Enterprise Manager work. You need to install the client
> > tools on the client machine
> >> where you want to run Enterprise Manager. You then, on that client
> > machine, register the SQL Servers
> >> you want to work against.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Paul" <noone@.executespammers.org> wrote in message
> > news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> >> >I need to be able to monitor our SQL server's performance on a new
> > machine
> >> > but simply copying the .msc file I use to this machine and trying to
> > open it
> >> > isn't working. I get this error message:
> >> >
> >> > MMC cannot open the selected file
> >> >
> >> > If it matters, the problelm machine is Windows 2000 and mine is XP.
> >> >
> >> > I thought that I might need to just open MMC and create a new .msc
but
> > it's
> >> > been so long I can't really remember how to do it at all!
> >> >
> >> > Need some help here...
> >> >
> >> > Paul
> >> >
> >> >
> >>
> >
> >
>|||I see, you are talking about performance monitor, not Enterprise Manager. Sorry, I haven't used
perfmon enough to know whether the msc file is portable and if so between which OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if the need arises again.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.gbl...
>I have a monitor that graphs SQL Server access methods, processor time, disk
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
>> Then why the need to transfer the msc file? What purpose would that serve?
> Perhaps I'm
>> misunderstanding what you want to achieve?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Paul" <noone@.executespammers.org> wrote in message
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
>> > Already did that.
>> >
>> > Paul
>> >
>> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
>> > message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
>> >> That is not how Enterprise Manager work. You need to install the client
>> > tools on the client machine
>> >> where you want to run Enterprise Manager. You then, on that client
>> > machine, register the SQL Servers
>> >> you want to work against.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >> Blog: http://solidqualitylearning.com/blogs/tibor/
>> >>
>> >>
>> >> "Paul" <noone@.executespammers.org> wrote in message
>> > news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> >> >I need to be able to monitor our SQL server's performance on a new
>> > machine
>> >> > but simply copying the .msc file I use to this machine and trying to
>> > open it
>> >> > isn't working. I get this error message:
>> >> >
>> >> > MMC cannot open the selected file
>> >> >
>> >> > If it matters, the problelm machine is Windows 2000 and mine is XP.
>> >> >
>> >> > I thought that I might need to just open MMC and create a new .msc
> but
>> > it's
>> >> > been so long I can't really remember how to do it at all!
>> >> >
>> >> > Need some help here...
>> >> >
>> >> > Paul
>> >> >
>> >> >
>> >>
>> >
>> >
>

can't open an .msc file to monitor SQL server on another machine

I need to be able to monitor our SQL server's performance on a new machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
PaulThat is not how Enterprise Manager work. You need to install the client tool
s on the client machine
where you want to run Enterprise Manager. You then, on that client machine,
register the SQL Servers
you want to work against.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.g
bl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open
it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it'
s
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
machine[vbcol=seagreen]
open it[vbcol=seagreen]
it's[vbcol=seagreen]
>|||Then why the need to transfer the msc file? What purpose would that serve? P
erhaps I'm
misunderstanding what you want to achieve?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.g
bl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> tools on the client machine
> machine, register the SQL Servers
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> machine
> open it
> it's
>|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
in[vbcol=seagreen]
but[vbcol=seagreen]
>|||I see, you are talking about performance monitor, not Enterprise Manager. So
rry, I haven't used
perfmon enough to know whether the msc file is portable and if so between wh
ich OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if t
he need arises again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.
gbl...
>I have a monitor that graphs SQL Server access methods, processor time, dis
k
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Perhaps I'm
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> in
> but
>

Can't get SP3a installed

I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>> Hi
>> After running sql2ksp3.exe (it extracts to a directory), did you run the
>> setup.bat to install the SP?
>> Did the setup.bat run with errors?
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>
>

Can't get SP3a installed

I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
Jesse
Hi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:

> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>
|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>

Can't get SP3a installed

I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:

> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Window
s
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version.
I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>