I'm not sure if you can use SQL2000 replication for this.

We are using DataMirror Transformation Server to replicate data from  AS400 DB2 database to a SQL server. Go to...

you can try this:

Create table #Test(Id int,dup_id int)

GO

Insert #Test

 Select 1,      100 union all -- Multi duplicates

 Select 2,      100 union all

 Select 3,      100 union all

 Select 4,      100 union all

 Select 5,      200...

I used same statement with one more ELSE after first IF:

if (select databaseproperty('cav2dev', 'istrunclog')) = '1'

    begin

    print '   * recovery model is SIMPLE. *'

    --set @flag...