ALTER TABLE dbo.SensorsSquib DROP CONSTRAINT DF_SensorsSquib_DefineDelayInTest ALTER TABLE dbo.SensorsSquib ADD CONSTRAINT DF_SensorsSquib_DefineDelayInTest DEFAULT ((0)) FOR DefineDelayInTest ALTER TABLE dbo.SensorsSquib SET (LOCK_ESCALATION = TABLE) UPDATE [dbo].[SensorsSquib] SET [DefineDelayInTest] = 0 WHERE [LastModifiedBy] = 'SYSTEM'