dbo.QBM_TUQBMCEFDefinition

1create   trigger QBM_TUQBMCEFDefinition on QBMCEFDefinition  for Update not for Replication as begin  declare @SQLToCheck QBM_YParameterList declare
2 @GenProcID varchar(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted
3) goto start return start: if update(UID_DialogTable) or update(UID_DialogColumn) or update(EventClassID) or update(ActivityName) or update(LogSeverity
4) or update(MessageString) or update(Param01) or update(Param02) or update(Param03) or update(Param04) or update(Param05) or update(OperationType) or update
5(IsInActive) or update(WhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, dbo.QBM_FSQTriggerPartCEF(isnull(b.TableName
6, tv.TableName ), c.OperationType, 1) from inserted c  join DialogTable tv on c.UID_DialogTable = tv.UID_DialogTable left outer join DialogTable b on tv.UID_DialogTableBase
7 = b.UID_DialogTable exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01
8 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select isnull(b.TableName, tv.TableName ) as uid from inserted c  join DialogTable
9 tv on c.UID_DialogTable = tv.UID_DialogTable left outer join DialogTable b on tv.UID_DialogTableBase = b.UID_DialogTable union select isnull(b.TableName
10, tv.TableName ) as uid from deleted c  join DialogTable tv on c.UID_DialogTable = tv.UID_DialogTable left outer join DialogTable b on tv.UID_DialogTableBase
11 = b.UID_DialogTable ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger', @DBQueueElements_01 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
12 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
13