Back to OIM Explorer

dbo.QBM_ZScriptAssemblyReset

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.029 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVGUIDToModuleOwner source text reference
  • references source dbo.QBM_PDBQueueInsert_WaitForComp source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL52 lines
1CREATE PROCEDURE QBM_ZScriptAssemblyReset(2  @SlotNumberDummy int,3  @Context varchar(38),4  @Detail varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @AssemblyNameCompare nvarchar(128)10  DECLARE @CountItems int11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  BEGIN TRY14    IF @Context = 'Scripts'15    BEGIN16      SELECT @Context = CASE17      WHEN dbo.QBM_FCVGUIDToModuleOwner(@detail) = 'CCC' THEN18      'Scripts'19      ELSE 'ProductScripts'20      END21    END22    IF @Context = 'JobGen'23    BEGIN24      SELECT @AssemblyNameCompare = N 'Jobs' + N '[_]%'25    END26    ELSE27    BEGIN28      SELECT @AssemblyNameCompare = @Context + N '[_]%'29    END30    UPDATE dialogscriptassembly31    SET IsValid = 0,32    XDateUpdated = @Xdate,33    XUserUpdated = @XUser34    WHERE35      name LIKE @AssemblyNameCompare AND IsValid = 136    SELECT @CountItems = @@rowcount37    IF @CountItems > 038    BEGIN39      EXEC QBM_PDBQueueInsert_WaitForComp 'ResetAssembly',40        @GenProcID41    END42  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    RAISERROR('',46    18,47    1)48      WITH NOWAIT49  END CATCH50  ende:51  RETURN52END
Open raw exported source
SQL ยท Raw8 lines
1    create   procedure QBM_ZScriptAssemblyReset (@SlotNumberDummy int , @Context varchar(38)  , @Detail varchar(38)   ,@GenProcID varchar(38) ) 2as begin  declare @AssemblyNameCompare nvarchar(128) declare @CountItems int declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime3 = getutcdate() BEGIN TRY  if @Context = 'Scripts' begin select @Context = case when dbo.QBM_FCVGUIDToModuleOwner(@detail) = 'CCC' then 'Scripts' else 4'ProductScripts' end end if @Context = 'JobGen' begin  select @AssemblyNameCompare = N'Jobs' + N'[_]%' end else begin  select @AssemblyNameCompare = @Context5 + N'[_]%'  end   update dialogscriptassembly set IsValid = 0  , XDateUpdated = @Xdate , XUserUpdated = @XUser where name like @AssemblyNameCompare and6 IsValid = 1 select @CountItems = @@rowcount     if @CountItems > 0 begin   exec QBM_PDBQueueInsert_WaitForComp 'ResetAssembly', @GenProcID  end END TRY7 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 8