linked server

I want to be able to access/modify/insert to a table which is in another server.

Can someone just list out the steps briefly for me? Or just tell me if i am right..

1. create linked server(eg.server2) (I have done that)

2. create distributed views on server1

-creating the distributed views i understand that i can use OPENDATASOURCE or OPENROWSET or just a four-partname right?

After creating the distributed views can i use a four-part name to make references to the remote databases?You don't need to create views. If the mapped user has permission then

select * from lnksrvr.dbname.owner.tablename

You can test on a single server by creating a linked server pointing to itself.

linked server

Is there any site that shows me steps how to add linked server in Enterprise manager?

check out sp_addlinkedserver in books on line.

In SQL 2005, in the Object Explorer, right-click Server Objects, select New, and select Linked Server.

|||

Thanks for the reply. Can you give me example of sp_addlinkedserver for SQL 2000, I do not know what parameters are mandatory, it is complex to me. Is this the only one I need to run?

|||

There are a few parameters you need to pass like provider name, datasource.etc. Please check the documentation.

|||

Hi Dinakar,

Thanks for your reply. I am completely new on the SQL Server. I need to get this done very soon. I

executed:

EXEC sp_addlinkedserver 'aNewName', N'SQL Server'

in my local computer, when I clicked tables under created linked server aNewName, it gives me "no permission". I am actually trying to create a link in my computer to a SQL Server in the network. I used the command above but the command did not specify which server I want to connect. What am I missing?

|||Thanks I figured out this.