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