What is the procedure to delete some data from Lock Table? We can't use NOLOCK for Update, delete & Insert for that.
A table Name like Business_History which is in Transaction Lock. Want to delete data where Proposal_Form_No='ABC'. If I Execute Select Operation With NOLOCK it shows 5 rows of data. But Can't delete them.
That sounds like some other process is locking the table and not releasing it. For example, a transaction that has been left open without being committed inadvertently? Tables get locked all the time, but then they should released. sp_lock and sys.dm_tran_locks should give you some information about the locks being held