Exec sp_addlinkedServer '[ServerName]', '', 'SQLOLEDB', '[IP]'
EXEC SP_SERVEROPTION '[ServerName]', 'RPC Out', 'True'
EXEC SP_SERVEROPTION '[ServerName]', 'RPC', 'True'
EXEC SP_ADDLINKEDSRVLOGIN '[ServerName]', 'false', null, '[id]', '[pwd]'
A relatively easy implementation of information synchronization between databases
