Here is a very simple SQL script that you can run in GoldMine to find duplicate records.


select * from contact1 as c1a, contact1 as c1b where
c1a.company=c1b.company and
c1a.contact=c1b.contact and
c1a.accountno<>c1b.accountno
order by c1a.company, c1a.contact


As it stands it looks for matches in the company and contact fields but, obviously, you could amend this to include any fields that you like.

Having found them, you could then select particular records in the Contact Search Centre and merge them manually, or you could create a group from the results set and use the merge-purge wizard to process them all.

As always though, the recommendation is to take a backup before doing any kind of data manipulation!