var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Accessing tables in another server!
hi this might seem simple to all the techies out there but pls bear with me cos i am a novice to SQL Server 2000.
Q: Is it possible to create a trigger on a table in a current server(For eg. Server1) that can select/insert/delete/update a table in ANOTHER SERVER(Server2)?
I was exploring options of using a distributed partitioned view but i am still very much lost...
Use a linked server. See BOL for details.
If i used a linked server is a distributed partitioned view still necessary? can i just use a four-part-name in my queries to modify data? eg. servername.dbname.dbo.tablename
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?Can i also insert to those databases?