newbiw - linking to another SS2K datbase

[MrPeds]

dear forum,

I am a newbie to SQL Server 2k admin, although i have some knowledge of SS2K from a development viewpoint, e.g. SQL, stored procedures, creasting and ammending tables and so on.

Could anybody tell me how i set up a link to another SQL Server 2K on the network?

all i want to be able to do is get read only access to some other 2k servers on our network, so i can create select queries, and possibly create some scheduled tasks to extract information from them.

I guess that i need to have permissions set up on the other servers to allow my Server to point at them.

i am not sure what to do after this. i essence i want to be able to look at tables, views, and so on of the other servers just like looking at my own databases on my server in Enterprise manager. i know this is possible but not sure how to proceed.

thanks in advance,

MrPeds

 

[SQLBill]

First you need access to the other servers and databases. Then in your SQL Server Enterprise Manager, you just need to REGISTER the SQL Servers.

-SQLBill