Jason,

Thanks for your time. Here is more info.

Are they set for cascade delete? NO

Do they reference another table that references the tables in the blocked SQL? YES. I list this...

Thanks, Jason.

I got the complete sql process from the trace file. There is NO any direct FK related between the table in the blocked prcoess and blocking process. Anybody has...