Back to OIM Explorer

dbo.QBM_PTableReindex

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL29 lines
1CREATE PROCEDURE QBM_PTableReindex(2  @Tablename varchar(30)3)4AS5BEGIN6  DECLARE @cmd nvarchar(max)7  DECLARE @RebuildOptions nvarchar(max)8  SET XACT_ABORT OFF9  BEGIN TRY10    EXEC QBM_PGIDBServerIndexRebuildOpt @Tablename,11      @RebuildOptions OUTPUT,12      @AllowPageLock = 013    SELECT14      @cmd = CONCAT('ALTER INDEX ALL ON ',15      @tablename,16      @RebuildOptions)17    EXEC sp_executesql @cmd18  END TRY19  BEGIN CATCH20    EXEC QBM_PSessionErrorAdd DEFAULT21    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()22    RAISERROR(@Rethrow,23    18,24    1)25      WITH NOWAIT26  END CATCH27  endLabel:28  RETURN29END
Open raw exported source
SQL ยท Raw5 lines
1 create   procedure QBM_PTableReindex (@Tablename varchar(30)) as begin declare @cmd nvarchar(max) declare @RebuildOptions nvarchar(max) SET XACT_ABORT2 OFF BEGIN TRY exec QBM_PGIDBServerIndexRebuildOpt @Tablename, @RebuildOptions output, @AllowPageLock = 0 select @cmd = concat( 'ALTER INDEX ALL ON ' ,3 @tablename, @RebuildOptions )  exec sp_executesql @cmd END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow4() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: return end 5