Back to OIM Explorer

dbo.QER_TDDialogProcess

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogProcess. Trigger parent table: DialogProcess

Source: sandbox-db sys.sql_modules

Source size: 548 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: DialogProcess

Typed Edges

  • trigger on table DialogProcess Trigger parent table: DialogProcess
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL31 lines
1CREATE trigger QER_TDDialogProcess2  ON DialogProcess FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @Xdate datetime = getutcdate()8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM deleted)12    GOTO start13    RETURN start:14    UPDATE PersonWantsOrg15    SET GenProcID = NULL,16    XDateUpdated = @Xdate,17    XUserUpdated = @XUser18    FROM PersonWantsOrg pwo19    JOIN deleted p20      ON pwo.GenProcID = p.GenProcID21  END TRY22  BEGIN CATCH23    EXEC QBM_PSessionErrorAdd DEFAULT24    RAISERROR('',25    18,26    1)27      WITH NOWAIT28  END CATCH29  ende:30  RETURN31END
Open raw exported source
SQL ยท Raw5 lines
1  create   trigger QER_TDDialogProcess on DialogProcess  for delete not for Replication as begin declare @XUser nvarchar(64) = object_name(@@procid2) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: update PersonWantsOrg set GenProcID3 = null  , XDateUpdated = @Xdate , XUserUpdated = @XUser from PersonWantsOrg pwo join deleted p on pwo.GenProcID = p.GenProcID END TRY BEGIN CATCH exec4 QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 5