> Thanks for the response, but I have tested all of the code as well,
> sometimes the statement that is hanging finishes sub-second, others
> it just sits and waits, waits, waits. It is definitely a deadlock
> issue where the server is not reporting correctly, and the client is
> not giving up.

Have you considered that you may be running into a database sweep?


Sean