Back to OIM Explorer

dbo.QBM_PDiskStorePhysicalSync

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.708 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_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FCVStringToGUID source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL83 lines
1CREATE PROCEDURE QBM_PDiskStorePhysicalSync2AS3BEGIN4  DECLARE @XUser nvarchar(64) = object_name(@@procid)5  DECLARE @Xdate datetime = getutcdate()6  DECLARE @DebugSwitch int = 07  IF @DebugSwitch > 08  BEGIN9    print 'to add'10    SELECT11      DISTINCT g.name12    FROM sys.filegroups g13    JOIN sys.database_files f14      ON f.data_space_id = g.data_space_id15    WHERE16      NOT EXISTS(17    SELECT TOP 1 118    FROM QBMDiskStorePhysical p19    WHERE20      p.Ident_QBMDiskStorePhysical = g.name) AND g.type_desc = 'ROWS_FILEGROUP'21  END22  INSERT INTO QBMDiskStorePhysical(UID_QBMDiskStorePhysical,23  Ident_QBMDiskStorePhysical,24  XObjectKey,25  XDateInserted,26  XDateUpdated,27  XUserInserted,28  XUserUpdated)29  SELECT30    DISTINCT dbo.QBM_FCVStringToGUID('',31    g.name),32    g.name,33    dbo.QBM_FCVElementToObjectKey1('QBMDiskStorePhysical',34    'UID_QBMDiskStorePhysical',35    dbo.QBM_FCVStringToGUID('', g.name)),36    @Xdate,37    @Xdate,38    @XUser,39    @XUser40  FROM sys.filegroups g41  JOIN sys.database_files f42    ON f.data_space_id = g.data_space_id43  WHERE44    NOT EXISTS(45  SELECT TOP 1 146  FROM QBMDiskStorePhysical p47  WHERE48    p.Ident_QBMDiskStorePhysical = g.name) AND g.type_desc = 'ROWS_FILEGROUP'49  IF @DebugSwitch > 050  BEGIN51    print 'to del'52    SELECT p.*53    FROM QBMDiskStorePhysical p54    LEFT55    OUTER56    JOIN(57    SELECT58      DISTINCT g.name59    FROM sys.filegroups g60    JOIN sys.database_files f61      ON f.data_space_id = g.data_space_id62    WHERE63      g.type_desc = 'ROWS_FILEGROUP') AS r64      ON p.Ident_QBMDiskStorePhysical = r.name65    WHERE66      r.name IS NULL67  END68  DELETE QBMDiskStorePhysical69  FROM QBMDiskStorePhysical p70  LEFT71  OUTER72  JOIN(73  SELECT74    DISTINCT g.name75  FROM sys.filegroups g76  JOIN sys.database_files f77    ON f.data_space_id = g.data_space_id78  WHERE79    g.type_desc = 'ROWS_FILEGROUP') AS r80    ON p.Ident_QBMDiskStorePhysical = r.name81  WHERE82    r.name IS NULL83END
Open raw exported source
SQL ยท Raw12 lines
1  create   procedure QBM_PDiskStorePhysicalSync as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate2() declare @DebugSwitch int = 0 if @DebugSwitch > 0 begin print 'to add' select distinct g.name from sys.filegroups g  join sys.database_files f on f.data_space_id3 = g.data_space_id where not exists (select top 1 1 from QBMDiskStorePhysical p where p.Ident_QBMDiskStorePhysical = g.name ) and g.type_desc = 'ROWS_FILEGROUP'4 end insert into QBMDiskStorePhysical(UID_QBMDiskStorePhysical, Ident_QBMDiskStorePhysical, XObjectKey , XDateInserted, XDateUpdated, XUserInserted, XUserUpdated5 ) select distinct dbo.QBM_FCVStringToGUID('', g.name) , g.name, dbo.QBM_FCVElementToObjectKey1('QBMDiskStorePhysical', 'UID_QBMDiskStorePhysical', dbo.QBM_FCVStringToGUID6('', g.name)) , @Xdate, @Xdate, @XUser, @XUser  from sys.filegroups g  join sys.database_files f on f.data_space_id = g.data_space_id where not exists 7(select top 1 1 from QBMDiskStorePhysical p where p.Ident_QBMDiskStorePhysical = g.name ) and g.type_desc = 'ROWS_FILEGROUP'  if @DebugSwitch > 0 begin8 print 'to del' select p.* from QBMDiskStorePhysical p left outer join (select distinct g.name from sys.filegroups g  join sys.database_files f on f.data_space_id9 = g.data_space_id where g.type_desc = 'ROWS_FILEGROUP' ) as r on p.Ident_QBMDiskStorePhysical = r.name where r.name is null end delete QBMDiskStorePhysical10 from QBMDiskStorePhysical p left outer join (select distinct g.name from sys.filegroups g  join sys.database_files f on f.data_space_id = g.data_space_id11 where g.type_desc = 'ROWS_FILEGROUP' ) as r on p.Ident_QBMDiskStorePhysical = r.name where r.name is null  end 12