Showing posts with label range. Show all posts
Showing posts with label range. Show all posts

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 ?
>