dbo.QBM_PDialogDatabaseInitialInfo

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
No parameters.

Referenced objects

Schema	Object	Class
	dialogdatabase	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
dbo	QBM_FGIDBDataOrigin	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_PDialogDatabaseInitialInfo as begin declare @UID_NewObject varchar(38) declare @xdate datetime = getutcdate() declare 
2@XUser nvarchar(64) = object_name(@@procid) SET XACT_ABORT OFF BEGIN TRY set nocount on if not exists (select top 1 1 from dialogdatabase ) begin select
3 @UID_NewObject = newid() insert into dialogdatabase (UID_Database, IsMainDatabase, Description , ConnectionString, ConnectionProvider , XObjectKey , ModuleOwner
4, UID_DialogAuthentifier , UID_DialogCultureDefault , XUserInserted, XUserUpdated, XDateInserted, XDateUpdated , productionLevel, CustomerPrefix , IsJobServiceDisabled
5 , DataOrigin ) values (@UID_NewObject, 1, N'Main Database', null, null , concat('<Key><T>DialogDatabase</T><P>', @UID_NewObject ,'</P></Key>') , 'CCC'
6, 'QBM-740AF63FCA9D40E1A9A28CF076B36BBD'  , 'QBM-CULT-en-US' , @XUser, @XUser, @xdate, @xdate , 0, 'CCC' , 1 , dbo.QBM_FGIDBDataOrigin() ) end END TRY 
7BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT
8 END CATCH ende: return end 
9

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:26.277

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes INSERT dialogdatabase; reads/joins dialogdatabase

Declared parameters

No declared parameters in sys.parameters for this object, or metadata was not available.

DML targets

INSERT dialogdatabase

Called routines

QBM_PSessionErrorAdd

Read/join references

dialogdatabase

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @UID_NewObject @xdate @XUser @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.

Referencing object	Relation	Evidence
dbo.QBM_PDatabasePrepare	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepare	source text reference	has TRY/CATCH error handling