SQL Server 7 should be capable of implementing read-only partitioned views. Create a linked server for each server that you want to pull data from. Then create a view that UNIONS the tables from each server:

SELECT a,b,c FROM server1.db1.dbo.table
UNION
SELECT a,b,c FROM server2.db1.dbo.table

I believe that the biggest issue will be that the query optimizer does not know how to optimize partitioned views. You should do some tests to see if a remote query is submitted to some of the servers even if no data needs to be retrieved from the server.

-Mike