HELP - Error adding an article to a merge replication - Any ideas? -- sql server replication

Pete Ocasio
10/4/2007 9:09:49 AM

I have search high and low for an answer and still coming out empty... the
closest answer was to apply the latest udpdate but I am already at SP$ SQL
Server 2000.

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

Hilary Cotter
10/9/2007 7:31:00 AM

the three criteria necessary are

1) the column have a data type of [uniqueidentifier] rowguidcol
2) it have a default of newid() (SQL 2000) or newsequentialid() (SQL 2005)
3) have a unique constraint on it.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : HELP - Error adding an article to a merge replication - Any ideas?