if not exists(select * from master.dbo.sysservers where srvname='srv_lnk6' and datasource='19.127.57.227') begin if exists(select * from master.dbo.sysservers where srvname='srv_lnk6') begin--IP的改变时删除注名 exec sp_droplinkedsrvlogin 'srv_lnk6',null exec sp_dropserver 'srv_lnk6' end exec sp_addlinkedserver 'srv_lnk6','','SQLOLEDB','19.127.57.227' end exec sp_addlinkedsrvlogin 'srv_lnk6','false',null,'sa','123456' exec('insert into srv_lnk6.trade.dbo.news(type,zllb,zt,zt_color,zt_b,nr)select ''3'',''2'',file_title,''#333333'',''1'',file_content from recfile where id={0}')