dbo.TSB_TUDPRNameSpace
SQL_TRIGGER parent DPRNameSpace
Created 2025-06-27T18:01:21.240 · modified 2026-04-14T23:23:08.220 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| No parameters. | ||
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| deleted | OBJECT_OR_COLUMN | ||
| DPRNameSpace | OBJECT_OR_COLUMN | ||
| inserted | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_Bulk | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YDBQueueRaw | TYPE | ||
| QBM_YParameterList | TYPE | ||
| UNSAccountB | OBJECT_OR_COLUMN | ||
| UNSAccountBHasUNSGroupB | OBJECT_OR_COLUMN | ||
| UNSAccountBHasUNSGroupB1 | OBJECT_OR_COLUMN | ||
| UNSAccountBHasUNSGroupB2 | OBJECT_OR_COLUMN | ||
| UNSAccountBHasUNSGroupB3 | OBJECT_OR_COLUMN | ||
| UNSAccountBHasUNSItemB | OBJECT_OR_COLUMN | ||
| UNSAccountBInUNSGroupB | OBJECT_OR_COLUMN | ||
| UNSAccountBInUNSGroupB1 | OBJECT_OR_COLUMN | ||
| UNSAccountBInUNSGroupB2 | OBJECT_OR_COLUMN | ||
| UNSAccountBInUNSGroupB3 | OBJECT_OR_COLUMN | ||
| UNSGroupB | OBJECT_OR_COLUMN | ||
| UNSGroupB1 | OBJECT_OR_COLUMN | ||
| UNSGroupB2 | OBJECT_OR_COLUMN | ||
| UNSGroupB3 | OBJECT_OR_COLUMN | ||
| UNSGroupBHasUnsItemB | OBJECT_OR_COLUMN | ||
| UNSItemB | OBJECT_OR_COLUMN | ||
| UNSRootB | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create trigger TSB_TUDPRNameSpace on DPRNameSpace for Update not for Replication as begin if exists (select top 1 1 from inserted) goto start 2 if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext 3('') if not update(IsExtendedInheritance) begin goto naechsterTest end declare @AccountsFuerGroupB0 QBM_YParameterList declare @AccountsFuerGroupB1 QBM_YParameterList 4 declare @AccountsFuerGroupB2 QBM_YParameterList declare @AccountsFuerGroupB3 QBM_YParameterList declare @DBQueueElements_GroupB0 QBM_YDBQueueRaw declare 5 @DBQueueElements_GroupB1 QBM_YDBQueueRaw declare @DBQueueElements_GroupB2 QBM_YDBQueueRaw declare @DBQueueElements_GroupB3 QBM_YDBQueueRaw insert into 6 @AccountsFuerGroupB0(Parameter1) select distinct ac.UID_UNSAccountB from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join 7 UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSRootB r2 on r2.UID_DPRNameSpace = a.UID_DPRNameSpace and r.UID_UNSRootB <> r2.UID_UNSRootB 8 join UNSAccountB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) and r2.GroupUsageMask 9 & 0x01 > 0 insert into @AccountsFuerGroupB1(Parameter1) select distinct ac.UID_UNSAccountB from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = 10d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSRootB r2 on r2.UID_DPRNameSpace = a.UID_DPRNameSpace and r.UID_UNSRootB 11 <> r2.UID_UNSRootB join UNSAccountB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0 12) and r2.GroupUsageMask & 0x02 > 0 insert into @AccountsFuerGroupB2(Parameter1) select distinct ac.UID_UNSAccountB from DPRNameSpace a join deleted d on 13 a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSRootB r2 on r2.UID_DPRNameSpace = a.UID_DPRNameSpace 14 and r.UID_UNSRootB <> r2.UID_UNSRootB join UNSAccountB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance 15,0) and r2.GroupUsageMask & 0x04 > 0 insert into @AccountsFuerGroupB3(Parameter1) select distinct ac.UID_UNSAccountB from DPRNameSpace a join deleted d 16 on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSRootB r2 on r2.UID_DPRNameSpace = a.UID_DPRNameSpace 17 and r.UID_UNSRootB <> r2.UID_UNSRootB join UNSAccountB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance 18,0) and r2.GroupUsageMask & 0x08 > 0 insert into @AccountsFuerGroupB0(Parameter1) select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted 19d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x01 > 0 join UNSGroupB 20ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBInUNSGroupB aig on ac.UID_UNSGroupB = aig.UID_UNSGroupB where isnull(d.IsExtendedInheritance,0) 21<> isnull(a.IsExtendedInheritance,0) union select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace 22 join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x01 > 0 join UNSGroupB ac on r.UID_UNSRootB = ac.UID_UNSRootB join 23UNSAccountBHasUNSGroupB aig on ac.UID_UNSGroupB = aig.UID_UNSGroupB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) insert 24 into @AccountsFuerGroupB1(Parameter1) select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace 25 join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x02 > 0 join UNSGroupB1 ac on r.UID_UNSRootB = ac.UID_UNSRootB join 26 UNSAccountBInUNSGroupB1 aig on ac.UID_UNSGroupB1 = aig.UID_UNSGroupB1 where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) union 27 select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace 28 = a.UID_DPRNameSpace and r.GroupUsageMask & 0x02 > 0 join UNSGroupB1 ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBHasUNSGroupB1 aig on ac.UID_UNSGroupB1 29 = aig.UID_UNSGroupB1 where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) insert into @AccountsFuerGroupB2(Parameter1) select 30 aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace 31 and r.GroupUsageMask & 0x04 > 0 join UNSGroupB2 ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBInUNSGroupB2 aig on ac.UID_UNSGroupB2 = aig.UID_UNSGroupB2 32 where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) union select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted 33 d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x04 > 0 join UNSGroupB2 34 ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBHasUNSGroupB2 aig on ac.UID_UNSGroupB2 = aig.UID_UNSGroupB2 where isnull(d.IsExtendedInheritance 35,0) <> isnull(a.IsExtendedInheritance,0) insert into @AccountsFuerGroupB3(Parameter1) select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted 36 d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x08 > 0 join UNSGroupB3 37 ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBInUNSGroupB3 aig on ac.UID_UNSGroupB3 = aig.UID_UNSGroupB3 where isnull(d.IsExtendedInheritance 38,0) <> isnull(a.IsExtendedInheritance,0) union select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace 39 join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace and r.GroupUsageMask & 0x08 > 0 join UNSGroupB3 ac on r.UID_UNSRootB = ac.UID_UNSRootB join 40 UNSAccountBHasUNSGroupB3 aig on ac.UID_UNSGroupB3 = aig.UID_UNSGroupB3 where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) 41insert into @DBQueueElements_GroupB0 (object, subobject, genprocid) select distinct x.Parameter1, null, @GenProcID from @AccountsFuerGroupB0 x exec QBM_PDBQueueInsert_Bulk 42 'TSB-K-UNSAccountBInUNSGroupB', @DBQueueElements_GroupB0 insert into @DBQueueElements_GroupB1 (object, subobject, genprocid) select distinct x.Parameter1 43, null, @GenProcID from @AccountsFuerGroupB1 x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @DBQueueElements_GroupB1 insert into @DBQueueElements_GroupB2 44 (object, subobject, genprocid) select distinct x.Parameter1, null, @GenProcID from @AccountsFuerGroupB2 x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2' 45, @DBQueueElements_GroupB2 insert into @DBQueueElements_GroupB3 (object, subobject, genprocid) select distinct x.Parameter1, null, @GenProcID from @AccountsFuerGroupB3 46 x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @DBQueueElements_GroupB3 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 47 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ac.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace 48 = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSAccountB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance 49,0) <> isnull(a.IsExtendedInheritance,0) union select aig.UID_UNSAccountB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace 50 join UNSRootB r on r.UID_DPRNameSpace = a.UID_DPRNameSpace join UNSItemB ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSAccountBHasUNSItemB aig on ac.UID_UNSItemB 51 = aig.UID_UNSItemB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBHasUNSItemB' 52, @DBQueueElements_06 declare @DBQueueElements_07 QBM_YDBQueueRaw insert into @DBQueueElements_07 (object, subobject, genprocid) select x.uid, null, @GenProcID 53 from ( select ac.UID_UNSGroupB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace 54 = a.UID_DPRNameSpace join UNSGroupB ac on r.UID_UNSRootB = ac.UID_UNSRootB where isnull(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0 55) union select aig.UID_UNSGroupB as uid from DPRNameSpace a join deleted d on a.UID_DPRNameSpace = d.UID_DPRNameSpace join UNSRootB r on r.UID_DPRNameSpace 56 = a.UID_DPRNameSpace join UNSItemB ac on r.UID_UNSRootB = ac.UID_UNSRootB join UNSGroupBHasUnsItemB aig on ac.UID_UNSItemB = aig.UID_UNSItemB where isnull 57(d.IsExtendedInheritance,0) <> isnull(a.IsExtendedInheritance,0) ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupBHasUNSItemB', @DBQueueElements_07 58 naechsterTest: END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 59
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:23:08.220
inserts DBQueue tasks uses session context values has TRY/CATCH error handling
Summary: calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DPRNameSpace, UNSRootB, UNSAccountB…
Declared parameters
No declared parameters in sys.parameters for this object, or metadata was not available.
DML targets
INSERT into UPDATE notCalled routines
Read/join references
- inserted
- deleted
- DPRNameSpace
- UNSRootB
- UNSAccountB
- UNSGroupB
- UNSAccountBInUNSGroupB
- UNSAccountBHasUNSGroupB
- UNSGroupB1
- UNSAccountBInUNSGroupB1
- UNSAccountBHasUNSGroupB1
- UNSGroupB2
- UNSAccountBInUNSGroupB2
- UNSAccountBHasUNSGroupB2
- UNSGroupB3
- UNSAccountBInUNSGroupB3
- UNSAccountBHasUNSGroupB3
- UNSItemB
- UNSAccountBHasUNSItemB
- UNSGroupBHasUnsItemB
SQL dependency metadata
- deleted
- DPRNameSpace
- inserted
- QBM_PDBQueueInsert_Bulk
- QBM_PSessionErrorAdd
- QBM_YDBQueueRaw
- QBM_YParameterList
- UNSAccountB
- UNSAccountBHasUNSGroupB
- UNSAccountBHasUNSGroupB1
- UNSAccountBHasUNSGroupB2
- UNSAccountBHasUNSGroupB3
- UNSAccountBHasUNSItemB
- UNSAccountBInUNSGroupB
- UNSAccountBInUNSGroupB1
- UNSAccountBInUNSGroupB2
- UNSAccountBInUNSGroupB3
- UNSGroupB
- UNSGroupB1
- UNSGroupB2
- UNSGroupB3
- UNSGroupBHasUnsItemB
- UNSItemB
- UNSRootB
- dbo.QBM_FGISessionContext
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
TSB-K-UNSAccountBInUNSGroupB TSB-K-UNSAccountBInUNSGroupB1 TSB-K-UNSAccountBInUNSGroupB2 TSB-K-UNSAccountBInUNSGroupB3 TSB-K-UNSAccountBHasUNSItemB TSB-K-UNSGroupBHasUNSItemBTemp tables / referenced variables
Temp: None extracted.
Variables: @GenProcID @AccountsFuerGroupB0 @AccountsFuerGroupB1 @AccountsFuerGroupB2 @AccountsFuerGroupB3 @DBQueueElements_GroupB0 @DBQueueElements_GroupB1 @DBQueueElements_GroupB2 @DBQueueElements_GroupB3 @DBQueueElements_06 @DBQueueElements_07
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.