Linked server

Hi
I want to use the linked server. Can anyone write me the
step by step method to configure the Linked server.
Scenario:
PC1:
Server Name :DBServer1
DB Name : Customer (MS SQL 2000)
userid: guest
Pwd: guest
PC2:
Server Name :DBServer2
DB Name : Vendors (MS SQL 2000)
userid: guest
Pwd: guest
1. When I use th Enterprise Manager what are the settings
to be done in PC1 and PC2 for configuring the Linked
server.
2. Any pointer for the good web site ..?
3. Also is there a way that I can avoid using the four
part name like
linked_server_name.catalog.schema.object_name using any
global variable or namespace kind of thing....'?
Please help...
Thanks in advance.
Anand.Hi Hari
Can you send it to gurusanand1@.sifymail.com and not to the
news group.
B'coz till now I can't find your attachment.
Thanks in advance.
Anand.
>--Original Message--
>Hi Anand,
>Attached the step by step method to configure linked
server.
>Thanks
>Hari - MCDBA
>US Software
>Trivandrum
>
>"Anand" <gurusanand1@.sifymail.com> wrote in message
>news:0b6501c3567f$a691e380$a101280a@.phx.gbl...
>> Hi
>> I want to use the linked server. Can anyone write me the
>> step by step method to configure the Linked server.
>> Scenario:
>> PC1:
>> Server Name :DBServer1
>> DB Name : Customer (MS SQL 2000)
>> userid: guest
>> Pwd: guest
>> PC2:
>> Server Name :DBServer2
>> DB Name : Vendors (MS SQL 2000)
>> userid: guest
>> Pwd: guest
>> 1. When I use th Enterprise Manager what are the
settings
>> to be done in PC1 and PC2 for configuring the Linked
>> server.
>> 2. Any pointer for the good web site ..?
>> 3. Also is there a way that I can avoid using the four
>> part name like
>> linked_server_name.catalog.schema.object_name using any
>> global variable or namespace kind of thing....'?
>>
>> Please help...
>> Thanks in advance.
>> Anand.
>>
>
>