We have table and we are unable to truncate,delete, or rename the table. I am getting an error message "Error 1222: Lock request time out period exceeded"
Looks like there are locks on this table but I am find and end the locks. I tried SP_who2 and other Sp_lock but did not find anything. Please advice me how to resolve this issue.