>>I'm switching an index to a primary and am getting a duplicate index message. How can I find the duplicates amoung 1000's without
>>looking through them all?
>
>Select IDField, count(IDField) as nCount
> from MyTable
> group by IDField
> having nCount>1


Thanks very much!