Hi Tom, You could:
Select colName, count(*) from tblName group by colName having count(*) > 1 Ben TOM HART wrote:
I have a table that has a PK and everything works fine but today I was doing some maintenance and did a reload, when it got to reloading the suspect table I get the error that it must contain a unique value. If I do an autochk it does not show any errors. So two questions: 1. What happened, and 2. How do I find the culprit in 85K rows.Tom Hart
