var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: 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.