Progress OpenEdge - how to remove lock from table? I have some kind of bug leaving lock on table in application that is connecting to Progress OpenEdge Database. Because of the lock I'm not able to test what app is doing wrong there (since I can't test it more than once because of lock and lock seems to last for very long).

Is there a way to remove all locks from table?
You can use locking hints to select from tables that have locks on them.

select * from tblUser with (NOLOCK) ;


This is ok practice with adhoc sql.

Note Don't use in productioncode without reading and understanding documentation fully.

If you want to kill blocking processes:  http://www.kodyaz.com/articles/identify-kill-blocking-sql-server-processes.aspx