I have a similar problem, a table showing 7 rows to be removed and 7 identical rows to be added. It looks like its due to the primary key being nvarchar and the data being case sensitive. e.g.
One of the 7 rows has a primary key of "Gyu5A" and there is another row that has a primary key of "Gyu5a". These 7 rows are the only ones that have a lower case equivalent so I can only assume that the data comparison isn't taking in to account the collation of the column, which is case sensitive (specifically SQL_Latin1_General_CP1_CS_AS).
I have a similar problem, a table showing 7 rows to be removed and 7 identical rows to be added. It looks like its due to the primary key being nvarchar and the data being case sensitive. e.g.
One of the 7 rows has a primary key of "Gyu5A" and there is another row that has a primary key of "Gyu5a". These 7 rows are the only ones that have a lower case equivalent so I can only assume that the data comparison isn't taking in to account the collation of the column, which is case sensitive (specifically SQL_Latin1_General_CP1_CS_AS).