dbo.ATT_TUAttestationObject

1   create   trigger ATT_TUAttestationObject on AttestationObject for Update not for Replication as begin  declare @ConditionsToCheck QBM_YParameterList
2 BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar
3(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(UID_DialogTable) begin  if exists (select top 1 1 from inserted i left outer join DialogColumn
4 c on i.UID_DialogTable = c.UID_DialogTable and c.ColumnName = 'XObjectKey' where c.columnname is null ) begin  raiserror( '#LDS#Non-valid table selected (no XObjectKey exists).|'
5, 18, 2) with nowait end end  if update(PreProcessorCondition) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from 
6inserted i exec QBM_PPrePropCheckSyntax @ConditionsToCheck  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject
7, genprocid) select x.uid, null, @GenProcID from ( select ao.UID_AttestationObject as uid from deleted i join AttestationObject ao on ao.UID_AttestationObject
8 = i.UID_AttestationObject where isnull(i.PreProcessorCondition, N'') <> isnull(ao.PreProcessorCondition, N'') ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-PrepropAttestationObject'
9, @DBQueueElements_01 end  if update(IsDeactivatedByPreProcessor) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object
10, subobject, genprocid) select x.uid, null, @GenProcID from ( select wp.UID_AttestationWizardParm as uid from deleted i join AttestationObject ao on ao.UID_AttestationObject
11 = i.UID_AttestationObject join AttestationWizardParm wp on wp.UID_AttestationObject = i.UID_AttestationObject where i.IsDeactivatedByPreProcessor <> ao.IsDeactivatedByPreProcessor
12 ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-PrepropAttestationWizardParm', @DBQueueElements_02 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default
13 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
14