Home Forums SQL Server 2005 SS2K5 Replication SQL 2005 SP3- Republishing Server Error "The specified automatic identity support parameters conflict with the settings in another article" RE: SQL 2005 SP3- Republishing Server Error "The specified automatic identity support parameters conflict with the settings in another article"

  • Hi DHeath,

    The Type of replication I am doing is merge replication and I have a two hop setup where I have

    Publisher->Publisher Subscriber(Republishing Server)->Subscriber

    and I am also using Web Synchronization from the Republishing Server to the Subscriber

    with a PULL setup on the Subscriber.

    The subscriber is on SQL 2005 Express SP3 btw and the Publishers are all on sql 2005 SP3.

    When I try and create another publication on a table with Automatic Identity Key

    management i get the above error.

    The reasoning behind wanting to try out having multiple Publisher entries for the same table

    is due to the he table in question being a Global table across

    multiple companies and each subscriber only cares about data from their company so if i create

    a publication for each company then each subscriber consumes less data.

    I agree that Replication is a Monster and the less you have to manage the better but as a first step

    I would like to give it a test and see how it behaves.

    If anyone has any personal experience with this issue and can offer some advice it would be appreciated.

    Kind regards,

    MMck