I have two databases that reside on different servers. I need to run a query that takes information from both databases and produces a results set summarising the two.

Is it possible to construct a query that spans two servers? I cannot find anything in Technet or on MS technical support.

I know that I could replicate one database to the other server, but these are 3GB databases and I don't want to use up that much space for the sake of the occasional query.

Any ideas...?