dbo.TSB_TIUNSGroupB2InUNSGroupB2

1  create   trigger TSB_TIUNSGroupB2InUNSGroupB2 on UNSGroupB2InUNSGroupB2  for Insert not for Replication as begin  if exists (select top
2 1 1 from inserted) goto start return start: BEGIN TRY  if exists (select top 1 1 from inserted i join UNSGroupB2 g on i.UID_UNSGroupB2Child = g.UID_UNSGroupB2
3 join UNSGroupB2 u on i.UID_UNSGroupB2Parent = u.UID_UNSGroupB2 join UNSRootB ru on u.UID_UNSRootB = ru.UID_UNSRootB join DPRNameSpace ns on ru.UID_DPRNameSpace
4 = ns.UID_DPRNameSpace join UNSRootB rg on g.UID_UNSRootB = rg.UID_UNSRootB where 0 = case when u.UID_UNSRootB = g.UID_UNSRootB then 1  when ns.IsExtendedInheritance
5 = 0 then 0 when ns.IsExtendedInheritance = 1 and ns.UID_DPRNameSpace = rg.UID_DPRNameSpace then 1 else 0 end ) begin raiserror ('#LDS#Assignment is not permitted due to the configuration of related UNSRoots.|'
6, 18, 2) with nowait end  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw 
7insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_UNSGroupB2Parent as uid from inserted
8 union select UID_UNSGroupB2Child from inserted union  select co.uid_UNSGroupB2Parent as uid from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Child
9 = co.UID_UNSGroupB2Child  union select co.uid_UNSGroupB2Parent from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Child
10  union select co.UID_UNSGroupB2Child from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Child = co.UID_UNSGroupB2Parent  union select
11 co.UID_UNSGroupB2Child from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Parent ) as x exec QBM_PDBQueueInsert_Bulk
12 'TSB-K-UNSGroupB2InUNSGroupB2', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH
13 ende: return end 
14