The rows I was trying to delete from Enterprise Manager were duplicates. After reading some of the posts, I deleted all of the duplicates and the orginal using query analyzer....
There never should have been any unique indexes or unique keys for this table. This table is the many in a one to many relationship. We have always used VB...