• I believe the question was what was causing the deadlock, which was indeed the HOLDLOCK hint. Your comments are indeed accurate, but did not address the question, which specifically asked what was causing the deadlock error. Of the answers given, there was only one really correct choice.