How to Run a Query on a Remote SQL Server?
Use the OpenRowSet Function to Run a Query on a Remote SQL Server.