dbo.QBM_PBufferT_FillSnapshot

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:30.187 · modified 2026-04-14T23:14:36.500 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@TempTableName`	nvarchar	no
`@ModuleName`	varchar	no

Referenced objects

Schema	Object	Class
	QBM_PBufferT_FillTable	OBJECT_OR_COLUMN
	QBM_PJournal	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_YCursorBuffer	TYPE
dbo	QBM_FGIDBOwner	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_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_PBufferT_FillSnapshot ( @TempTableName nvarchar(64) , @ModuleName varchar(3) = '#' ) as begin declare @cmd nvarchar(max
2) declare @TableName varchar(30) declare @DebugLevel char(1) = 'W' declare @DebugSwitch int = 0 declare @TableNames QBM_YCursorBuffer declare @ElementCount
3 int declare @ElementIndex int  declare @ErrorMessage nvarchar(4000) declare @ErrorSeverity int declare @ErrorState int declare @TargetModule varchar(3
4) SET XACT_ABORT OFF BEGIN TRY if @ModuleName = '#' begin select @ModuleName = dbo.QBM_FGIDBOwner() end select @TargetModule = @ModuleName select @cmd 
5= N'
6
7  select t.TableName
8	from DialogTable t 
9			join sys.tables tt on t.TableName = tt.name  collate database_default
10								and tt.type_desc = ''USER_TABLE''
11	where 	1=1'
12 select @cmd = @cmd + N'	
13	 and t.usagetype in (''CONFIGURATION'', ''USERDATA'', ''MATERIAL'') 
14	 and (t.IsTransportDisabled  = 0
15			or t.tabletype = ''B'' and exists (select top 1 1 
16												from dialogtable v 
17												where v.UID_DialogTableBase = t.UID_DialogTable
18												and v.IsTransportDisabled = 0
19												)
20		)
21	 '
22 select @cmd = @cmd + N'	
23	 and exists (select top 1 1 from INFORMATION_SCHEMA.COLUMNS ok 
24					where ok.TABLE_NAME = t.TableName
25						and ok.Column_name = ''XObjectKey''
26				)'
27   if @DebugSwitch > 0 begin exec QBM_PJournal @Cmd, @@procid, 'D', @DebugLevel end  begin try insert into @TableNames(Ident1 ) exec sp_executesql @cmd
28 end try begin catch exec QBM_PSessionErrorAdd default, @Cmd RAISERROR ('', 18, 1) WITH NOWAIT end catch select @ElementCount = count(*) from @TableNames
29 select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select @TableName = null select top 1 @TableName = bu.Ident1  from @TableNames bu 
30where bu.ElementIndex = @ElementIndex if @DebugSwitch > 0 begin print 'Dumping Table ' + @TableName end exec QBM_PBufferT_FillTable @TempTableName , @TargetModule
31 , @TableName , '1=1' , @ModuleName select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000)
32 = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 
33

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:14:36.500

has TRY/CATCH error handling

Summary: calls QBM_PJournal, QBM_PSessionErrorAdd, QBM_PBufferT_FillTable; writes INSERT into; reads/joins DialogTable, sys, dialogtable, INFORMATION_SCHEMA

Declared parameters

Parameter	Type	Direction
`@TempTableName`	`nvarchar(64)`	input
`@ModuleName`	`varchar(3)`	input

DML targets

INSERT into

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @TempTableName @ModuleName @cmd @TableName @DebugLevel @DebugSwitch @TableNames @ElementCount @ElementIndex @ErrorMessage @ErrorSeverity @ErrorState @TargetModule @Cmd @procid @Rethrow

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.