Querying external server without adding it as linked server

One of the members in the SQL Server forum asked a question about querying the remote server without actually adding it as a Linked Server. One of the options to do this is to make use of the OPENDATASOURCE function Assume that you have two servers Server1 and Server2. You want to query a table from...