identity column managed by replication problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

identity column managed by replication problem

Author

Topic

COMMANDER
Starting Member

6 Posts

Posted - 2010-01-28 : 08:27:50

Hi!
i'm using a pull merge replication(sql server2005 )
i'm facing the following error not in the replication
but with other applications using the replicated database
The insert failed .it conflicted with an identity range check constraint in database 'Mydb' ,replicated table 'dbo.mytable'
column 'mycolumn'.If the identity column is automaticallymanaged by Replication,update the range as follows:for the Publisher eecute sp_adjustpublisheridentityrange;for the subscriber,run the distribution agent or the merge agent

the users are receiving this error when trying to insert a new record
i had to remove this table from the published article in so the users application was able to insert rows

i tried to use
DBCC CHECKIDENT (TABLE1 , RESEED, 2528211)
for this table plus i used sp_adjustpublisheridentityrange

before removing the table from the replication
But no use
anyone faced this problem before
i saw a patch that solves this problem for sql server2008
but what about sql server2005 users???

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-01-28 : 09:18:03

Have a look at your ranges in the check constraint for the table you are getting this problem on. You will have a conflict in there and may need to manually change the constraint.

COMMANDER
Starting Member

6 Posts

Posted - 2010-01-29 : 03:43:00

i already tried to increase decrease the publisher/subscriber range size
in the section identity Range management
but still facing the same problem
plus it's expanding to other tables
and i'm removing them from my publication
is that a bug in sql server??
i need urgent help please
Many Thanks in advance

COMMANDER
Starting Member

6 Posts

Posted - 2010-02-05 : 09:46:06

the identity column have a property Not for replication it should be set
not for replication Yes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources