Showing posts with label bear. Show all posts
Showing posts with label bear. Show all posts

Sunday, February 19, 2012

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?