Back to OIM Explorer

dbo.QBM_FGIMaintenanceRunning_M

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 563 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGIConstraintsDisabled source text reference
  • references source dbo.QBM_FGIMaintenanceRunning source text reference
  • references source dbo.QBM_FGISingleUserRunning source text reference
  • references source dbo.QBM_FGITriggersDisabled source text reference

References

Referenced By

Complete Source

SQL24 lines
1CREATE FUNCTION dbo.QBM_FGIMaintenanceRunning_M(2  @IsSystemUser BIT3) RETURNS varchar(324)5AS6BEGIN7  RETURN(CASE8  WHEN dbo.QBM_FGITriggersDisabled() = 1 THEN9  'Triggers disabled'10  WHEN dbo.QBM_FGIConstraintsDisabled() = 1 THEN11  'Constraints disabled'12  WHEN dbo.QBM_FGISingleUserRunning() = 1 THEN13  'Single user'14  WHEN EXISTS(15  SELECT TOP 1 116  FROM DialogDatabase d17    WITH(readpast)18  WHERE19    d.IsMainDatabase = 1 AND(@IsSystemUser = 1 AND d.UpdatePhase IN(3, 4) OR @IsSystemUser = 0 AND d.UpdatePhase IN(2,20  3, 4))) THEN21  'System update running'22  ELSE ''23  END)24END
Open raw exported source
SQL ยท Raw5 lines
1    create   function dbo.QBM_FGIMaintenanceRunning_M(@IsSystemUser bit) returns varchar(32) as begin return ( case when dbo.QBM_FGITriggersDisabled2() = 1 then 'Triggers disabled' when dbo.QBM_FGIConstraintsDisabled() = 1 then 'Constraints disabled' when dbo.QBM_FGISingleUserRunning() = 1 then 'Single user'3  when exists (select top 1 1 from DialogDatabase d with (readpast) where d.IsMainDatabase = 1 and (@IsSystemUser = 1 and d.UpdatePhase in (3, 4) or @IsSystemUser4 = 0 and d.UpdatePhase in (2,3,4) ) ) then 'System update running' else '' end ) end 5