mssql两台服务器跨库

-- 创建链接服务器示例
EXEC sp_addlinkedserver
    @server='LinkedServerName',
    @srvproduct='',
    @provider='SQLNCLI',
    @datasrc='RemoteServerName';

-- 跨库查询示例
SELECT *
FROM LinkedServerName.DatabaseName.SchemaName.TableName;

-- 配置复制示例
EXEC sp_addpublication
    @publication='PublicationName',
    @description='Description of the publication',
    @sync_method='native',
    @retention=0,
    @allow_push=1,
    @allow_pull=0,
    @allow_anonymous=0,
    @enabled_for_internet=0,
    @snapshot_in_defaultfolder=1,
    @compress_snapshot=0,
    @ftp_port=21,
    @ftp_login='anonymous',
    @allow_subscription_copy=0,
    @add_to_active_directory=0,
    @repl_freq='continuous',
    @status= N'active',
    @independent_agent=1,
    @immediate_sync=1,
    @allow_sync_tran=1,
    @autogen_sync_procs=0,
    @allow_queued_tran=0,
    @allow_dts=0,
    @replicate_ddl=0,
    @allow_initialize_from_backup=0,
    @enabled_for_p2p=0,
    @enabled_for_het_sub=0;