I have a SQL table that all of a sudden cannot return data unless I include "with (nolock)" on the end, which indicates some kind of lock left on my table. I've experimented a bit with dm_tran_locks to identify that there are in fact a number of locks on the table, but how do I identify I have a SQL table that all of a sudden cannot