sql server replication:
Need to add an article to merge pub using sp_addmergearticle. Getting the
following error:

Server: Msg 20086, Level 16, State 1, Procedure sp_addmergearticle, Line 470
Publication 'fxDB6_Merge' does not support the nosync type because it
contains a table that does not have a rowguidcol column.

I manually add the rowguid column, uniqueidenifier data type, & newid()
default. And still same error. How do I get around this?

I would like to prevent from having to re-create entire pub, the nosync
option for some reason takes 24+ hours doing metadata updates... (different
problem). This is not an option.

Thanks in advance to any who can help.

Chris - you'll need to also change the RowGuid column property to 'Yes'.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

bingo. Thank you Paul!

[quoted text, click to view]