Wednesday, March 28, 2012

merge and managed auto id

"The identity range managed by replication is
full and must be updated by a replication agent."
my merge replication agent is constantly running and syncing.
why isn't it re-seeding the values in the ident. cols ?
You have blown your range on the subscriber. You need to select a range
which will not be blown between syncs. This is rather difficult to recover
from. Check out this article for more info.
http://www.simple-talk.com/sql/database-administration/the-identity-crisis-in-replication/
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
"Tony B." <Test@.spam.ca> wrote in message
news:u8XhNLnDHHA.3520@.TK2MSFTNGP04.phx.gbl...
> "The identity range managed by replication is
> full and must be updated by a replication agent."
> my merge replication agent is constantly running and syncing.
> why isn't it re-seeding the values in the ident. cols ?
>

No comments:

Post a Comment