Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks Alfred
I found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!
|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard
|||try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||man forgot attachment - bad day ..
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:%23bs6bC4jEHA.1356@.TK2MSFTNGP09.phx.gbl...
> (sorry fat fingers)
> try attached vbscript uses DMO to delete the server registration - rename
to
> .vbs and run on the server with registration u want to delete by using :
> CSCRIPT DELSQLRegistration.vbs SERVER
> where SERVER is the name of the server Registration you want to delete
> Note for it to no longer appear in Enterprise Manager , you need to
restart
> Enterprise Manager.
> Andy.
> "Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
> news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
>
begin 666 DelSQLRegistration.txt
M)R J*BH@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B<R J*BH-"B<@.=7-I;F<@.1$U/
M(%-C<FEP="!O=70@.<F]L;"!T:')O=6=H(%-E<G9E<G,@.4F5G:7-T97)E9"!I
M;B!%;G1E<G!R:7-E($UA;F%G97(@.#0HG(&%N9"!T<GD@.86YD(&1E;&5T90T*
M)R!0<F5S=6UE(%-!($%C8V5S<PT*)R!!;F1Y($)A;&P@.,S$O."\R,# T#0H-
M"D]P=&EO;B!%>'!L:6-I= T*( T*#0I$:6T@.;T%R9W,@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.)R!!<F=U;65N=',-"D1I;2!7<VA3:&5L;" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G(&9O<B!7:6YD;W=S(%-C<FEP
M=&EN9R!(;W-T#0I$:6T@.3&]C86Q397)V97).86UE(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.)R!T:&4@.4V5R=F5R#0I$:6T@.3&]C86Q$0DYA;64@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.)R!T:&4@.9&%T86)A<V4-"D1I;2!,;V-A;%-13%5S
M97).86UE(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!5<V5R($YA;64-"D1I
M;2!,;V-A;%-13%!A<W-W;W)D(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!0
M87-S=V]R9 T*#0HG($YE960@.4'5B;&EC($%R<F%Y(&)E8V%U<V4@.=&AE(%-U
M8B!T;R!E;G5M97)A=&4@.=&AE(%-E<G9E<G,@.9G)O;2!$34\@.:7,@.<F5C=7)S
M:79E+BX-"E!U8FQI8R!397)V97)!<G)A>2@.I#0I0=6)L:6,@.07)R87E0;W ,-
M"D%R<F%Y4&]S/3 -"@.T*#0IS970@.5W-H4VAE;&P@./2!#<F5A=&5/8FIE8W0@.
M*")7<V-R:7!T+E-H96QL(BD-"@.T*)R!087)A;65T97)S#0IS970@.;T%R9W,@.
M/2!7<V-R:7!T+D%R9W5M96YT<PT*#0HG(&-H96-K(&-O<G)E8W0@.;G5M8F5R
M(&]F(&%R9W,-"DEF("AO07)G<RY#;W5N=" \/B Q*2!4:&5N#0H)5W-C<FEP
M="Y%8VAO(")5<V%G92 Z(&-S8W)I<'0@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B
M<R \4V5R=F5R/B(-"@.E7<V-R:7!T+D5C:&\@.(FDN92X@.(#H@.8W-C<FEP="!$
M96Q344Q296=I<W1R871I;VXN=F)S($]L9%-E<G9E<B(-"@.E7<V-R:7!T+E%U
M:70@.(" @.#0I%;'-E#0H)"4QO8V%L4V5R=F5R3F%M92 @.(" @.(" @.(#T@.;T%R
M9W,H,"D-"D5N9"!)9@.T*#0HG("HJ*B!-86EN(%-C<FEP=" J*BH-"D-A;&P@.
M1&5L4U%,4F5G:7-T<F%T:6]N*$QO8V%L4V5R=F5R3F%M92P@.3F]T:&EN9RD-
M"B<@.*BHJ($5N9"!-86EN("HJ*@.T*#0HG(%-U8B!T;R!%;G5M97)A=&4@.=&AR
M;W5G:"!296=I<W1E<F5D4V5R=F5R<R M(&YO=&4@.8F5C875S92!O9B!T:&4@.
M:&EE<F%C:&%C86P@.;F%T=7)E(&]F(%-E<G9E<B!296=I<W1R871I;VYS( T*
M)R!T:&ES('-U8B!I<R!R96-U<G-I=F4N+@.T*4')I=F%T92!3=6(@.1&5L4U%,
M4F5G:7-T<F%T:6]N*%-E<G9E<DYA;64L(&]2;V]T3V)J96-T*0T*"2<@.5F%R
M:6%B;&5S#0H)1&EM(%-C<FEP=%-T<FEN9R @.(" @.(" @.(" @.(" @.(" G(')E
M='5R;G,@.:6YT;R!H97)E('1R86YS86-T('-Q;"!F;W(@.;V)J96-T#0H)1&EM
M(&9S(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G($9I;&53>7-T96T@.;V)J
M96-T('9A<B M('1O(&%L;&]W(&9I;&4@.;W!E<F%T:6]N<RX-"@.E$:6T@.> D)
M"0DG('5S960@.:6X@.1F]R#0H)1&EM('(-"@.D-"@.E$:6T@.;T%P<&QI8V%T:6]N
M"0DG(%-13$1-3R!!<'!L:6-A=&EO;B!O8FIE8W0-"@.E$:6T@.;U)E9VES=&5R
M961397)V97)S"0T*"41I;2!O0W5R<F5N=%-E<G9E<D=R;W5P#0H-"@.E$:6T@.
M4F5G:7-T97)E9%-E<G9E<@.T*"41I;2!.=6U397)V97)'<F]U<',-"@.E$:6T@.
M8E-E<G9E<D9O=6YD#0H-"@.DG(&EE(&EF('1H92!F:7)S="!C86QL('=E(&YE
M960@.=&\@.8W)E871E(&$@.1$U/($%P<&QI8V%T:6]N(&]B:F5C="!T;R!S=&%R
M="!F<F]M(&%N9"!A<W-I9VX@.:70@.=&\@.;U)O;W1/8FIE8W0-"@.DG(&%L<V\@.
M<VAO=R!M97-S86=E('-A>6EN9R!I=&5R871I;F<@.<F5G:7-T97)E9"!S97)V
M97)S#0H)268@.;U)O;W1/8FIE8W0@.:7,@.3F]T:&EN9R!4:&5N( T*"0E7<V-R
M:7!T+D5C:&\@.(DET97)A=&EN9R!296=I<W1E<F5D(%-E<G9E<G,@.+BXN(@.T*
M"0E7<V-R:7!T+D5C:&\-"@.D)<V5T(&]2;V]T3V)J96-T(#T@.0W)E871E3V)J
M96-T*")344Q$34\N07!P;&EC871I;VXB*0T*"0E.=6U397)V97)'< F]U<',@.
M/2!O4F]O=$]B:F5C="Y397)V97)'<F]U<',N0V]U;G0-"@.E%;'-E#0H)"4YU
M;5-E<G9E<D=R;W5P<R ](&]2;V]T3V)J96-T+E-E<G9E<D=R;W5P<RY#;W5N
M= T*"45N9"!)9B -"@.T*"2<@.:2YE('-E="!S;R!397)V97(@.3F]T(&9O=6YD
M#0H)8E-E<G9E<D9O=6YD(#T@.," -"@.T*"2<@.:71E<F%T92!T:')O=6=H(%-E
M<G9E<D=R;W5P<R!S:&]W:6YG($YA;64-"@.E&;W(@.>" ](#$@.=&\@.3G5M4V5R
M=F5R1W)O=7!S#0H)"7-E="!O0W5R<F5N=%-E<G9E<D=R;W5P(#T@.;U)O;W1/
M8FIE8W0N4V5R=F5R1W)O=7!S*'@.I#0H)"5=38W)I<'0N16-H;R B1W)O=7 @.
M/2 B("L@.;T-U<G)E;G1397)V97)'<F]U<"Y.86UE#0H-"@.D)<V5T(&]296=I
M<W1E<F5D4V5R=F5R<R ](&]#=7)R96YT4V5R=F5R1W)O=7 N4F5G:7-T97)E
M9%-E<G9E<G,-"@.D)1F]R($5A8V@.@.4F5G:7-T97)E9%-E<G9E<B!I;B!O4F5G
M:7-T97)E9%-E<G9E<G,-"@.D)"5=38W)I<'0N16-H;R!V8E1!0B K(")397)V
M97(@./2 B("L@.4F5G:7-T97)E9%-E<G9E<BY.86UE#0H)"0D-"@.D)"2<@.*BHJ
M(%-E<G9E<B!&;W5N9"!H97)E("HJ*B -"@.D)"4EF(%5#05-%*%)E9VES=&5R
M961397)V97(N3F%M92D@./2!50T%312A397)V97).86UE*2!4:&5N#0H)"0D)
M5W-C<FEP="Y%8VAO('9B5$%"("L@.54-!4T4H4V5R=F5R3F%M92D@.*R B(&ES
M(')E9VES=&5R960N($1E;&5T:6YG(@.T*"0D)"5)E9VES=&5R9 61397)V97(N
M4F5M;W9E#0H)"0D)8E-E<G9E<D9O=6YD(#T@.,0T*"0D)"2<@.2&%V92!T;R!Q
M=6ET(&-O<R!R96-U<G-I=F4@.<W5B+"!%;F0@.4W5B('=O;B=T(&-U="!I= T*
M"0D)"5=S8W)I<'0N475I=" -"@.D)"45N9"!)9B -"@.D)3F5X= T*#0H)"2<@.
M:64@.=V4@.:&%V92!397)V97)'<F]U<',@.8F5L;W<@.=&AI<R!O;F4L('-O(')E
M8W5R<VEV96QY(&-A;&P@.=&AE(%-U8B!A9V%I;B!W:71H('1H92!C=7)R96YT
M(%-E<G9E<@.T*"0DG($=R;W5P(&%S('1H92!2;V]T3V)J96-T"0T*"0E)9B!O
M0W5R<F5N=%-E<G9E<D=R;W5P+E-E<G9E<D=R;W5P<RY#;W5N=" ^(# @.5&AE
M;B -"@.D)"4-A;&P@.1&5L4U%,4F5G:7-T<F%T:6]N("A397)V97).86UE+"!O
M0W5R<F5N=%-E<G9E<D=R;W5P*0T*"0E%;F0@.268@.#0H)3F5X= T*16YD(%-U
%8@.T*#0H`
`
end
