dbo.QBM_PDiskStorePhysicalSync

1  create   procedure QBM_PDiskStorePhysicalSync as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate
2() 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_id
3 = 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, XUserUpdated
5 ) select distinct dbo.QBM_FCVStringToGUID('', g.name) , g.name, dbo.QBM_FCVElementToObjectKey1('QBMDiskStorePhysical', 'UID_QBMDiskStorePhysical', dbo.QBM_FCVStringToGUID
6('', 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 begin
8 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_id
9 = 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 QBMDiskStorePhysical
10 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_id
11 where g.type_desc = 'ROWS_FILEGROUP' ) as r on p.Ident_QBMDiskStorePhysical = r.name where r.name is null  end 
12