dbo.RMS_TDESetExcludesESet

1CREATE trigger RMS_TDESetExcludesESet2  ON ESetExcludesESet FOR3DELETE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw15    INSERT INTO @DBQueueElements_01(object,16    subobject,17    genprocid)18    SELECT19      x.uid,20      NULL,21      @GenProcID22    FROM(23    SELECT24      DISTINCT uig.UID_Person AS uid25    FROM(26    SELECT UID_ESet AS UID_ESet27    FROM deleted28    UNION all29    SELECT UID_ESetExcluded30    FROM deleted) AS y31    JOIN PersonHasEset uig32      ON y.UID_ESet = uig.UID_ESet) AS x33    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet',34      @DBQueueElements_0135    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw36    INSERT INTO @DBQueueElements_02(object,37    subobject,38    genprocid)39    SELECT40      x.uid,41      NULL,42      @GenProcID43    FROM(44    SELECT45      DISTINCT uig.UID_Org AS uid46    FROM(47    SELECT UID_ESet AS UID_ESet48    FROM deleted49    UNION all50    SELECT UID_ESetExcluded51    FROM deleted) AS y52    JOIN BaseTreeHasEset uig53      ON y.UID_ESet = uig.UID_ESet) AS x54    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet',55      @DBQueueElements_0256    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw57    INSERT INTO @DBQueueElements_03(object,58    subobject,59    genprocid)60    SELECT61      x.uid,62      NULL,63      @GenProcID64    FROM(65    SELECT66      DISTINCT uig.UID_WorkDesk AS uid67    FROM(68    SELECT UID_ESet AS UID_ESet69    FROM deleted70    UNION all71    SELECT UID_ESetExcluded72    FROM deleted) AS y73    JOIN WorkDeskHasESet uig74      ON y.UID_ESet = uig.UID_ESet) AS x75    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet',76      @DBQueueElements_0377    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw78    INSERT INTO @DBQueueElements_04(object,79    subobject,80    genprocid)81    SELECT82      x.uid,83      NULL,84      @GenProcID85    FROM(86    SELECT uig.UID_ESet AS uid87    FROM(88    SELECT UID_ESet AS UID_ESet89    FROM deleted90    UNION all91    SELECT UID_ESetExcluded92    FROM deleted) AS y93    JOIN ESetHasEntitlement uig94      ON y.UID_ESet = uig.UID_ESet95    UNION96    SELECT97      DISTINCT uig.UID_ESet AS uid98    FROM(99    SELECT UID_ESet AS UID_ESet100    FROM deleted101    UNION all102    SELECT UID_ESetExcluded103    FROM deleted) AS y104    JOIN Eset z105      ON y.UID_ESet = z.UID_ESet106    JOIN ESetHasEntitlement uig107      ON z.XObjectKey = uig.Entitlement) AS x108    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement',109      @DBQueueElements_04110  END TRY111  BEGIN CATCH112    EXEC QBM_PSessionErrorAdd DEFAULT113    RAISERROR('',114    18,115    1)116      WITH NOWAIT117  END CATCH118  ende:119  RETURN120END