??? Maybe I didn't get enough sleep last night, but... I don't believe it should be possible to provide sample data to reproduce this scenario.

To paraphrase my post, "I'm getting a FK violation on a delete from the PK table where no row exists in the FK table that violates the FK constraint."

The manual and procedure code is essentially identical:

Proc: DELETE Keywords WHERE nKeyword_Id = @nKWIdVar

Manual: DELETE Keywords WHERE nKeyword_Id = 123075