ah, there is indeed a index which is the same as the one detailed in the error (i didnt create the database so didnt know about this. Ignorance is...

ok, i have ran

select value2 from [linjed server].[database].[dbo].

group by value having COUNT(value2) > 1

this cam back with 24689 rows, so yes, there are duplicate values already in the linked...