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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment