Handy techie note that I always forget:

Need to run a SQL Query across two MSSQL servers.

EXEC sp_addlinkedserver    @server='GM', @srvproduct='',
                                @provider='SQLOLEDB', 
                                @datasrc='Server Name',
				@catalog ='myDatabase'
EXEC sp_addlinkedsrvlogin 'GM', 'false', NULL, 'username', 'password'

--Sample Query--
SELECT
NUMBER,
DT_CREATED AS DATE_CREATED,
PRIORITY,
(SELECT COMPANY FROM GM.myDatabase.dbo.myTable WHERE ACCOUNTNO IN (SELECT TOP 1 ACCOUNTNO FROM GM.myDatabase.dbo.myTable WHERE Field1=(SELECT CUSTOMER_NUMBER FROM CUSTOMERS WHERE ID=ID_CUSTOMER))) AS COMPANY
FROM
MAIN_TABLE

Note: Don't use dashes, or weird characters(you know what I mean) in the alias you give the server ie. server-ftp