Ramesh,

You can also use opendatasource to query remote servers. try that if u need it only for the hour else go for linked servers for permanent solution.