dbo.QBM_ZBufferTProcessDelete

SQL_STORED_PROCEDURE

Created 2025-06-27T17:58:58.810 · modified 2026-04-14T23:20:29.567 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberintno
@uid_Modulevarcharno
@Dummy2varcharno
@GenProcIDvarcharno

Referenced objects

SchemaObjectColumn/minorClass
DialogDBQueueOBJECT_OR_COLUMN
QBM_PDBQCS_CurrentRestoreOBJECT_OR_COLUMN
QBM_PDBQueueInsert_SingleOBJECT_OR_COLUMN
QBM_PJournalOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBMDBQueueCurrentOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1  create   procedure QBM_ZBufferTProcessDelete (@SlotNumber int , @uid_Module varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) ) AS begin
2 declare @ModuleName varchar(3) declare @Message nvarchar(1000) declare @DebugStarttime datetime = getutcdate() declare @DebugLevel char(1) = 'W' declare
3 @TasksToCheck table (UID_Task varchar(38) collate database_default ) declare @UID_Task varchar(38) declare @lastFillDummy datetime SET XACT_ABORT OFF 
4BEGIN TRY  select @ModuleName = LEFT(@uid_module, 3) insert into @TasksToCheck (uid_Task) values ('QBM-K-BufferTProcessModulePU' ) , ('QBM-K-BufferTProcessModule'
5) , ('QBM-K-BufferTProcessTablePU') , ('QBM-K-BufferTProcessTable')  if exists (select top 1 1 from @TasksToCheck t join DialogDBQueue q with (readpast
6) on t.UID_Task = q.UID_Task where q.Generation >= 0 ) or exists (select top 1 1 from @TasksToCheck t join QBMDBQueueCurrent q with (readpast) on t.UID_Task
7 = q.UID_Task where q.SlotNumber <> 0 ) begin select @Message = '#LDS#Found active Tasks while executing {0}.|' + 'QBM_ZBufferTProcessDelete' + '|' exec
8 QBM_PJournal @Message,@@PROCID, 'W', @DebugLevel while exists (select top 1 1 from @TasksToCheck ) begin select top 1 @UID_Task = UID_Task from @TasksToCheck
9   exec QBM_PDBQCS_CurrentRestore @ExecutionType = 0 , @IgnoreGeneration = 1 , @UID_TaskPattern = @UID_Task delete  @TasksToCheck  where UID_Task = @UID_Task
10 end  exec QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID   end else begin  exec QBM_PDBQueueInsert_Single 'QBM-K-FillModelFinished'
11, '', '', @GenProcID end    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
12

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:20:29.567

inserts DBQueue tasks has TRY/CATCH error handling

Summary: calls QBM_PJournal, QBM_PDBQCS_CurrentRestore, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into; reads/joins DialogDBQueue, QBMDBQueueCurrent

Declared parameters

ParameterTypeDirection
@SlotNumberintinput
@uid_Modulevarchar(38)input
@Dummy2varchar(38)input
@GenProcIDvarchar(38)input

DML targets

INSERT into

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

QBM-K-BufferTProcessModulePU QBM-K-BufferTProcessModule QBM-K-BufferTProcessTablePU QBM-K-BufferTProcessTable QBM-K-BufferTProcessDelete QBM-K-FillModelFinished

Temp tables / referenced variables

Temp: #LDS #Found

Variables: @SlotNumber @uid_Module @Dummy2 @GenProcID @ModuleName @Message @DebugStarttime @DebugLevel @TasksToCheck @UID_Task @lastFillDummy @uid_module @PROCID @ExecutionType @IgnoreGeneration @UID_TaskPattern

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.