>Just put them in two separate batches:
>

>ALTER TABLE [Advertis] ADD [AddUserTemporary] int
>GO
>UPDATE [Advertis] SET [AddUserTemporary]=AddUser
>

>
>or if you have to do this from an application:
>
>

>EXEC sp_executesql N'ALTER TABLE [Advertis] ADD [AddUserTemporary] int'
>EXEC sp_executesql N'UPDATE [Advertis] SET [AddUserTemporary]=AddUser'
>

Correct, by using GO, it works. I will probably use this approach.

Thanks