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.
| 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 databaseDo I need to increase the range to 100000?Or modify the threshold?Thanks |
 |
|
|
|
|
|
Identity Range Management