Create linked server (SQL server) (A very simple way to create linked server)

    EXEC sp_addlinkedserver  

    @server='destinationServerName',

    @srvproduct='',

    @provider='SQLNCLI',

    @datasrc='tcp:destinationServerIpAddress,1433'

EXEC sp_addlinkedsrvlogin

    @useself='FALSE',

    @rmtsrvname=''destinationServerName',

    @rmtuser='username',

    @rmtpassword='password'