You didn't specify whether you were using SQL Server 6.5 or 7.0. I'm going to assume 7.0.
Retrieving the data is easy. On A create a linked-servers represent servers B and C. Now you can refer to all three servers in the same query. For instance:
SELECT * FROM a.pubs.dbo.authors
UNION
SELECT * FROM b.pubs.dbo.authors
UNION
SELECT * FROM c.pubs.dbo.authors
You'll even be able to join table from the different servers:
SELECT a.au_lname, b.au_lname
FROM a.pubs.dbo.authors a INNER JOIN b.pubs.dbo.authors b
ON a.au_id = b.au_id
For the changes, I would catch them and actually make the changes on the appropriate servers using distributed transactions and stored procedures.
-Mike
>We have three SQL Data Servers A, B and C. I want to write a SQL procedure that will PULL data from B and C servers and write it on a table in Server A. The table layout is same across the servers. The user will update the data in Server A and PUSH the updated data back to Servers B and C.
>
>How do I acheive the above ?
>All the three Servers are on the Network.