"Michal Mienik" <tabbycat@gmail.com> wrote in message
news:7bf4571b.0501061827.1f70fb0c@posting.google.com...
> Hi,
>
> I am trying to setup replication on an SQL Server 2000 database. SP3a
> has just been installed.
>
> The Snapshot Agent fails during Replication with the following error:
>
> Preparing table '[dbo].[tblRecordStages]' for merge replication
> SourceTypeId = 5
> SourceName = WIN2KVMWARE
> ErrorCode = 1505
> ErrorText = CREATE UNIQUE INDEX terminated because a duplicate key was
> found for index ID 3. Most significant primary key is 'type 24, len
> 16'.
> CREATE UNIQUE INDEX terminated because a duplicate key was found for
> index ID 3. Most significant primary key is 'type 24, len 16'.
>
> The design of the table where the failure occurs:
>
> intDescription int datatype, 4 bytes, no nulls
> strDescription nvarchar, 255 bytes, nulls
> orderNumber int, 4 bytes, nulls
> blnPermanent bit, 1 byte, no nulls
> strRecordStageID uniqueidentifier, 16 bytes, no nulls, PK
>
> The data contained within the table:
>
> Posted as an 11kb image to keep the formatting and make it easier to
> read.
>
http://www.users.on.net/~mmienik/SQLServerHelp/sqlSvr_failed_replication_data.gif
>
> The error message says index ID 3 contains a duplicate value. Which
> ID is it? There are no duplicates in the table yet I always get this
> error message.
>
> tblRecordStages.strRecordStageID is referenced as a FK by another
> table but this is correct.
>
> For the record the data was manually imported from an Access database
> where Replication did exist (with the same data) and worked perfectly.
>
> Does anyone have any suggestions? Thanks.