Quote Originally Posted by PAVB View Post
The two statemets above contradict each other.
You cannot have orphans and at the same time being able to successfully drop/create the FK with validate option.
I read "I tried to delete and recreate the foreign key" as he fixed the bad keys
and enabled the foreign keys. Perhaps I read to much into what he said.