exec sp_addlinkedserver 'YTD_SERVER_lnk','','SQLOLEDB','220.162.244.127'
exec sp_addlinkedsrvlogin 'YTD_SERVER_lnk','false',null,'admin','pwd'
select TradeId,Bargain_Code,Cust_LinkMan from YTD_SERVER_lnk.YTD_SERVER.dbo.V_A_Bargain where Cust_LinkMan<>''
转载于:https://www.cnblogs.com/xph/archive/2008/05/18/1202200.html