Back to OIM Explorer

dbo.QBM_TDDialogScriptAssembly

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogScriptAssembly. Trigger parent table: DialogScriptAssembly

Source: sandbox-db sys.sql_modules

Source size: 566 characters

Interpretation

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

Relations

  • Trigger parent table: DialogScriptAssembly

Typed Edges

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL31 lines
1CREATE trigger QBM_TDDialogScriptAssembly2  ON DialogScriptAssembly FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @xdate datetime = getutcdate()7  DECLARE @XUser nvarchar(64)8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM deleted)12    GOTO start13    RETURN start:14    SELECT @xuser = dbo.QBM_FGISessionContext('XUser')15    UPDATE dialogSemaphor16    SET ChangeCounter = ChangeCounter +1,17    XDateUpdated = @XDate,18    XUserUpdated = @XUser19    WHERE20      ChangeContext = 'ASSEMBLY'21  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 QBM_TDDialogScriptAssembly on DialogScriptAssembly  for Delete not for Replication as begin declare @xdate datetime = getutcdate2() declare @XUser nvarchar(64) BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: select @xuser = dbo.QBM_FGISessionContext('XUser'3) update dialogSemaphor set ChangeCounter = ChangeCounter +1 , XDateUpdated = @XDate , XUserUpdated = @XUser where ChangeContext = 'ASSEMBLY' END TRY BEGIN4 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 5