Back to OIM Explorer

dbo.QER_TDOrgRoot

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on OrgRoot. Trigger parent table: OrgRoot

Source: sandbox-db sys.sql_modules

Source size: 544 characters

Interpretation

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

Relations

  • Trigger parent table: OrgRoot

Typed Edges

  • trigger on table OrgRoot Trigger parent table: OrgRoot
  • references source dbo.QBM_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_POrgRootAssignFill source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL34 lines
1CREATE trigger QER_TDOrgRoot2  ON OrgRoot FOR3DELETE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted)10    GOTO start11    RETURN start:12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted d15      JOIN QBMModuleDef f16        ON dbo.QBM_FCVGUIDToModuleOwner(d.UID_OrgRoot) = f.ModuleName AND f.ModuleName <> 'CCC')17    BEGIN18      RAISERROR('#LDS#Default roles cannot be deleted.|',19      18,20      2)21        WITH nowait22    END23    EXEC QER_POrgRootAssignFill24  END TRY25  BEGIN CATCH26    EXEC QBM_PSessionErrorAdd DEFAULT27    RAISERROR('',28    18,29    1)30      WITH NOWAIT31  END CATCH32  ende:33  RETURN34END
Open raw exported source
SQL ยท Raw5 lines
1create   trigger QER_TDOrgRoot on OrgRoot  for Delete not for Replication as begin  BEGIN TRY if exists (select top 1 1 from deleted) goto start2 return start:  if exists(select top 1 1 from deleted d join QBMModuleDef f on dbo.QBM_FCVGUIDToModuleOwner(d.UID_OrgRoot) = f.ModuleName and f.ModuleName3 <> 'CCC' ) begin  raiserror('#LDS#Default roles cannot be deleted.|', 18, 2) with nowait end  exec QER_POrgRootAssignFill END TRY BEGIN CATCH exec QBM_PSessionErrorAdd4 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 5