Row of database is unreacheble
To see open transactions which may be locking rows, execute:

SELECT * FROM sys.sysprocesses WHERE open_tran = 1


Issuing a COMMIT or ROLLBACK for those transactions would address your issue.

If you don't mind dirty reads (depends on your business rule for your particular situation) you can 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED


And this would allow you to read the table without the wait. It;s important to understand that the data would be inaccurate if the pending transaction was rolled back.