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...?
Regards,
Mark A Tonks
Senior E-Business Developer
Halifax plc