Monday, February 20, 2012

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.

No comments:

Post a Comment