sql server replication: Hi all,

I have a strange error in snapshot agent. When I run snapshot agent the
agent is prepearing tables and in moment of prepearing one of the tables I
receve error with details:

CREATE UNIQUE INDEX terminated because a duplicate key was found for index
ID 5. Most significant primary key is 'type 24, len 16'. (Source:
MY_SQL_SERVER (Data source); Error number 1505)

I tried to add to publication only couple of tables and all tables from
database and in both cases it is prepearing successfully couple of tables
and in both cases at the same table comes out the same error.

Any idea what could it be?

Thanks

Are you by any chance doing merge replication? If so can you check for
duplicates in the rowguid column - another poster had this issue when he
copied a row back into the same table. If there are any duplicates, then
they'll need to be removed - either you can delete the row or drop then
readd the rowguid column.
HTH,
Paul Ibison

Thanks Paul I allready solve the problem.


U¿ytkownik "Paul Ibison" <Paul.Ibison@Pygmalion.Com> napisa³ w wiadomo¶ci
news:OK1lcouREHA.3300@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]