identity range check constraint -- sql server replication

jgmeinder NO[at]SPAM gmail.com
1/4/2007 11:02:41 AM

SQL 2005 merge replication.

I took the defaults on an article for publication - auto identity
management and the default ranges. If I attempt to insert >2000 rows
(the size of the 2 ranges assigned), I recieve the following error:

The insert failed. It conflicted with an identity range check
constraint in database 'DHD_73', replicated table
'dbo.tblAlaska_Facility_Manager', column 'facilityID'. If the identity
column is automatically managed by replication, update the range as
follows: for the Publisher, execute sp_adjustpublisheridentityrange;
for the Subscriber, run the Distribution Agent or the Merge Agent.

Does this mean I cannot do an insert of more than 2000 rows at a time
to this particular article?

TIA,
john g.

jgmeinder NO[at]SPAM gmail.com
1/4/2007 11:07:02 AM

Sorry, I forgot to add, I am doing the inserts on the publisher

jg
[quoted text, click to view]

Paul Ibison
1/4/2007 7:52:00 PM

You can batch up the inserts, or increase the size of the assigned rabge,
otherwise you're stuck.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Hilary Cotter
1/5/2007 7:54:49 AM

Check the constraint to see what the range is. You can insert up to this
value and then run a sync. This should update the range.

--
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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : identity range check constraint