存储过程和触发器要使用链接服务器时要注意的一点

set XACT_ABORT on

if exists(select 1 from sysobjects where name = 'tr_update_pis_ishavepic' and type ='tr')
 drop trigger tr_update_pis_ishavepic
GO
create trigger tr_update_pis_ishavepic
on PicRelationship
for insert
AS
 set XACT_ABORT on
 declare @sysid int
 --set @sysid = 3
 declare @itemid varchar(20)
 select @itemid = CorrelativeItemId,@sysid = RelationSystemId from inserted
 if @sysid = 3
  update SZDB2.PIS.dbo.tb_brm_estate set ishave_pic = 1 where est_id = @itemid
GO