What agent executes sp_adjustpublisheridentityrange?
in [Replication]
|
Prev: sp_droparticle without dropping subscription
Next: Reinitialize without upload error and KB Article ID: 953624
From: Steve Mahon on 7 Aug 2008 13:56 I am a SQL novice and this is my 1st time using replication. I'm using merge replication to publish on sever 2005 and pull subscribers using express 2005. All seemed great, until I could not longer add items to a particular table on the publisher. It gave an error stating I needed to run sp_adjustpublisheridentityrange, which I did, and which took care of the problem. My question is this, shouldn't that be executed by an agent at a scheduled interval? I looked through the steps in each of the jobs, and none seem to include that sp. It is possible that I accidently deleted a job while I was first creating the publication, since it took me a couple of attempts to get things working.
From: Hilary Cotter on 7 Aug 2008 21:35
Yes, if you insert enough row to exceed the threshold but not blow the range the next time the merge agent runs it will increment it. you unforuntately have blown the range (and the buffer) so you need to do it manually. "Steve Mahon" <SteveMahon(a)discussions.microsoft.com> wrote in message news:4B08D6A9-57D4-46E5-88AD-B5FF30E72555(a)microsoft.com... >I am a SQL novice and this is my 1st time using replication. I'm using >merge > replication to publish on sever 2005 and pull subscribers using express > 2005. > All seemed great, until I could not longer add items to a particular table > on > the publisher. It gave an error stating I needed to run > sp_adjustpublisheridentityrange, which I did, and which took care of the > problem. My question is this, shouldn't that be executed by an agent at a > scheduled interval? I looked through the steps in each of the jobs, and > none > seem to include that sp. It is possible that I accidently deleted a job > while > I was first creating the publication, since it took me a couple of > attempts > to get things working. |