dbo.QER_TIHardware

1    create   trigger QER_TIHardware on Hardware  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto
2 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')   if exists(select top 1 1 from inserted i join Hardwaretype
3 p on i.UID_Hardwaretype = p.UID_Hardwaretype and p.isInactive = 1 ) begin  raiserror( '#LDS#Assignment cannot take place, because the device type is disabled.|'
4, 18, 2) with nowait end if dbo.QBM_FGIColumnUpdatedOthers ('Hardware', 'XTouched', columns_updated()) = 1 begin   declare @maxAnzahl int select @maxAnzahl
5 = 100 if 100 < (select count(*) from inserted) begin select top 1 @maxAnzahl = ( (Count(*)) /10 + 1) from Hardware end else begin select @maxAnzahl = 
61073741824  end end declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID
7 from ( select inserted.uid_Hardware as uid from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-HelperHardwareOrg', @DBQueueElements_02   END TRY 
8BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
9