You can use the OPENROWSET( ) function to run a query on a remote SQL server by using the following syntax:
SELECT *FROM OPENROWSET('SQLOLEDB', 'remote_server_name'; 'sa'; 'password','SQL statement')
Here replace ‘remote_server_name’ with the name of the remote server on which you want to run the query. If necessary, replace ‘sa’ and ‘password’ with the name and password of a SQL login ID you want to use to log in to the remote server. Finally, replace ‘SQL statement’ with the SQL statement you want to run on the remote server.