i have a table which was always updatable before, but then suddenly i can no longer update the any of the columns in the table. i can still query the whole table and the results come back very fast, but the moment i try to update a column in the table, the update query simply stalls and does nothing.

i tried using

select req_transactionUOW
from master..syslockinfo
where req_spid = -2

to see if some orphaned transaction was locking the table, but it returns no results.

i can't seems to find signs of my table being locked, but simply cannot update it. any clues as to how to fix the table or whatever state it is in?