SQL Server Performance

DB Replication

Discussion in 'SQL Server 2005 Replication' started by raydha, Jan 26, 2006.

  1. raydha New Member

    Hi all,

    I just curious on sql 2005 replication on different server, I give u the scenario

    Database A have 2 tables.
    (Table)Activity Log
    Field1TranID (PK)
    Field2Reftax
    Field3School

    (Table)Activity Log
    Field1TranID (PK)
    Field2Reftax
    Field3School


    Then error came out like this,
    there are no support on this when i click the microsoft support link.
    tq all.

    ****************************************
    - Adding article 10 of 10 (Error)
    Messages
    SQL Server Management Studio could not create article 'ACTIVITYLOG'. (New Publication Wizard)

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Column names in each table must be unique. Column name 'tranid' in table 'conflict_stnc_repl_ACTIVITYLOG' is specified more than once.
    Encountered server error 0 while executing <xp_execresultset>.
    Changed database context to 'stnc_efiling'. (Microsoft SQL Server, Error: 2705)

    For help, click:http://go.microsoft.com/fwlink?Prod...99&EvtSrc=MSSQLServer&EvtID=2705&LinkId=20476

    SQL Server Management Studio could not create article 'ERRORLOG'. (New Publication Wizard)

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Column names in each table must be unique. Column name 'tranid' in table 'conflict_stnc_repl_ERRORLOG' is specified more than once.
    Encountered server error 0 while executing <xp_execresultset>.
    Changed database context to 'stnc_efiling'. (Microsoft SQL Server, Error: 2705)

    For help, click:http://go.microsoft.com/fwlink?Prod...99&EvtSrc=MSSQLServer&EvtID=2705&LinkId=20476
    **************************************************

    tq alll...
  2. ghemant Moderator

    Hi,<br />refer following links :<br /<a target="_blank" href=http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/7d6f87f6558a679c/c9a8c2e510c9592e%23c9a8c2e510c9592e?sa=X&oi=groupsr&start=0&num=3>http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/7d6f87f6558a679c/c9a8c2e510c9592e%23c9a8c2e510c9592e?sa=X&oi=groupsr&start=0&num=3</a><br /><br /<a target="_blank" href=http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/83178685d4e96087/fb9c4f9186180476%23fb9c4f9186180476?sa=X&oi=groupsr&start=2&num=3>http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/83178685d4e96087/fb9c4f9186180476%23fb9c4f9186180476?sa=X&oi=groupsr&start=2&num=3</a><br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  3. raydha New Member

    thank you ghemant,

    found the solution.
    conclusion is
    1-make sure you as earlier as possible to tell your developer that the new database system will be replicate
    then hopefully they will not make a silly mistake which they use the same field name in difference tables...hehehehe

    tq all

Share This Page