SQL Server Performance

Duplicate GUID on Different sites

Discussion in 'SQL Server 2005 Replication' started by m_salman786, Jun 10, 2008.

  1. m_salman786 New Member

    I have setup a merge replication and many push subscriptions. The issue i am facing right now is the generation of same GUID on more than one sites when inserting a record. this thing causes conflicts at the time of synchronization and to resolve them record from one site is deleted. This thing is happening frequently please help me in this situation.
    Please note that the GUID column always takes its default value which is NewSequentialID. I am badly stuck please help me as soon as possible
    Regards
    .
  2. MohammedU New Member

  3. m_salman786 New Member

    Let me clear the situation some more.

    I have following setup

    ACE_CMSACE_CMS (Distributer + Publisher)
    LHRLHRDB (Subscriber)
    ACEGRWCMS_GRW (Subscriber)

    there are other subscribers but i haven't allowed any data to be entered on them as i have having problems with first two (as i have told in first post)

    data is being directly entered on publisher database also on both subscribers
    now in a table at LHRLHRDB 2 records were entered and merged to publisher
    in the same table at ACEGRWCMS_GRW 2 records were entered but when i tried to merge the data 2 primary key conflicts were occured and i had to delete these records from one site.

    checked the GUIDs they were exactly the same. i am not inserting these keys using my queries but it always takes the default value which is newsequentialid().

    About IPs they are same on both sites but they are provided by my ISP and i have requested to change IP on one site. But if IP is not involved in generating GUIDs then please figure my problem out and let me know how can i resolve it

Share This Page