What is the best way to add an article to a merge replication?
sp_addmergearticle 'PUB_1','test_tbl','test_tbl',
@force_invalidate_snapshot=1

Line 470 Publication 'PUB_1' does not support the nosync type because it
contains a table that does not have a rowguidcol column.

After the error, I created the rowguidcol as a uniqueidentifier with
default newid() in the new article and refreshed the database. I then
ran the script again and ended up with the same error. Do any of you
have an idea of what could be the problem and how to resolve it.

I have over 70 replicated databases that will need the new article added
and will like to script the addition without having to drop the
subscriptions and recreate them.

Thank you,

Pete Ocasio
Senior Software Developer
Execupay, Inc.
510 Portland
San Antonio, TX 78216

Voice: 210.366.0001
Fax: 210.366.0496
Support Email: [Email address protected]
Support Website: http://support.execupay.com

Learn how you can get back to business
with Execupay at http://www.execupay.com




MS Sql Server LazyDBA home page