Snapshot generation: Error number: 2705 -- sql server replication

Chris
7/29/2005 8:27:07 AM

hi all...new to replication and 1st post here ....looking to replicate our
database and having trouble with one table. i recreated the table in
northwind to isolate it from the rest of the DB tables in the app. Same
result.
Table name: REASON
COLUMNS IN TABLE: REASON_CODE, REASON
Error:
Column names in each table must be unique. Column name 'reason_code' in
table 'conflict_Northwind1_reason' is specified more than once.
Any input on why this is happening.
I know I can change the name of the either field and resolve the
issue...however, that casues a lot of change in application logic @ this
point. TIA!
Chris

Hilary Cotter
7/30/2005 6:25:33 AM

have a look at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/repltypes_30z7.asp

it states:

There are several tracking columns added to a merge publication table. If
your publishing table has column names reserved for merge processing, you
will not be able to generate an initial snapshot because of duplicate column
names. Reserved column names are:

a.. reason_code

b.. source_object

c.. reason_text

d.. Pubid

e.. conflict_type

f.. origin_datasource

g.. tablenick

h.. create_time
You will have to change the name of reason_code.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Snapshot generation: Error number: 2705