As a further step in two way transactional replication, I want to solve the identity column issue. Because I don't want to set the seed and increment manually (not very scalable or flexible), I choose the automatically assignment of identity value in SQL server. However, as I discover, the SQL server will not reassign a new identity range for a subcription if uses all the identity values in its range. What is wrong?
The setting is the same as my previous setting. Both uses win 2003 sp1, sql server 2000 sp4. Two way transactional replication with immediate updating with queued updating as failover.