SQL Server Performance Forum – Threads Archive

DB Replication

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…

Hi, refer following links : http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/7d6f87f6558a679c/c9a8c2e510c9592e%23c9a8c2e510c9592e?sa=X&oi=groupsr&start=0&num=3</a> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/83178685d4e96087/fb9c4f9186180476%23fb9c4f9186180476?sa=X&oi=groupsr&start=2&num=3</a> <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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

]]>