InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 20:07:15 GMT20http://www.sqlservercentral.com/Forums/Topic1411039-149-1.aspxjust came to know that this is duplicate post.it wastes poeple time , dont cross post.original post [url]http://www.sqlservercentral.com/Forums/Topic1411020-391-1.aspx#bm1411043[/url]Thu, 24 Jan 2013 04:18:57 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1411039-149-1.aspxcheck with sp_who2 , which spid is locking that table then for all fetched do dbcc inputbuffer(sp_id), see what kind of transaction is there then decide which spid you can killThu, 24 Jan 2013 04:17:37 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1411039-149-1.aspxWhat 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.Please Help.:(Thu, 24 Jan 2013 03:59:24 GMTpallab.santra1987