I want to know how are partitioned view implemented with sql server 7.0? Can I do horizontal partitioning in one server and update, insert, select the data (how should it be done?