Re: Problems with identity range in merge replication.

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 14:50:03 -0500

Use sp_adjustpublisheridentityrange to make adjustment on the publisher. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"mary" <mary@dbagua.com> wrote in message 
news:%23qGYZQX0EHA.1292@TK2MSFTNGP10.phx.gbl...
>
> Hi, I have configured merge replication with pull subscriptions. One of
> the articles have an identity column as a primary key. At the begining i
> have problems with the use of the identity column so, i defined an
> identity range on the article properties. The range i defined was 500000
> for each subscribers (there are two). These procedures works fine until
> now.
>
> Today, I found that in one of the subscribers i can not insert new rows
> with the problems of the violation primary key. If i try to insert the
> same row at the publisher it works fine. it means that the identity
> range works at the publisher but not at the subscriber.
>
> I found in the books online that i can execute the
> sp_adjustpublisheridentityrange  system store procedure but i am not
> sure about it.
>
> I will appreciate a lot, if someone can help me because now the users
> can not use the application.
>
> Thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Identity columns problem in replication among n no of subscribers
    ... commands for other ranges if the not for replication constraint is enabled. ... If I am having file called EMP with identity column Recid. ... I want to give automatic range control on publisher for n no. subscribers ...
    (microsoft.public.sqlserver.replication)
  • Re: Optimal "set and forget" values?
    ... to ensure I do not have any long-term issues with the number of subscribers. ... the max identity value on the publisher will be updated. ... >>> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_MSpub_adjust_identity / why should the publisher connect to the distributor directly?
    ... The problem is that there is *no* identity column in any article. ... the subscribers are *not* updatable. ... process which can do something with it (save it in the distributor, ... There is an identity range table on the publisher which is used to track ...
    (microsoft.public.sqlserver.replication)
  • Re: creating new table in MERGE PUBLICATION
    ... You will have to reinitialize all subscribers and send the snapshot down ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... Now the situation needs to create new table at publisher side. ...
    (microsoft.public.sqlserver.replication)
  • Re: Behaviour of Merge Replication
    ... So the branch office should be the publisher, ... would you still use a Transactional Replication after knowing this? ... I normally use pull for over 10 subscribers. ... For the merge publications use central publisher in your head office. ...
    (microsoft.public.sqlserver.replication)