Back to OIM Explorer

dbo.QBM_ZRecompileAll

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 281 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_PRecompileAll source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL19 lines
1CREATE PROCEDURE QBM_ZRecompileAll(2  @SlotNumber int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @dummyGenProcID varchar(38)6)7AS8BEGIN9  BEGIN TRY10    EXEC QBM_PRecompileAll11  END TRY12  BEGIN CATCH13    EXEC QBM_PSessionErrorAdd DEFAULT14    RAISERROR('',15    18,16    1)17      WITH NOWAIT18  END CATCH19END
Open raw exported source
SQL ยท Raw3 lines
1   create   procedure QBM_ZRecompileAll (@SlotNumber int , @dummy1 varchar(38) , @dummy2 varchar(38) , @dummyGenProcID varchar(38) ) as begin BEGIN2 TRY exec QBM_PRecompileAll END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 3