Saturday, February 25, 2012

Registering servers in Enterprise Manager.

Is there any way I can reload the list of servers I
registered through Enterprise Manager, so that I don't
have to register them manually. I have approx. 80 servers
registered with Enterprise manager on my old workstation
and now I want them on my new workstation.
Or to put this question otherway: where does enterprise
manager store the information of servers registered with
it?
Any suggestions welcome. Thanks. -- Adi ..you can use
sp_addlinkedserver (parms)
in the query analyzer
"Adi" <adibazz_nospam@.hotmail.com> wrote in message
news:6caf01c35867$6610d200$a001280a@.phx.gbl...
> Is there any way I can reload the list of servers I
> registered through Enterprise Manager, so that I don't
> have to register them manually. I have approx. 80 servers
> registered with Enterprise manager on my old workstation
> and now I want them on my new workstation.
> Or to put this question otherway: where does enterprise
> manager store the information of servers registered with
> it?
> Any suggestions welcome. Thanks. -- Adi ..|||What do you use to manage these 80 servers please. I will
like to know.
Thanks,
Aboki.
>--Original Message--
>Is there any way I can reload the list of servers I
>registered through Enterprise Manager, so that I don't
>have to register them manually. I have approx. 80 servers
>registered with Enterprise manager on my old workstation
>and now I want them on my new workstation.
>Or to put this question otherway: where does enterprise
>manager store the information of servers registered with
>it?
>Any suggestions welcome. Thanks. -- Adi ..
>.
>|||Thanks for your reply but I am talking here for
registering the server (and that through Enterprise
Manager). -- Adi ..
>--Original Message--
>you can use
>sp_addlinkedserver (parms)
>in the query analyzer
>"Adi" <adibazz_nospam@.hotmail.com> wrote in message
>news:6caf01c35867$6610d200$a001280a@.phx.gbl...
>> Is there any way I can reload the list of servers I
>> registered through Enterprise Manager, so that I don't
>> have to register them manually. I have approx. 80
servers
>> registered with Enterprise manager on my old workstation
>> and now I want them on my new workstation.
>> Or to put this question otherway: where does enterprise
>> manager store the information of servers registered with
>> it?
>> Any suggestions welcome. Thanks. -- Adi ..
>
>.
>|||if you want do batch mode then instead of using the enterprise manager you
use the query analyzer and use the Sp.
if you use the enterprise you need to do manually, one at a time.
"Adi." <adibazz_nospam@.hotmail.com> wrote in message
news:01d701c3586f$8b7e9a10$a601280a@.phx.gbl...
> Thanks for your reply but I am talking here for
> registering the server (and that through Enterprise
> Manager). -- Adi ..
> >--Original Message--
> >you can use
> >sp_addlinkedserver (parms)
> >
> >in the query analyzer
> >
> >"Adi" <adibazz_nospam@.hotmail.com> wrote in message
> >news:6caf01c35867$6610d200$a001280a@.phx.gbl...
> >> Is there any way I can reload the list of servers I
> >> registered through Enterprise Manager, so that I don't
> >> have to register them manually. I have approx. 80
> servers
> >> registered with Enterprise manager on my old workstation
> >> and now I want them on my new workstation.
> >>
> >> Or to put this question otherway: where does enterprise
> >> manager store the information of servers registered with
> >> it?
> >>
> >> Any suggestions welcome. Thanks. -- Adi ..
> >
> >
> >.
> >

No comments:

Post a Comment