dbo.QBM_PTriggersInactiveForTable

1    create   procedure QBM_PTriggersInactiveForTable ( @TableName varchar(30) , @EventName varchar(16) ) as begin declare @GenProcID varchar(38)
2 declare @XUser nvarchar(64) declare @DisabledValue bit = 1 declare @DebugSwitch int = 0 SET XACT_ABORT OFF BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext
3('') select @XUser = dbo.QBM_FGISessionContext('XUser') if @DebugSwitch > 0 begin print 'proc: QBM_PTriggersInactiveForTable, event ' + isnull(@EventName
4, '<none>') end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject, GenProcID) select distinct left(tr.name,
5 30) as Triggername, null, @GenProcID        from DialogTable t with (readpast) join sys.tables st on st.name = case t.TableType when 'V' then dbo.QBM_FGITableName
6(t.UID_DialogTableBase) when 'M' then '#'  else t.TableName end and t.TableName = @TableName join sys.triggers tr on tr.parent_id = st.object_id and tr.is_disabled
7 = @DisabledValue  and tr.name not like 'GEN[_]%' and tr.name != 'QBM_TUIndicator474488' join sys.trigger_events ev on ev.object_id = tr.object_id and 
8ev.type_desc = @EventName  where t.TableName not in (select s.TableName from QBM_VStartupTables s ) if @DebugSwitch > 0 begin print 'detected triggernames'
9 select e.Object from @DBQueueElements_01 e end if exists (select top 1 1 from @DBQueueElements_01  ) and exists (select top 1 1 from sys.procedures p 
10where p.name = 'QBM_PDBQueueInsert_Bulk'  ) begin exec QBM_PDBQueueInsert_Bulk 'QBM-K-TaskForInactiveTrigger', @DBQueueElements_01 end END TRY BEGIN CATCH
11 exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH 
12end 
13