Back to OIM Explorer

dbo.QBM_PRecompileAll

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL21 lines
1CREATE PROCEDURE QBM_PRecompileAll2AS3BEGIN4  DECLARE @SQLCmd nvarchar(max)5  DECLARE @DebugSwitch int = 06  SET XACT_ABORT OFF7  BEGIN TRY8    SELECT @SQLCmd = ' ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE '9    EXEC sp_executesql @SQLCmd10  END TRY11  BEGIN CATCH12    EXEC QBM_PSessionErrorAdd DEFAULT13    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()14    RAISERROR(@Rethrow,15    18,16    1)17      WITH NOWAIT18  END CATCH19  ende:20  RETURN21END
Open raw exported source
SQL ยท Raw4 lines
1  create   procedure QBM_PRecompileAll as begin declare @SQLCmd nvarchar(max) declare @DebugSwitch int = 0 SET XACT_ABORT OFF BEGIN TRY  select 2@SQLCmd = ' ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE ' exec sp_executesql @SQLCmd END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default3 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 4