use [EnVisage] BEGIN TRANSACTION ALTER TABLE dbo.Status ADD IsSystem bit NOT NULL CONSTRAINT DF_Status_IsSystem DEFAULT 0 GO update dbo.Status set IsSystem = 1 where name = 'system' GO COMMIT