dbo.ADS_TIADSAccount

1     create   trigger ADS_TIADSAccount on ADSAccount  for Insert not for Replication as begin  if exists (select top 1 1 from inserted) goto start
2 return start: declare @GenProcID varchar(38) BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('')   if exists (select top 1 1 from inserted i join
3 ADSGroup g on i.UID_ADSGroupPrimary = g.UID_ADSGroup where g.IsITshopOnly = 1 ) begin raiserror( '#LDS#The definition of a group as "IsITshopOnly = 1" and simultaneous use as primary group is not allowed.|'
4, 18, 2) with nowait end   if exists (select top 1 1 from ADSOtherSID a join inserted d on a.ObjectSID = d.ObjectSID ) begin delete ADSOtherSID where objectSID
5 in (select ObjectSID from inserted ) and UID_ADSOtherSID not like 'ADS-%' end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
6 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uid_person as uid from inserted where uid_person > ' ' ) as x exec
7 QBM_PDBQueueInsert_Bulk 'ADS-K-PersonHasObject', @DBQueueElements_01    declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object
8, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.UID_ADSAccount as uid from inserted i where i.UID_ADSGroupPrimary > ' '
9  or i.UID_Person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_03  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
10 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 
11