dbo.RPS_TIRPSSubscription

1  create   trigger RPS_TIRPSSubscription on RPSSubscription  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted
2) goto start return start:  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if exists (select top 1 1 from inserted i 
3join RPSSubscription s on i.UID_RPSSubscription = s.UID_RPSSubscription left outer join PersonHasRPSReport t on t.uid_RPSReport = s.UID_RPSReport and t.UID_Person
4 = s.UID_Person and t.XOrigin > 0  where t.uid_person is null  ) begin raiserror ('#LDS#Assignment is not permitted due to missing combination of person and report.|'
5, 18, 2) with nowait end  declare @DBQueueElements_PHO QBM_YDBQueueRaw insert into @DBQueueElements_PHO (object, subobject, genprocid) select x.uid, null
6, @GenProcID from ( select distinct i.UID_Person as uid from inserted i ) as x exec QBM_PDBQueueInsert_Bulk 'RPS-K-PersonHasObject', @DBQueueElements_PHO
7  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
8