Back to OIM Explorer

dbo.QBM_ZConstraintDisable

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.004 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_PConstraintDisable source text reference
  • references source dbo.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTriggerDisable source text reference
  • references source dbo.QBM_TUIndicator474488 source text reference

References

Referenced By

Complete Source

SQL55 lines
1CREATE PROCEDURE QBM_ZConstraintDisable(2  @SlotNumber int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @DebugLevel char(1) = 'W'10  DECLARE @ResetMessage nvarchar(4000)11  SET XACT_ABORT OFF12  BEGIN TRY13    IF NOT EXISTS(14      SELECT TOP 1 115      FROM sys.triggers x16      WHERE17        x.is_disabled = 0 AND x.name != 'QBM_TUIndicator474488') AND NOT EXISTS(18    SELECT TOP 1 119    FROM sys.foreign_keys x20    WHERE21      x.is_disabled = 0)22    BEGIN23      GOTO endLabel24    END25    SET lock_timeout 200026    BEGIN TRY27      EXEC QBM_PTriggerDisable '%'28      EXEC QBM_PConstraintDisable '%'29      EXEC QBM_PJournal 'Triggers and constraints disabled',30        @@procid,31      'D',32        @DebugLevel33    END TRY34    BEGIN CATCH35      EXEC QBM_PSessionErrorAdd DEFAULT36      SELECT @ResetMessage = ERROR_MESSAGE()37      IF @@TRANCOUNT > 038      BEGIN39        ROLLBACK40      END41      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,42        @ResetMessage,43        @@PROCID44    END CATCH45    SET lock_timeout -146  END TRY47  BEGIN CATCH48    EXEC QBM_PSessionErrorAdd DEFAULT49    RAISERROR('',50    18,51    1)52      WITH NOWAIT53  END CATCH54  endLabel:55END
Open raw exported source
SQL ยท Raw8 lines
1    create   procedure QBM_ZConstraintDisable ( @SlotNumber int , @dummy1 varchar(38) , @dummy2 varchar(38) , @GenProcIDDummy varchar(38) ) as begin2 declare @DebugLevel char(1) = 'W' declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF BEGIN TRY  if not exists (select top 1 1 from sys.triggers x3 where x.is_disabled = 0 and x.name != 'QBM_TUIndicator474488' ) and not exists (select top 1 1 from sys.foreign_keys x where x.is_disabled = 0 ) begin4 goto endLabel end set lock_timeout 2000 BEGIN TRY exec QBM_PTriggerDisable '%' exec QBM_PConstraintDisable '%' exec QBM_PJournal 'Triggers and constraints disabled'5, @@procid, 'D', @DebugLevel END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback6 end exec QBM_PDBQueueCurrentResetNGen @SlotNumber , @ResetMessage , @@PROCID END CATCH set lock_timeout -1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd7 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 8