I m using Asp.net 2.0 as front end & sql server2005 as back end.
I want to do following program on 3 pc which are connected in network .Suppose there is table named student contains attributes as id,name,city & this table contains 100 rows. But this table is horizantally fragmented means 40 rows of which are on pc1,40 rows of which are on pc2 & 20 rows of which are on pc3.If i execute query e.g select * from student on any of the pc then i should get all the 100 rows of student table on which query is execute.Also i want to know remote query processing in sql server.