sqlserver 跨服务器连接查询

exec sp_addlinkedserver @server= 'paydb', @srvproduct= '',  
@provider='SQLNCLI', @datasrc = '192.168.0.123SQLEXPRESS' --登录链接服务器  
exec sp_addlinkedsrvlogin @rmtsrvname = 'paydb',  
@useself = 'false ', @locallogin = null,  
@rmtuser ='sa', @rmtpassword = '123456'

调用方式：
select * from paydb.[dbname].dbo.[tablename]