Friday, March 30, 2012

resolver option and tracking level article options disabled

Hi, we are using SQL2005 merge replication, and have 2 publications that
reference the same article. We are trying to change the tracking level option
for this article, but it is greyed out and disabled, because it knows the
article is in another publication, and it disallows this change. We recreated
this on another server. The option, along with the resolver tab options, get
completely greyed when the 2nd publication is added. Any ideas how to change
the tracking level in this case? Should we use a stored procedure to set this
option? Thanks.
Some publication options are limited by other publications the article is
in. There is no way to change this without dropping all publications and
making these properties consistent in all publications.
Another example of one of these properties is automatic identity range
management.
Hilary Cotter
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
"nkleinjan" <nkleinjan@.discussions.microsoft.com> wrote in message
news:325082EB-74C2-42E9-AFB7-843D23CB53B4@.microsoft.com...
> Hi, we are using SQL2005 merge replication, and have 2 publications that
> reference the same article. We are trying to change the tracking level
> option
> for this article, but it is greyed out and disabled, because it knows the
> article is in another publication, and it disallows this change. We
> recreated
> this on another server. The option, along with the resolver tab options,
> get
> completely greyed when the 2nd publication is added. Any ideas how to
> change
> the tracking level in this case? Should we use a stored procedure to set
> this
> option? Thanks.

No comments:

Post a Comment