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
 General SQL Server Forums
 New to SQL Server Administration
 Identity Range Management

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-10-31 : 08:12:41
I have a table that is being replicated via merge replication,

I have set the 'Automatically manage identity ranges' option to Automatic.

There will be a job that inserts 20,000 rows via a bulk insert at the publisher.

I was wondering how to set the identity range management settings for this setup.

The identity field is an int data type.


The publisher range size is 100






ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-11-13 : 11:27:37
I'm trying to enter 100,000 records into a table in merge replication. The publisher range size is 10000, subscriber range is 1000 and Range Threshold percentage is 80.

The insert fails with the following message insert failed. It conflicted with an identity range check constraint in database

Do I need to increase the range to 100000?
Or modify the threshold?

Thanks
Go to Top of Page
   

- Advertisement -