sql server replication: Hello,

I am trying to add a new column to a table that is being
replicated. I want the column to be varchar 5 and have a
default of YES.
The script below seems to error out.

sp_repladdcolumn 'DOOR','ThisIsDoor',varchar(5)
DEFAULT='YES','MergeAllDoors'


Thanks,

Niv,

this should be the correct script:

sp_repladdcolumn @source_object = 'DOOR'
, @column = 'ThisIsDoor'
, @typetext = "varchar(5) NOT NULL DEFAULT 'Yes'"
, @publication_to_add = 'MergeAllDoors'

HTH,
Paul Ibison