UPDATE VS4TPS SET TPSDMode=0 where TPSDMode<>1 or TPSDMode is null
GO
UPDATE VS4TPR SET TPRDMode=0 where TPRDMode<>1 or TPRDMode is null
GO
UPDATE VS4TPO SET TPODMode=0 where TPODMode<>1 or TPODMode is null
GO
UPDATE VS4TAP SET TAPNMode=0 where TAPNMode<>1 or TAPNMode is null
GO