>>It still doesn't work.
>>

>>IF NOT EXISTS
>>(SELECT column_name
>>FROM INFORMATION_SCHEMA.COLUMNS
>>WHERE TABLE_NAME = N'Volunteers' and COLUMN_NAME = N'IsActive')
>>BEGIN
>>  SET @SQLString = N'alter table Volunteers add IsActive bit null CONSTRAINT [DF_Volunteers_IsActive]  DEFAULT ((1))'
>>  EXECUTE sp_executesql @SQLString -- Only to be in other batch
>>  UPDATE Volunteers SET IsActive = 1
>>END

>>
>>Gives me an error on UPDATE line.
>
>Did you have BEGIN TRANSACTION before that code?

No.