dbo.QBM_TUAssembly_QBMEvent

1 create   trigger QBM_TUAssembly_QBMEvent on QBMEvent  for Update not for Replication as begin  declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext
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: if update(EventName
3) or update(UID_DialogTable) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select 'JobGen'
4, dbo.QBM_FGITableName(x.UID_DialogTable) , @GenProcID from ( select d.UID_DialogTable from deleted d join QBMEvent e on d.UID_QBMEvent = e.UID_QBMEvent
5 union select e.UID_DialogTable from deleted d join QBMEvent e on d.UID_QBMEvent = e.UID_QBMEvent ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-ScriptAssemblyReset'
6, @DBQueueElements_01 end if update(EventName) or update(UID_DialogTable) or update(DisplayName) begin exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset'
7, 'TypedWrappers', '#', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
8