I m using Asp.net 2.0 as front end & sql server2005 as back end.
I want to do following program on 3 pc.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 executed.

....This query should be executed inside the context of the Server and not as a query that goes out and looks for 3 different PC's to query the server on that machine.

Your 3 pc's should be syncing their copies of the database back to the server so that the server contains the "offical" copy of a record.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========