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...