Back to OIM Explorer

dbo.QBM_ZUpdateStatistics

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 641 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • References QBM_PJobCreate*

Typed Edges

  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_Mnt source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL42 lines
1CREATE PROCEDURE QBM_ZUpdateStatistics(2  @SlotNumber int,3  @Dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcID varchar(38)6)7  WITH8EXECUTE9AS10'dbo' AS11BEGIN12  DECLARE @erg int13  BEGIN TRY14    IF ISNULL(@GenProcID,15    '') = ''16    BEGIN17      SELECT @GenProcID = dbo.QBM_FGISessionContext('')18    END19    IF 1=020    BEGIN21      EXEC sp_updatestats22    END23    ELSE24    BEGIN25      DECLARE @SQL33734 nvarchar(max) = CONCAT('execute as user = ''dbo'';26											exec sp_updatestats;27											revert;',28      '')29      EXEC QBM_PJobCreate_Mnt @SQL33734,30        @GenProcID31    END32  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    RAISERROR('',36    18,37    1)38      WITH NOWAIT39  END CATCH40  ende: revert41  RETURN42END
Open raw exported source
SQL ยท Raw8 lines
1  create   procedure QBM_ZUpdateStatistics (@SlotNumber int , @Dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) )  with execute2 as 'dbo' AS begin declare @erg int BEGIN TRY if ISNULL(@GenProcID, '') = '' begin select @GenProcID = dbo.QBM_FGISessionContext('') end if 1=0 begin exec3 sp_updatestats end else begin declare @SQL33734 nvarchar(max) = concat('execute as user = ''dbo'';4											exec sp_updatestats;5											revert;'6 , '' ) exec QBM_PJobCreate_Mnt @SQL33734, @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH7 ende: revert return end 8