begin transaction set quoted_identifier on set arithabort on set numeric_roundabort off set concat_null_yields_null on set ansi_nulls on set ansi_padding on set ansi_warnnings on commit begin transaction go alter table test add rowguid uniqueidentifier not null rowguidcol constraint MSmerge_df_rowguid_Default(newis()) go alter table test set(LOCK_ESCALATION=TABLE) go commit