Monday, March 26, 2012

duplicate identity

Hi there,
we are using merge replication on sql2000.We are using
partial replicas.
We have different identity value set for each of our
remote subscirbers. all tables are fine they all have the
key value as what they should have except one table.
this particular table on all our servers is using one
identity value which belongs to one of our remote
location. as a result when plants are replicating we get
conflicts on this table as the violation of primary key
value.
as this table is only keeping track of the user security
so its not causing us any problems right now.
but i am curious as why the identity value gets changed
only for this one particular table.
Does that table have the identity column set with the "not for replication"
option? If not, then the identity column will get reseeded and cause this
problem.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

No comments:

Post a Comment