Back to OIM Explorer

dbo.QBM_FGIMaintenanceRunning

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 465 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_FGISingleUserRunning source text reference
  • references source dbo.QBM_FGITriggersDisabled source text reference

References

Referenced By

Complete Source

SQL22 lines
1CREATE FUNCTION dbo.QBM_FGIMaintenanceRunning(2) RETURNS varchar(323)4AS5BEGIN6  RETURN(CASE7  WHEN dbo.QBM_FGITriggersDisabled() = 1 THEN8  'Triggers disabled'9  WHEN dbo.QBM_FGIConstraintsDisabled() = 1 THEN10  'Constraints disabled'11  WHEN dbo.QBM_FGISingleUserRunning() = 1 THEN12  'Single user'13  WHEN EXISTS(14  SELECT TOP 1 115  FROM DialogDatabase d16    WITH(readpast)17  WHERE18    d.IsMainDatabase = 1 AND d.UpdatePhase > 1) THEN19  'System update running'20  ELSE ''21  END)22END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FGIMaintenanceRunning() returns varchar(32) as begin return ( case when dbo.QBM_FGITriggersDisabled() = 1 then 'Triggers disabled'2 when dbo.QBM_FGIConstraintsDisabled() = 1 then 'Constraints disabled' when dbo.QBM_FGISingleUserRunning() = 1 then 'Single user'      when exists (select3 top 1 1 from DialogDatabase d with (readpast) where d.IsMainDatabase = 1 and d.UpdatePhase > 1  ) then 'System update running' else '' end ) end 4