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 2000 Forums
 SQL Server Development (2000)
 SQL merge replication

Author  Topic 

viveksharma
Starting Member

2 Posts

Posted - 2004-08-23 : 23:59:58
Hi There,

I have been using SQL merge replication for my organisation. The problem is I allocated the range of 10000 for publisher and 100000 for subscribers and threshold is 80%. It is not that we have entered a lot of data but now it says that the identity range is full. It is a surprise how can such a big range be used in a short period of 3 weeks.

There are only 5 computers in our office. Also, today one of our manager syncronised his machine with the publisher and it should 1000 updates on publisher from the subscriber. However, the manager reckons that he updated around 5 - 10 records.

Please guide.

Thanks
Vivek Sharma
   

- Advertisement -