dbo.QBM_TIAssembly_DialogColumn

1   create   trigger QBM_TIAssembly_DialogColumn on DialogColumn  for Insert 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 return start: if exists (select top 1 1 from inserted i join dialogtable t on i.UID_DialogTable
3 = t.UID_DialogTable where t.TableType in ('T', 'V') and i.Template > ' ' ) begin  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'Tmpl', 
4'#', @genProcID  end  exec QBM_PDBQueueInsert_Single 'QBM-K-ScriptAssemblyReset', 'TypedWrappers', '#', @GenProcID  declare @DBQueueElements_01 QBM_YDBQueueRaw
5 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_DialogTable as UID from inserted i union
6 select t.UID_DialogTableBase from inserted i join dialogtable t on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union select
7 t.UID_DialogTableUnion from inserted i join dialogtable t on i.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableUnion > ' ' ) as x exec QBM_PDBQueueInsert_Bulk
8 'QBM-K-CommonRebuildView', @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid
9) select x.uid, null, @GenProcID from (select dbo.QBM_FGITableName(i.UID_DialogTable) as UID from inserted i union select dbo.QBM_FGITableName(t.UID_DialogTableBase
10) from dialogtable t join inserted c on c.UID_DialogTable = t.UID_DialogTable where t.UID_DialogTableBase > ' ' union  select dbo.QBM_FGITableName(t.UID_DialogTable
11) from dialogtable t join inserted c on c.UID_DialogTable = t.UID_DialogTableUnion  ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeWatchtrigger',
12 @DBQueueElements_02 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITrigger', @DBQueueElements_02  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default
13 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
14