>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?