After adding table to replication it appears in sysmergearticles with status "6" and its not changing after sync, so replication always make drop/create table at subscriber. It started to appear suddenly and i have other tables that works good, but since several days i can't add table to publication without having this issue.
Asked
Active
Viewed 164 times
1
marc_s
- 732,580
- 175
- 1,330
- 1,459
Sergey Lobanov
- 365
- 3
- 14
-
I've created new replication and all newly created tables has status of 6 in `sysmergearticles`. Only tables that were added to replication during it's creation works fine. – Sergey Lobanov May 08 '15 at 13:50
-
Are you using the -ParallelUploadDownload Merge Agent parameter by any chance? – Brandon Williams May 08 '15 at 16:14
-
Yes. Is it the reason of the problem? – Sergey Lobanov May 12 '15 at 08:13
-
We tested on test replication and on main with both 0 and 1 parameters for that property. The problem still exist. – Sergey Lobanov May 12 '15 at 08:24
-
Since all new tables in **test** replication has status "6" in `sysmergearticles` they all replicate without drop/recreation of tables. So, status 6 is not the case of the problem i think. – Sergey Lobanov May 12 '15 at 09:21