In a stackoverflow.com question the user has asked how come a SELECT statement could own a U mode lock?
The deadlock indeed suggests that the deadlock victim, a SELECT statement, is owning an U lock on the PK_B index. Why would a SELECT own an U lock?
Read More...