跨数据库触发,帮忙看看,在线等待!

create trigger AddCardinf on carinfo after insert as  begin
declare @Car_number   nvarchar(20)
  declare @time_add datetime
  declare @time_up datetime
declare @car_picp varchar(100)
declare @car_picc varchar(100)
declare curUpdated  cursor for select inserted.car_number,car_addtime,car_uptime,car_ppic,car_cpic from inserted
open curUpdated
fetch curUpdated  into @Car_number,@time_add,@time_up,@car_picp,@car_picc
while @@FETCH_STATUS=0
begin
exec   sp_addlinkedserver     'server_lnk_test','','SQLOLEDB','10.0.0.198'--点可以换做IP   
                                exec   sp_addlinkedsrvlogin   'server_lnk_test','false',null,'sa','sa'   
                                exec   sp_serveroption   'server_lnk_test','rpc out','true' --                                exec ('insert into server_lnk_test.Carinfo.dbo.Carinfcollect set car_number='+@Car_number+',car_addtime ='+@time_add+',car_uptime='+@time_up+',car_ppic='+@car_picp+',car_cpic='+@car_picc+',ip='+convert(varchar(50),'10.0.0.34'))
                                exec sp_droplinkedsrvlogin 'server_lnk_test',null
                                exec  sp_dropserver 'server_lnk_test',null  
fetch curUpdated  into @Car_number,@time_add,@time_up,@car_picp,@car_picc
end
close curUpdated
deallocate curUpdated
--print @strInsert
end